mysql语法01-创建表格

创建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;