数据的操作

来源：互联网发布：撕开照片衣服的软件编辑：程序博客网时间：2024/06/03 22:39

##数据的操作###插入插入完整数据记录INSERT INTO table_name (field1,field2...fieldn)VALUES(value1,value2...valuen);field:字段名value:数值INSERT INTO table_name VALUES(value1,value2...valuen);插入部分数据记录INSERT INTO table_name (field1,field2...fieldn)VALUES(value1,value2...valuen);插入多条数据记录INSERT INTO table_name (field1,field2...fieldn)VALUES(value1,value2...valuen)，  (value1,value2...valuen)，  ......      (value1,value2...valuen);插入查询结果INSERT INTO table_name(field1,field2...fieldn)SELECT (field21,field22...field2n) FROM table_name2WHERE...#更新更新特定数据记录UPDATE table_nameSET field1=value1,field2=value2,...fieldn=valuen WHERE ...更新所有数据记录UPDATE table_nameSET field1=value1,field2=value2,...fieldn=valuen WHERE（条件必须覆盖所有数据记录）UPDATE table_nameSET field1=value1,field2=value2,...fieldn=valuen;#删除删除特定数据记录DELETE FROM table_name WHERE CONDITION;删除所有数据记录DELETE FROM table_name WHERE（条件必须覆盖所有数据记录）;DELETE FROM table_name;

0 0