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 */
/*==============================================================*/
create table jf_0001
(
BASE_CODE char(32) not null,
AREA_CODE char(32),
BASE_LGTUDE float,
BASE_LTTUDE float,
BASE_SAFECODE char(32),