Flask-Proj/sqlalchemy_sample.sql at main · Sirius147/Flask-Proj · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
drop database restaurant;

drop table restaurant;
drop table menu_item;

CREATE DATABASE restaurant default CHARACTER SET UTF8;
-- db 생성

use restaurant;

use madang;
select * from customer;
select * from book where publisher='이상미디어' and price>=13000;

select * from restaurant;
select * from menu_item;

CREATE DATABASE bookstore default CHARACTER SET UTF8;
-- db 생성

use bookstore;