第1章 生成数据表

1.1 导入外部数据

1.2 创建数据表

#创建数据表字段
CREATE TABLE data1(
	id INT(10),
	Record_date DATE,
	city VARCHAR(255),
	age VARCHAR(255),
	category VARCHAR(255),
	price FLOAT(10)
);

#插入数据
INSERT INTO data1
VALUES
(1001, 20130102, 'Beijing ',23, '100-A', 1200),
(1002, 20130203, 'SH', 44,'100-B', 'null'),
(1003, 20130305, 'guangzhou', 54,'110-A', 2133),
(1004, 20130403, 'Shenzhen', 32,'110-C', 5433),
(1005, 20130501, 'shanghai', 34,'210-A', ''),
(1006, 20130603, 'BEIJING', 32,'130-F', 4432);

SELECT * FROM data1;

#创建数据表data2
CREATE TABLE data2(
	id INT(10),
	gender VARCHAR(255),
	pay VARCHAR(255),
	mp VARCHAR(255)
);

#插入值
INSERT INTO data2
VALUES
(1001, 'male', 'Y',10),
(1002, 'female', 'N', 12),
(1003, 'male', 'Y', 20),
(1004, 'female', 'Y', 40),
(1005, 'male', 'N', 40),
(1006, 'female', 'Y', 40),
(1007, 'male', 'N', 30),
(1008, 'female', 'Y', 20);

SELECT * FROM data2;