황선영·2023년 11월 22일
0

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='대전둔산로';

profile
개발필기노트

0개의 댓글