USE store;
SHOW TABLES;
SELECT*
FROM store;
SELECT*
FROM USER;
INSERT INTO user
SET
id=1,
email='test@test.com',
nickname='사장님',
password
='test',
user_id='test';
INSERT INTO user
SET
id=1,
email='test@test.com',
nickname='사장님',
password
='test',
user_id='test';
INSERT INTO store
SET
category='일식',
create_date=NOW(),
author_id=1,
menu='돈까스',
content='대전돈까스집입니다',
name
='설해돈',
road_address='대전둔산로';
INSERT INTO store
SET
category='한식',
create_date=NOW(),
author_id=1,
menu='김밥',
content='김밥집입니다',
name
='김밥천국',
road_address='대전둔산로';