大一综合项目：创建数据库

#设置当前操作的数据库为mydb
DROP DATABASE IF EXISTS mydb;

CREATE DATABASE mydb;

USE mydb;


#判断表
DROP TABLE IF EXISTS user;
#创建表
CREATE TABLE user(

userId int PRIMARY key auto_increment,

userName VARCHAR(20),

pwd VARCHAR(20),

sex VARCHAR(2),

addr VARCHAR(50)

);

INSERT into user VALUE(1,'jack','123','男','河南');
INSERT into user VALUE(2,'luck','333','女','河北');
INSERT into user VALUE(3,'Tom','666','男','山东');

SELECT * from user;

#判断删除表
drop TABLE IF EXISTS goods;
#创建商品信息表
CREATE TABLE goods(

goodsId int PRIMARY key auto_increment,

goodsName VARCHAR(20),

price double,

stock int,

supplier VARCHAR(50)

)auto_increment=1;

INSERT INTO goods VALUE(1,'泡面',3.5,50,'康师傅');
INSERT INTO goods VALUE(2,'牛奶',5.5,60,'蒙牛');
INSERT INTO goods VALUE(3,'瓜子',6.5,30,'金鸽');
INSERT INTO goods(goodsName,price,stock,supplier) VALUE('面包',6.5,30,'金jj');

SELECT * FROM goods;