(1) 用firefox 連上你的本機伺服器/本機首頁上方的phpMyAdmin並用root帳號登入
use selldb;
CREATE TABLE goods (
gdsno char(20) primary key,
gdsname char(30) default 'x',
spec char(10) default '個',
cost float default 0 ,
price_in float default 0,
price_special float default 0,
price_sell float default 0,
unit char(10) default '個' ,
stock_qty int default 0,
fac_no char(20) default '0',
mem varchar(80) default 'none' );
INSERT INTO goods (GDSNO,GDSNAME,SPEC, COST,PRICE_in,PRICE_SPECIAL,
PRICE_SELL, UNIT,STOCK_QTY,FAC_NO,MEM)
VALUES ('a001','蕃茄','個', 10,10,20,20,'個',200,'077','金農行');
(3)以上執行的效果如下：
(4)請用如下SQL指令為以上的goods資料表再加入三筆資料。
INSERT INTO goods (GDSNO,GDSNAME,SPEC, COST,PRICE_in,PRICE_SPECIAL,
PRICE_SELL, UNIT,STOCK_QTY,FAC_NO,MEM)
VALUES ('b001','香蕉','斤', 20,20,30,30,'個',400,'077','金農行');
INSERT INTO goods (GDSNO,GDSNAME,SPEC, COST,PRICE_in,PRICE_SPECIAL,
PRICE_SELL, UNIT,STOCK_QTY,FAC_NO,MEM)
VALUES ('c001','芭樂','斤', 40,40,50,50,'斤',800,'077','金農行');
INSERT INTO goods (GDSNO,GDSNAME,SPEC, COST,PRICE_in,PRICE_SPECIAL,
PRICE_SELL, UNIT,STOCK_QTY,FAC_NO,MEM)
VALUES ('d001','木瓜','斤', 50,50,60,60,'斤',1600,'077','金農行');
(5)用SQL指令將以上的goods資料表的所有資料錄的指定欄位列出。
select GDSNO,GDSNAME, COST, UNIT,STOCK_QTY,mem from goods結果如下：