mysql建表、插入语句

mysql建表语句

CREATE TABLE members (
id INT,
username VARCHAR (255),
posts_number VARCHAR (255),
pass VARCHAR (255),
email VARCHAR (255)
)
CREATE TABLE posts (
id INT,
members_id VARCHAR (255),
title VARCHAR (255),
content VARCHAR (255),
addtime VARCHAR (255)
)

mysql插入语句

INSERT INTO members(id,username,posts_number,pass,email) VALUE(1,‘聂艳丽’,‘aaa’,‘bbb’,‘ccc’);


版权声明:本文为nieyanli91原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。