mysql建表文档_mysql建表建库

「爱情、让人受尽委屈。」 2022-11-01 00:48 218阅读 0赞

create database if not exists \`dbname\`;

DROP TABLE IF EXISTS \`tbname\`;

CREATE TABLE \`tbname\`(...)

用户登录user

查看贴子

用户发贴

回复贴子

create database if not exists \`dbname\`;

DROP TABLE IF EXISTS \`tbname\`;

CREATE TABLE \`tbname\`(...)

表：

usr:

username

password

create table usr

(username char(15) primary key,

password char(15)

)

topic:

topicID

topicName

TContent

Ttime

TUser

create talbe topic

(topicID int auto\_increment primary key,

topicName varchar(50),

TContent text,

Ttime date,

TUser char(15)

)

alter table topic

add constraint FK\_TUser foreign key(TUser) references usr(username);

answerTopic

AnUser

AnTime

AnContent

topicID

create table answerTopic

(

AnTopicID int auto\_increment primary key,

AnUser char(15),

Antime date ,

AnContent text,

topicID int

)

alter table answerTopic

add constraint FK\_anuser foreign key(AnUser) references usr(username);

alter talbe answerTopic

add constraint FK\_topicID foreign key(topicID) references topic(topicID);

drop table if exists \`usr\`;

create table usr

(username char(15) primary key,

password char(15)

);

drop table if exists \`topic\`;

create table topic

(topicID int auto\_increment primary key,

topicName varchar(50),

TContent text(1000),

Ttime date,

TUser char(15)

);

drop table if exists \`answerTopic\`;

create table answerTopic

(

AnTopicID int auto\_increment primary key,

AnUser char(15),

Antime date ,

AnContent text,

topicID int

);

alter table topic

add constraint FK\_TUser foreign key(TUser) references usr(username);

alter table answerTopic

add constraint FK\_anuser foreign key(AnUser) references usr(username);

alter table answerTopic

add constraint FK\_topicID foreign key(topicID) references topic(topicID);

mysql建表文档_mysql建表建库

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 mysql建库建表的SQL语句

相关 mysql 建表建索引

相关 MySQL 笔记2 建库建表删表删库

相关 mysql建_mysql简单建表

相关 mysql批量建库建表实践

相关 mysql建表文档_mysql建表建库

相关 Mysql 建库建表

相关 MySQL建库建表

相关 python基础-15-mysql建库、建表

相关 mysql建库建表约束