MySql 语句

新建表

DROP TABLE IF EXISTS `User`;
CREATE TABLE IF NOT EXISTS `User`(
   `id` VARCHAR(100) NOT NULL,
   `` bool,
   `` int,
   `` VARCHAR(255),
   `` DATE,
   
   -- foreign key  
   PRIMARY KEY ( `id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

添加外键


posted @ 2021-09-07 11:15  wesson2019  阅读(21)  评论(0编辑  收藏  举报