lzf79 发表于 2018-10-9 08:40:27

mysql学习笔记(6-DML命令)

  DML:INSERT, DELETE, UPDATE, SELECT
  INSERT 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]
查看完整版本: mysql学习笔记(6-DML命令)