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

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','1957381159@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', '2912970565@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','1957381159@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', '2912970565@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')