190829 DB insert into 기본

use sqlDB;
insert into userTbl values('KKH','김경호', 1971,'전남','019','33333333',177,'2007-7-7');
insert into userTbl values('JYP','조용필',1950,'경기','011','44444444',166,'2009-4-4');
insert into userTbl values('SSK','성시경',1979,'서울',NULL,NULL,186,'2013-12-12');
insert into userTbl values('LJB','임재범',1963,'서울','016','66666666',182,'2009-9-9');
insert into userTbl values('YJS','윤종신',1969,'경남',NULL,NULL,170,'2005-5-5');
insert into userTbl values('EJW','은지원',1972,'경북','011','88888888',174,'2014-3-3');
insert into userTbl values('JKW', '조관우',1965,'경기','018','99999999',172,'2010-10-10');
insert into userTbl values('BBK','바비킴',1973,'서울','010','00000000',176,'2013-5-5');
insert into userTbl values('LSG','이승기',1987,'서울','011','1111111',182,'2008-8-8');

 

use sqlDB;
insert into buyTbl values 
(null,'KBS','노트북','전자',1000,1),
(null,'JYP','모니터','전자',200,1),
(null,'BBK','모니터','전자',200,5),
(null, 'KBS','청바지','의류',50,3),
(null,'BBK','메모리','전자',80,10),
(null,'SSK','책', '서적',15,5),
(null,'EJW','청바지','의류',50,1),
(null,'BBK','운동화',NULL,30,2),
(null,'EJW','책','서적',15,1),
(null,'BBK','운동화',NULL,30,2);