使用 MySQL 5 建立一資料庫和資料表

CREATE DATABASE demo;
USE demo;
CREATE TABLE t_message (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name CHAR(20) NOT NULL,
email CHAR(40),
msg TEXT NOT NULL
);

CRUD操作
INSERT
INSERT INTO t_message VALUES (1, 'shitRick', 'rick_tsai@hotmail.com', 'a good man.');
*字串資料必須在雙引號或單引號中，數字和日期則不用
若不想依照資料表欄位順序插入資料，則：
INSERT INTO t_message (name, msg) VALUES('shitRick', 'a good man.');
也可以一次加入多筆資料，如：
INSERT INTO t_message VALUES
(1, 'shitRick', 'rick_tsai@hotmail.com', 'a good man.'),
(2, 'Wang', 'wang@msn.com', 'a pitcher.'),
(3, 'AustinPower', 'charmed@mojo.com', 'a movie actor');
SELECT
SELECT * FROM 資料表;
SELECT * FROM t_message WHERE name='shitRick' AND email='rick_tsai@hotmail.com';
SELECT name, msg FROM t_message;
SELECT * FROM t_message ORDER BY name;
SELECT * FROM t_message ORDER BY name DESC;
UPDATE
UPDATE t_message SET name='AustinPower' WHERE id=1;
UPDATE t_message SET name='AustinPower', email='charmed@mojo.com' WHERE id=1;
DELETE
DELETE FROM t_message WHERE id=1;
DELETE FROM t_message; //全部刪除