插入一条记录:
mysql> insert into table_name (column_name1,column_name2,.) values (value1,value2,..);
更新一条记录:
mysql> update tbl_name
set col_name1=expr1 [, col_name2=expr2 ...][WHERE where_definition]
[ORDER BY ...][LIMIT row_count];
删除一条记录:
mysql>delete from table_name where id=XX;
删除整个表的数据:
mysql> drop from table_name;
查询一条记录:
mysql>select * from table_name where id=XX;
mysql增删改查
最新推荐文章于 2023-01-17 11:17:21 发布