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’, ‘用戶名’, ‘密碼’, ‘表格’)