infobright

load data local infile '/tmp/a.txt' into table UserInfo  CHARACTER SET utf8 fields terminated by '\t';

 

#!/bin/bash
dbuser='root'
dbpasswd='@321'
mysql-ib -u$dbuser -p$dbpasswd << EOF >> /dev/null
use gwdb;
drop table if exists jf_0001;

/*==============================================================*/
/* Table: jf_0001