SELECT LAST_INSERT_ID()
날짜형식
DATE_FORMAT(now(),'%Y%m%d%H%i%s')
형식변환
DAYOFWEEK(date)
1 = Sunday, 2 = Monday, 7 = Saturday
select DAYOFWEEK('2007-01-05');
select DAYOFWEEK(now());
cast(ymd as date)
DATE_FORMAT(date_add(cast(gijun_ymd as date), interval 2-dayofweek(gijun_ymd) day), '%Y%m%d' )
show index from tb_fund_chart_weekly
alter table 테이블명 add index 인덱스명 (칼럼명);
CREATE INDEX <인덱스명> ON <테이블명> ( 칼럼명1, 칼럼명2, … );
select * from mysql.userselect * from mysql.dbselect version()select * from mysql.general_logshow variables like 'log_output'
http://venublog.com/2007/11/07/load-data-infile-performance/ : 옵션 조정해서 비교하는 사례
http://www.mysqlperformanceblog.com/2008/07/03/how-to-load-large-files-safely-into-innodb-with-load-data-infile/ : perl script이용 chunk 사이즈 조정http://chrisjohnson.blogsite.org/php-and-mysql-data-import-performance/[http://chrisjohnson.blogsite.org/php-and-mysql-data-import-performance/] : Php에서 load data in file의 성능비교 insert 성능 : http://dev.mysql.com/doc/refman/5.1/en/insert-speed.htmlhttp://kvz.io/blog/2009/03/31/improve-mysql-insert-performance/[http://kvz.io/blog/2009/03/31/improve-mysql-insert-performance/] insert delayed : (myisam에서만 가능) http://chapter31.com/2008/05/22/insert-delayed-with-mysql/
jdbc:mysql://127.0.0.1/test?logger=com.mysql.jdbc.log.Slf4JLogger&logSlowQueries=true&slowQueryThresholdMillis=1500&dumpQueriesOnException=true&explainSlowQueries=true&connectTimeout=1000&socketTimeout=2000
Column not found 에러 :
?useOldAliasMetadataBehavior=true