DB 기본 쿼리문

기본

 

SELECT *

FROM [테이블명]

WHERE [조건문]

 

* CREATE

"create table [테이블명]([필드명] [필드 타입] (NOT NULL),

                                 .... ,

                                 PRIMARY KEY([필드명])

                                  )";

* INSERT

"insert into [테이블명] values("값")";

 

* UPDATE

"update [테이블명] set 필드명 = '값'"; 

 

* DELETE

"delete from [테이블명] where [조건문]";