创建数据库和表SQL
程序员文章站
2024-03-21 10:53:04
...
创建数据库
create database `cloud01`
defalut character set utf8mb4
collate utf8mb4_general_ci;
创建表
use databasename;
drop table if exists `payment`;
create table `payment`(
`id` bigint(20) not null auto_increment COMMENT 'ID',
`serial` varchar(200) default '',
PRIMARY key(`id`)
)ENGINE = INNODB auto_increment=1 default charset=utf8