Mysql 기본 적인 쿼리들

웹프로그래밍/PHP

발전하는개발자 2019. 4. 23. 14:01

CREATE

CREATE TABLE table_name(
col1 varchar(20),
col2 int,
primary key(col1)
)

SELECT

select col1, col2 from table_name where 1=1 order by col1;

INSERT

INSERT INTO table(col1, col2, current_time,...) values('val1', 'val2', 'now()' ... );

now() = 현재날짜 yyyy-mm-dd hh:mm:ss format으로 저장

Delete

Delete from table_name where 1=1;