infobright数据库创建表

 

CREATE TABLE `tttt` (
  `id` bigint(20) NOT NULL ,
  `name` varchar(20) NOT NULL,
  `age` int(3) NOT NULL
) ENGINE=BRIGHTHOUSE DEFAULT CHARSET=utf8;
load data infile '/tmp/info.txt' ignore into table tttt character set gbk fields terminated by ',' enclosed by '"' lines terminated by '\n';

 

load data infile '/tmp/info.txt'的数据放在tmp文件夹下，放在其他文件夹下不知怎地没有权限读取