dbsql.md · 蒋汶真/aqoeous-graphql

# 创建语句

## mysql老版本
```sql
use mysql;
drop database aqoeous_db1;

drop user 'aqoeous_db1';

create schema aqoeous_db1 default character set utf8 collate utf8_general_ci;

create user 'aqoeous_db1'@'%' identified by 'aqoeous_db1';

revoke all on *.* from aqoeous_db1;

grant select,insert,update,delete,create on aqoeous_db1.* to aqoeous_db1;

select * from mysql.user;

flush  privileges;

use mysql;
drop database aqoeous_db2;

drop user 'aqoeous_db2';

create schema aqoeous_db2 default character set utf8 collate utf8_general_ci;

create user 'aqoeous_db2'@'%' identified by 'aqoeous_db2';

revoke all on *.* from aqoeous_db2;

grant select,insert,update,delete,create on aqoeous_db2.* to aqoeous_db2;

select * from mysql.user;

flush  privileges;
```

## mysql8.0以上

```sql

-- drop database if exists virtualdb;
-- drop user if exists virtualdb;
create database virtualdb character set utf8mb4;

create user 'virtualdb'@'%' identified by 'virtualdb';

grant all privileges on virtualdb.* to 'virtualdb'@'%';

-- drop database if exists aqoeous_db1;
-- drop user if exists aqoeous_db1;
create database aqoeous_db1 character set utf8mb4;

create user 'aqoeous_db1'@'%' identified by 'aqoeous_db1';

grant all privileges on aqoeous_db1.* to 'aqoeous_db1'@'%';

-- drop database if exists aqoeous_db2;
-- drop user if exists aqoeous_db2;
create database aqoeous_db2 character set utf8mb4;

create user 'aqoeous_db2'@'%' identified by 'aqoeous_db2';

grant all privileges on aqoeous_db2.* to 'aqoeous_db2'@'%';

flush privileges;

```

## 建表语句
```sql
-- drop table if exists aqoeous_db1.shop;
create table aqoeous_db1.shop
(
    shop_id bigint(20) unsigned not null auto_increment comment '主键' primary key ,
    name      varchar(512)        not null comment '名称'
) engine = innodb default charset = utf8mb4 auto_increment = 1000 comment = '商店';

-- drop table if exists aqoeous_db2.item;
create table aqoeous_db2.item
(
    item_id bigint(20) unsigned not null auto_increment comment '主键' primary key ,
    shop_id bigint(20)  unsigned not null  comment '商店ID',
    name      varchar(512)        not null comment '名称'
) engine = innodb default charset = utf8mb4 auto_increment = 1000 comment = '商店';
```

```sql
INSERT INTO aqoeous_db1.shop (shop_id, name) VALUES (1, '祖名豆制品');
INSERT INTO aqoeous_db1.shop (shop_id, name) VALUES (2, '水果超市');
INSERT INTO aqoeous_db1.shop (shop_id, name) VALUES (3, '茶叶蛋专卖');
INSERT INTO aqoeous_db1.shop (shop_id, name) VALUES (4, '饮料专卖');
INSERT INTO aqoeous_db1.shop (shop_id, name) VALUES (5, '饼干专卖');
INSERT INTO aqoeous_db1.shop (shop_id, name) VALUES (6, '包子铺');
INSERT INTO aqoeous_db1.shop (shop_id, name) VALUES (7, '蛋糕店');
INSERT INTO aqoeous_db1.shop (shop_id, name) VALUES (8, '香烟专卖');
INSERT INTO aqoeous_db1.shop (shop_id, name) VALUES (9, '啤酒超市');

INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (1, '油豆腐');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (1, '豆干');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (1, '臭豆腐');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (2, '西瓜');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (2, '香蕉');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (2, '苹果');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (2, '皇冠梨');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (2, '百香果');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (2, '桔子');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (2, '葡萄');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (2, '文旦');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (3, '五香鹅蛋');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (3, '家养鸡蛋');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (3, '农家鸭蛋');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (4, '可口可乐');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (4, '红牛');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (4, '康师傅绿茶');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (5, '奥利奥');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (5, '旺仔小馒头');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (6, '够不理');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (7, '蒸蛋糕');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (8, '阿利');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (8, '华子');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (8, '小溪');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (8, '利群国色天香');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (9, '茅台');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (9, '五粮液');
INSERT INTO aqoeous_db2.item (shop_id, name) VALUES (9, '剑南春');
```

蒋汶真/aqoeous-graphql

简介

发行版

贡献者

近期动态

蒋汶真/aqoeous-graphql .gitee-modal { width: 500px !important; }

简介

发行版

贡献者

近期动态

搜索帮助

蒋汶真/aqoeous-graphql