INSERT INTO 格式 //通用格式 INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...); //使用默认顺序 INSERT INTO table_name VALUES (...

UPDATE 语法格式 UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; S1.常用更新数据用法 UPDATE test_master SET pwd = 'admin' ...

DELETE 语法格式 DELETE FROM table_name WHERE condition; S1.常用用法 DELETE FROM      test_master WHERE      bindNo = 'bn002' S2.清空表 ...

SELECT语句 语法格式 //选择字段 SELECT column1, column2, ... FROM table_name; //全表   SELECT * FROM table_name; S1.全表查询 SELECT      * FROM ...