mysql建表实例utf8_Mysql建表好的例子

DROP TABLE IF EXISTS `sys_warehouse_area`;

CREATE TABLE `sys_warehouse_area` (

`id` bigint(20) NOT NULL COMMENT ‘仓库区域编号‘,

`name` varchar(50) NOT NULL DEFAULT ‘‘ COMMENT ‘仓库区域名称‘,

`lang_code` varchar(20) NOT NULL DEFAULT ‘‘ COMMENT ‘多语言代码‘,

`status` bit(1) NOT NULL DEFAULT b‘0‘ COMMENT ‘状态‘,

`type` int(11) NOT NULL DEFAULT ‘0‘ COMMENT ‘仓库区域类型，1 大包裹区域，2小包裹区域‘,

`create_user` varchar(150) NOT NULL DEFAULT ‘‘ COMMENT ‘创建人‘,

`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间‘,

`update_user` varchar(150) NOT NULL DEFAULT ‘‘ COMMENT ‘更新人‘,

`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘更新时间‘,

`delete_status` bit(1) NOT NULL DEFAULT b‘0‘ COMMENT ‘是否删除‘,

`delete_user` varchar(150) NOT NULL DEFAULT ‘‘ COMMENT ‘删除人‘,

`delete_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘删除时间‘,

`remarks` varchar(200) NOT NULL DEFAULT ‘‘ COMMENT ‘备注‘,

`pass_no` varchar(30) NOT NULL DEFAULT ‘‘ COMMENT ‘格口号‘,

PRIMARY KEY (`id`) USING BTREE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘仓库区域表‘;

CREATE TABLE `Testuser` (

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`username` varchar(64) NOT NULL DEFAULT ‘‘,

`mobile` int(10) unsigned NOT NULL DEFAULT ‘0‘,

`shijian` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

原文：https://www.cnblogs.com/chengjun/p/9186964.html