创建数据库(MySQL),如abc,创建表T_TEST,如下所示:
CREATE DATABASE abc DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_general_ci; use abc; set names utf8mb4; CREATE TABLE `T_TEST` ( `ID` INT(11) NOT NULL AUTO_INCREMENT COMMENT '编号;自增数字', `NAME` VARCHAR(100) COMMENT '名称;姓名', PRIMARY KEY (`ID`) )COMMENT='测试' COLLATE='utf8mb4_bin' ENGINE=InnoDB;