创建数据库(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;


目录
Copyright © objectsql.com 2021 闽ICP备17009107号-3

闽公网安备 35020302035600号