要求:
CREATE TABLE `hy_companys` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`company` varchar(255) DEFAULT NULL COMMENT '公司名称',
`url` varchar(500) DEFAULT NULL COMMENT '链接',
`name` varchar(50) DEFAULT NULL COMMENT '联系人',
`tel` varchar(20) DEFAULT NULL COMMENT '联系方式',
`origin_url` varchar(500) DEFAULT NULL COMMENT '公司链接',
`main_products` varchar(500) DEFAULT NULL COMMENT '主营产品',
PRIMARY KEY (`id`),
KEY `company` (`company`) USING BTREE,
KEY `url` (`url`) USING BTREE,
KEY `name` (`name`) USING BTREE,
KEY `tel` (`tel`) USING BTREE,
KEY `origin_url` (`origin_url`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
展示:
刚开始在python里面尝试建表:
db = pymysql.connect(host='1', user='1', password='1', database='1')
cursor = db.cursor()
cursor.execute("drop table if EXISTS xixi_info")
sql = """create table `xixi_info`(`id` int(11) default null,`company` varchar(255),`url` varchar(500),`name` varchar(50),
`tel` varchar(20),`origin_url` varchar(500),`main_products` varchar(500))"""
sql_1= """ALTER TABLE `xixi_info` ADD INDEX company ( `company` )"""
cursor.execute(sql)
cursor.execute(sql_1)
cursor.close()