MYSQL5.7版写法

MYSQL5.7版写法

创建表
CREATE TABLE Tables_base(
TB1 BIGINT UNSIGNED AUTO_INCREMENT,
TB2 VARCHAR(100),
TB3 VARCHAR(100),
TB4 VARCHAR(100),
TB5 VARCHAR(100),
TB6 VARCHAR(100),
PRIMARY KEY(TB1)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

导入数据
LOAD DATA LOCAL INFILE '~/python/保险产品管理.csv' INTO TABLE Product_catalogue
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';


删除表
DROP TABLE Product_catalogue;


写入数据
INSERT INTO Task_base
(task_id,end_reason)
VALUES
("1","OK");

INSERT INTO Tables_base
(TB2,TB3,TB4,TB5,TB6)
VALUES
("表信息库","Tables_base","TB1","(表主键)","ID"),
("表信息库","Tables_base","TB2","中文表名","Chine_table_name");