Develop/MySQL 썸네일형 리스트형 Max length of mysql TEXT field type TINYBLOB, TINYTEXT L + 1 bytes, where L < 2^8 (255 Bytes)BLOB, TEXT L + 2 bytes, where L < 2^16 (64 Kibibytes)MEDIUMBLOB, MEDIUMTEXT L + 3 bytes, where L < 2^24 (16 Mebibytes)LONGBLOB, LONGTEXT L + 4 bytes, where L < 2^32 (4 Gibibytes) 더보기 DB dump with single transaction mysqldump [DB Info] [dump option] [dump target] > /path/to/dump/file.sql If you want to dump with single transaction..just add one option in [dump option] That is "--single-transaction" options.It make the dump process to slow, but it did not lock the table.So you can insert, update...etc..during the db dump process. 더보기 테이블 정보 보기. SELECT TABLE_NAME,COLUMN_NAME,ORDINAL_POSITION,COLUMN_DEFAULT ,DATA_TYPE,COLUMN_TYPE,COLUMN_KEY,EXTRA,COLUMN_COMMENT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='[DB_SCHEMA]' 더보기 이전 1 2 3 4 ··· 6 다음