CREATE DATABASE xxx ;

CREATE TABLE xxxx(
aaa char(30),
bbb char(30),
ccc char(30)
)

 

INSERT INTO xxx (column1 , column2, column3)
VALUES (‘100′, ‘300’ , ‘500’)

行是column ———  列是row  l,由左而右由上到下.所以行列.

SELECT aaa FROM table_name選擇table_name 的aaa欄
SELECT * FROM table_name   選擇table_name全部列*

$dbc = mysql_connect(‘localhost’, ‘用戶名’, ‘密碼’, ‘表格’)

mysqli / mysql / PDO 差異