Mysql 기본 적인 쿼리들

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;