너는 진정 전자인을 아는가?

select * from table where num in (21076,18245,15874,10047,9733,8020,3982);

데이터베이스 언어변경

ALTER DATABASE `DB명` CHARACTER SET utf8 COLLATE 'utf8_general_ci';

ALTER DATABASE `DB명` CHARACTER SET euckr COLLATE 'euckr_korean_ci';

$sort = "  CASE WHEN StartDate > date_format( now() , '%Y-%m-%d %h:%i:%S' ) 

THEN 2 

WHEN StartDate < date_format( now() , '%Y-%m-%d %h:%i:%S' ) 

AND EndDate >= date_format( now() , '%Y-%m-%d %h:%i:%S' )

THEN 1 

WHEN EndDate < date_format( now() , '%Y-%m-%d %h:%i:%S' ) 

THEN 3 

 end asc ,StartDate desc,Date desc ";

이것을 

select * from table order by $sort

자동증가

ALTER TABLE `table`

CHANGE COLUMN `idx` `idx` INT(11) NOT NULL AUTO_INCREMENT FIRST;

기본키 설정

ALTER TABLE `table`

	ADD PRIMARY KEY (`idx`);