수업용 블로그

use sqlDB; select * from userTbl; select userId, Name from userTbl where birthYear >= 1970 And height >=182; select userID, name from userTbl where birthYear >= 1970 or height >=182; select Name, height from userTbl where height >=180 and height 177; select name, height from usertbl WHERE height>(select height from userTbl where Name='김경호'); -- subquery select name, height from usertbl where hei..

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,..

USE studyDB; create table test(id INT); insert into test values(1); insert into test values(110); insert into test values(500); select * from test; create table test1(id int primary key not null, name char(10)); insert into test1 (40, 'test'); select * from test1;