mysql local变量_MySQL变量：local_infile

mysql> show create table test.t\G

*************************** 1. row ***************************

Table: t

Create Table: CREATE TABLE `t` (

`id` int(11) DEFAULT NULL,

`name` varchar(100) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1

1 row in set (0.00 sec)

mysql> show variables like 'local_infile';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| local_infile | OFF |

+---------------+-------+

1 row in set (0.00 sec)

mysql> load data local infile 'D:\\ATMP\\mysql_repl\\5.6_local\\data.txt' into table test.t fields terminated by ',' OPTIONALLY ENCLOSED BY '\'' lines terminated by '\r\n';

ERROR 1148 (42000): The used command is not allowed with this MySQL version

mysql> set global local_infile=ON;

Query OK, 0 rows affected (0.00 sec)

mysql> load data local infile 'D:\\ATMP\\mysql_repl\\5.6_local\\data.txt' into table test.t fields terminated by ',' OPTIONALLY ENCLOSED BY '\'' lines terminated by '\r\n';

Query OK, 3 rows affected (0.06 sec)

Records: 3 Deleted: 0 Skipped: 0 Warnings: 0

分享到：

2014-02-28 11:31

浏览 2952

评论