mysql学习笔记(6-DML命令)
DML:INSERT, DELETE, UPDATE, SELECTINSERT INTO:
INSERTtbl_name[(col1,...)]{VALUES|VALUE}(val1, ...),(...),...
注意:
字符型:引号;
数值型:不能用引号;
SELECT:
(1) SELECT*FROMtbl_name;
(2) SELECTcol1, col2, ...FROMtbl_name;
显示时,字段可以显示为别名;
col_nameAScol_alias
(3)SELECTcol1, ...FROM tbl_nameWHERE clause;
WHERE clause:用于指明挑选条件;
col_name 操作符 value:
age > 30;
操作符(1) :
>, =,
页:
[1]