ref; http://www.electrictoolbox.com/maximum-length-mysql-text-field-types/TINYTEXT 256 byteTEXT 64kbMEDIUMTEXT 16MBLONGTEXT 4GB

mysqladmin create [target database name] -h [host] -u [user] -p[passwd]; mysqldump -h [host] -u [user] -p[passwd] [source database name] | mysql -h [host] -u [user] -p[passwd] [target database name]

Python: tuple indices must be integers, not str when selecting from mysql tablehttp://stackoverflow.com/questions/12325234/python-tuple-indices-must-be-integers-not-str-when-selecting-from-mysql-table check cursor type first, being dict cursor, use dict key, or use tuple index How to see the real SQL query in Python cursor.executehttp://stackoverflow.com/questions/5266430/how-to-see-the-real-sql..

http://bookworm.pe.kr/wordpress/2013/01/01/2642/ http://dev.mysql.com/doc/refman/5.0/en/innodb-locking-reads.html LOCK IN SHARE MODESELECT후 트랜잭션이 끝날 때까지 해당 ROW 값이 변경되지 않음을 보장즉, 해당 ROW를 UPDATE/DELETE하는 쿼리는 잠김 상태가 되어 트랜잭션이 끝날 때까지 대기 / SELECT는 여러 세션 동시 수행 가능auto_commit을 꺼야 한다SELECT * FROM user WHERE id = 1 LOCK IN SHARE MODE; FOR UPDATESELECT로 가져 온 데이터를 변경할 때 사용해당 ROW에 대해 다른 세션의 SELECT, UPDATE, DEL..