创建sql表语法
https://www.icode9.com/content-2-147046.html
1、设置数据库的基础配置
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS=0;
SET global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
SET session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
2、创建数据库基本语法
DROP TABLE IF EXISTS dbA.`monitor_t`;
CREATE TABLE dbA.`monitor_t` (
`uuid` varchar(36) NOT NULL,
`target_option_identifier` varchar(18) DEFAULT '',
`create_user` varchar(18) NOT NULL,
`create_ts` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`last_mod_user` varchar(18) DEFAULT NULL,
`last_mod_ts` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`uuid`),
KEY `definition_uuid_idx` (`monitor_target_definition_uuid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
网友评论