MySql 大量建立、匯入執行個體

標籤：rod   mysql   reg   tao   arch   nbsp   sts   price   分享   

 

1.建立sql（例如，taobao，dangdang）：

DROP DATABASE IF EXISTS taobao;CREATE DATABASE taobao CHARSET=utf8;USE taobao;CREATE TABLE t_product(id      INT,name    VARCHAR(20),pic     VARCHAR(20),regTime DATETIME,price   DOUBLE(10,2),did     INT);CREATE TABLE t_ptype(id INT,name   VARCHAR(20),pcount INT);INSERT INTO t_ptype VALUES(1,‘book‘,3);INSERT INTO t_ptype VALUES(2,‘dvd‘,3);INSERT INTO t_ptype VALUES(3,‘cd‘,1);INSERT INTO t_product VALUES(1,‘b1‘,‘1.jpg‘,now(),100,1);INSERT INTO t_product VALUES(2,‘b2‘,‘1.jpg‘,now(),100,1);INSERT INTO t_product VALUES(3,‘b3‘,‘1.jpg‘,now(),100,1);INSERT INTO t_product VALUES(4,‘dvd1‘,‘1.jpg‘,now(),100,2);INSERT INTO t_product VALUES(5,‘dvd2‘,‘1.jpg‘,now(),100,2);INSERT INTO t_product VALUES(6,‘dvd3‘,‘1.jpg‘,now(),100,2);INSERT INTO t_product VALUES(7,‘cd‘,‘1.jpg‘,now(),100,3);

 

SET NAMES UTF8;DROP DATABASE IF EXISTS dangdang;CREATE DATABASE dangdang CHARSET=utf8;USE dangdang;CREATE TABLE dd_category(id      INT,name    VARCHAR(20),bcount  INT);INSERT INTO dd_category VALUES(100,‘電腦類‘,3);INSERT INTO dd_category VALUES(200,‘曆史類‘,2);INSERT INTO dd_category VALUES(300,‘美食類‘,1);CREATE TABLE dd_book(id      INT,title   VARCHAR(20),price   DOUBLE(10,2),pic     VARCHAR(100),pubdate DATETIME,did     INT);INSERT INTO dd_book VALUES(1,‘電腦1‘,100,‘1.jpg‘,now(),100);INSERT INTO dd_book VALUES(2,‘電腦2‘,100,‘1.jpg‘,now(),100);INSERT INTO dd_book VALUES(3,‘電腦3‘,100,‘1.jpg‘,now(),100);INSERT INTO dd_book VALUES(4,‘曆史1‘,101,‘1.jpg‘,now(),200);INSERT INTO dd_book VALUES(5,‘曆史2‘,101,‘1.jpg‘,now(),200);INSERT INTO dd_book VALUES(6,‘美食‘,101,‘1.jpg‘,now(),300);

 

2、建立匯入sql（例如,test）

SOURCE  d:/taobao.sqlSOURCE  d:/dangdang.sql

 

3、在命令列匯入

 

 

這裡test.sql檔案在d根目錄盤下

MySql 大量建立、匯入執行個體