MySQL 資料表資料的新增、修改、刪除、查詢 (insert, update, delete, select)

新增:
INSERT INTO '資料表名' VALUES (欄位值1, 欄位值2, ...)

或是
INSERT INTO '資料表名' ('欄位名1','欄位名2') VALUES (欄位值1, 欄位值2)

example:
INSERT INTO 'visitor' VALUES ( 'rex', 'boy', '22' )
or
INSERT INTO 'visitor' ( 'name', 'sex', 'age' ) VALUES ( 'rex', 'boy', '22' )

修改:
UPDATE '資料表名' SET '欄位2' = ' 值2 ' WHERE '欄位1' = " 值1 "
example
UPDATE 'visitor' SET 'age'='12', 'sex'='girl' WHERE 'id'='name'

刪除:
DELETE FROM '資料表名' [限制]
example
DELETE FROM 'visitor' WHERE 'name'='rex'

查詢:
SELECT '欄位名' FROM '資料表名' [限制] 
example
SELECT 'age','sex' FROM 'visitor' WHERE 'name'='rex'
or
SELECT * FROM 'visitor' ORDER BY 'name'