Mysql Learning Notes (6-DML command)
DML:INSERT, DELETE, UPDATE, SELECT
INSERT INTO:
INSERT [INTO] tbl_name [(col1,...)] {VALUES | VALUE} (val1,...), (...),...
Note:
Character type: quotation mark
Numeric: cannot use quotation marks
SELECT:
(1) SELECT * FROM tbl_name
(2) SELECT col1, col2, FROM tbl_name
When displayed, fields can be displayed as aliases
Col_name AS col_alias
(3) SELECT col1, FROM tbl_name WHERE clause
WHERE clause: used to specify selection criteria
Col_name operator value:
Age > 30
Operator (1):
>, =
