数据库系统经典之两库-----Mysql

ゞ浴缸里的玫瑰 2024-03-23 23:27 58阅读 0赞

>     CREATE DATABASE spring6;
>     USE spring6;
>     CREATE TABLE users(id INT AUTO_INCREMENT PRIMARY KEY,real_name VARCHAR(100),age INT);
>     INSERT INTO users(id,real_name,age) VALUES(1,'张三',30);
>     INSERT INTO users(id,real_name,age) VALUES(2,'李四',30);
> 
> CREATE DATABASE spring6;  
> USE spring6;  
> CREATE TABLE users(id INT AUTO\_INCREMENT PRIMARY KEY,real\_name VARCHAR(100),age INT);  
> INSERT INTO users(id,real\_name,age) VALUES(1,'张三',30);  
> INSERT INTO users(id,real\_name,age) VALUES(2,'李四',30);

>     create database mall;
>     use mall;
>     create table users(email varchar(100) primary key,pssword varchar(100),username varchar(100));
>     insert into users(username,pssword,email) values('毓敏','123456','1571345941@qq.com');
>     create table shoppingcart(num int primary key,email varchar(100),product_name varchar(100),amount int);
>     INSERT INTO shoppingcart(num, email, product_name, amount) VALUES ('1', '1571345941@qq.com', '丹麦皇冠曲奇饼干礼盒', '1')
>     create table product(product_name varchar(100) primary key,brand_name varchar(100),amount int,price double,description varchar(100),type_name varchar(100),statue varchar(100));
>     insert into product(product_name,brand_name,amount,price,description,type_name,statue) values('丹麦皇冠曲奇饼干礼盒','曲奇饼干',6,88,'商品编号：1546211上架时间：2019-09-06 09:19:09商品毛重：160.00g商品产地：印尼','美食','available')
> 
> create database mall;  
> use mall;  
> create table users(email varchar(100) primary key,pssword varchar(100),username varchar(100));  
> insert into users(username,pssword,email) values('毓敏','123456','1571345941@qq.com');  
> create table shoppingcart(num int primary key,email varchar(100),product\_name varchar(100),amount int);  
> INSERT INTO shoppingcart(num, email, product\_name, amount) VALUES ('1', '1571345941@qq.com', '丹麦皇冠曲奇饼干礼盒', '1')  
> create table product(product\_name varchar(100) primary key,brand\_name varchar(100),amount int,price double,description varchar(100),type\_name varchar(100),statue varchar(100));  
> insert into product(product\_name,brand\_name,amount,price,description,type\_name,statue) values('丹麦皇冠曲奇饼干礼盒','曲奇饼干',6,88,'商品编号：1546211上架时间：2019-09-06 09:19:09商品毛重：160.00g商品产地：印尼','美食','available')