1.插入记录--insert into
insert into table_name(field1,field2,field3) values(value1,value2,value3);
也可以不用指定列名,但values后面的顺序应该和列的排列顺序一致
insert into table_name values(value1,value2,value3);
或同时插入多条记录
insert into table_name(field1,field2,field3) values(value1,value2,value3),(value1,value2,value3),(value1,value2,value3);
也可以仅对指定的列插入值,对那些没指定列则会使用默认值,若在创建表时没指定默认值,则为null
insert into table_name(field1,field2) values(value1,value2);
2.修改记录--update
update table_name set field1=value1,field2=value2 where . . .
mysql> select * from zhuzhu;
+------+--------+------+------+
| id | myname | id1 | age |
+------+--------+------+------+
| NULL | zhang3 | NULL | NULL |
| NULL | li4 | NULL | NULL |
+------+--------+------+------+
2 rows in set (0.00 sec)
mysql> update zhuzhu set id=1 where myname='zhang3';
Query OK, 1 row affected (0.05 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from zhuzhu;
+------+--------+------+------+
| id | myname | id1 | age |
+------+--------+------+------+
| 1 | zhang3 | NULL | NULL |
| NULL | li4 | NULL | NULL |
+------+--------+------+------+
2 rows in set (0.01 sec)
3.删除记录-delete from
delete from table_name where ... #若没有where则是删除表中的所有的数据