MySql

mysql server에 외부접근을 허용하고자 할 때

10.4.4. The ENUM Type

10 great articles for optimizing MySQL queries
MySQL Replication

 SELECT LAST_INSERT_ID()

프로세스 강제 종료 시키기

10.2. Numeric Types

http://dev.mysql.com/downloads/gui-tools/5.0.html

날짜형식

DATE_FORMAT(now(),'%Y%m%d%H%i%s')

형식변환

http://blog.paran.com/sputnik/1022191

MySQL 쿼리 실시간 모니터링 및 저장하기

http://bret.appspot.com/entry/how-friendfeed-uses-mysql

프랜드피드는 어떻게 MySQL을 사용해서 스키마 없는 데이터를 저장하나" 요약

Mysql5.1 설치 및 한글설정

Update

http://dev.mysql.com/doc/refman/5.0/en/update.html

http://www.electrictoolbox.com/article/mysql/cross-table-update/

GUI tool

http://dev.mysql.com/downloads/gui-tools/5.0.html

날짜

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' )

http://jeongsam.net/112

Index

show index from  tb_fund_chart_weekly

alter table 테이블명 add index 인덱스명 (칼럼명);

CREATE INDEX <인덱스명> ON <테이블명> ( 칼럼명1, 칼럼명2, ... );

Cache

http://dev.mysql.com/doc/refman/5.1/en/ha-memcached-interfaces-mysqludf.html

http://planet.mysql.com/entry/?id=26207

mysql jdbc

socketTimeout=60000&connectTimeout=60000