一、创建数据库及表
建立数据库create database dic character set utf8;
建表CREATE TABLE `dic` (
`id` int(22) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘id‘,
`principal` varchar(213) CHARACTER SET utf8 NOT NULL COMMENT ‘负责人‘,
`use` varchar(222) CHARACTER SET utf8 NOT NULL COMMENT ‘用途‘,
`type` varchar(222) CHARACTER SET utf8 NOT NULL COMMENT ‘机器类型‘,
`model` varchar(222) CHARACTER SET utf8 NOT NULL COMMENT ‘机器型号‘,
`place` varchar(222) CHARACTER SET utf8 NOT NULL COMMENT ‘位置‘,
`IP` varchar(222) CHARACTER SET utf8 NOT NULL COMMENT ‘IP‘,
`addtime` datetime NOT NULL COMMENT ‘时间‘,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
二、编写相关脚本
注意事项
mysql -u用户名 -p密码 -e "命令;" 多命令都写在双引号里面,通过分号分割。
INSERT INTO `