MySql 插入数据

MySql 插入数据

 

语法

insert into table_name (file1,file2) values(file1Value,file2Value);

 

实例

insert into table_name (id,name) values(1,'测试');

insert into table_name (id,name) select id,name from table_name

查询的字段与要插入的字段要一一匹配