SQLテーブルを作成
戻る
<![CDATA[
limbs.sql
------------------------------------------------------------------------
DROP TABLE IF EXISTS limbs;
CREATE TABLE limbs
(
things VARCHAR(20),
legs INT,
arms INT
);
INSERT INTO limbs (things,legs,arms) VALUES('human',2,2);
INSERT INTO limbs (things,legs,arms) VALUES('insect',6,0);
INSERT INTO limbs (things,legs,arms) VALUES('squid',0,10);
INSERT INTO limbs (things,legs,arms) VALUES('octopus',0,8);
INSERT INTO limbs (things,legs,arms) VALUES('fish',0,0);
INSERT INTO limbs (things,legs,arms) VALUES('centipede',100,0);
INSERT INTO limbs (things,legs,arms) VALUES('+eg Leg Pete',1,2);
------------------------------------------------------------------------
方法１
C:\database\sql>mysql cookbook < limbs.sql -u cbuser -p
Enter password: ******
方法２
C:\database\sql>mysql -u cbuser -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
mysql> use cookbook;
Database changed
mysql> source limbs.sql
Query OK, 0 rows affected (0.08 sec)
........
]]>
戻る
阳城县|
苗栗市|
田东县|
平顶山市|
华池县|
鸡西市|
宁强县|
洛扎县|
阿勒泰市|
禄劝|
西城区|
华池县|
罗田县|
象山县|
根河市|
平武县|
安新县|
中卫市|
西安市|
田东县|
巴青县|
常州市|
普宁市|
遂昌县|
尚志市|
五华县|
太谷县|
惠来县|
广汉市|
诸暨市|
绵竹市|
文山县|
新泰市|
蕲春县|
上蔡县|
江油市|
灌阳县|
苍溪县|
延庆县|
佛学|
上栗县|