SELECT * FROM ¥Æ¡¼¥Ö¥ë̾ order by ¥Õ¥£¡¼¥ë¥É̾ desc limit 100 INTO OUTFILE './¥Õ¥¡¥¤¥ë̾.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"';
CREATE TABLE `MEMBER` ( `prefecture` TEXT NOT NULL , `city` TEXT NOT NULL ) ENGINE = MYISAM ;
INSERT INTO `MEMBER` VALUES ('Ë̳¤Æ»','»¥ËÚ»Ô');
mysql> set max_allowed_packet=3355340800; Query OK, 0 rows affected (0.00 sec) mysql> show variables like 'max_allowed_packet'; +--------------------+------------+ | Variable_name | Value | +--------------------+------------+ | max_allowed_packet | 1073741824 | +--------------------+------------+ 1 row in set (0.00 sec)