SQL

SQL_쿼리문으로 테이블생성, 삭제(CREATE, DROP)

S_pot 2021. 5. 26. 17:21
 SELECT * FROM memberTBL; 

 SELECT memberName, memberAddress FROM memberTBL;

 SELECT * FROM memberTBL WHERE memberName = '지운이'; 

 CREATE TABLE "my testTBL" (id INT); -- 쿼리문장으로 테이블 생성

 DROP TABLE [my testTBL]; -- 테이블삭제