MySql 批量创建、导入实例

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.sql
SOURCE  d:/dangdang.sql

 

3、在命令行导入

 

 

这里test.sql文件在d根目录盘下

MySql 批量创建、导入实例

标签：rod   mysql   reg   tao   arch   nbsp   sts   price   分享