mysql 创建数据表
基本语法:
CREATE TABLE IF NOT EXISTS `table_name`(
`id` int UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NUll,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_tablename_name` (`name`, `xxx`),
KEY `idx_tablename_deleted_at` (`deleted_at`),
) ENGINE = Innodb DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;
show engines;
查看引擎,default表示创建表时默认使用的引擎
show variables like ‘%character%’;
查看数据集
show variables like '%collation%‘;
查看collation
show tables;
查询所有的数据表
show create table xxx;
查看表创建语句