欄位不同的資料庫匯入

mid int(10) UNSIGNED 否 None auto_increment
name varchar(20) utf8_general_ci 否 None
twid varchar(10) utf8_general_ci 否 None
tel varchar(20) utf8_general_ci 否 None
mobile varchar(20) utf8_general_ci 否 None
gender varchar(10) utf8_general_ci 否 None
address varchar(100) utf8_general_ci 否 None
zip varchar(10) utf8_general_ci 否 None
lat double 否 None
lon double 否 None
email varchar(100) utf8_general_ci 否 None
corpname varchar(50) utf8_general_ci 否 None
twcorpid varchar(20) utf8_general_ci 否 None
ctime timestamp 否 CURRENT_TIMESTAMP
birthday date 否 None





member_id int(11) 否 auto_increment
department char(2) utf8_general_ci 否
date date 否
vender varchar(15) utf8_general_ci 否
model varchar(20) utf8_general_ci 否
imei varchar(15) utf8_general_ci 否
sn varchar(15) utf8_general_ci 否
name varchar(20) utf8_general_ci 否
birthday date 否
mobile_phone char(20) utf8_general_ci 否
email varchar(30) utf8_general_ci 否
staff varchar(10) utf8_general_ci 否
rank char(3) utf8_general_ci 否
note text utf8_general_ci 否

mid == member_id
name == name
twid == 000000000
tel == 0000000000
mobile == mobile_phone
gender ==""
address == ""
zip == 000
lat == 0.0
lon == 0.0
email == email
corpname == ""
twcorpid == ""
ctime == date
birthday == birthday

SELECT member_id, name, '000000000', '0000000000', mobile_phone, '', '', '000', 0.0, 0.0, email, '', '', `date`, birthday FROM

SELECT '', name, '000000000', '0000000000', mobile_phone, '', '', '000', 0.0, 0.0, email, '', '', `date`, birthday FROM




storename varchar(20) utf8_general_ci 否
employeename char(10) utf8_general_ci 否
sid int(11) 否 auto_increment
name varchar(30) utf8_general_ci 否
birthday date 否
gender char(5) utf8_general_ci 否
cellnum char(10) utf8_general_ci 否
hometel char(13) utf8_general_ci 是 NULL
mail varchar(50) utf8_general_ci 是 NULL
datetime datetime 否
storeid char(5) utf8_general_ci 否
storecode char(5) utf8_general_ci 否
employeeid char(5) utf8_general_ci 否
chgtime datetime 是 NULL
chgid char(5) utf8_general_ci 是 NULL
chgname char(10) utf8_general_ci 是 NULL
id char(10) utf8_general_ci 否
address varchar(100) utf8_general_ci 是 NULL
com varchar(100) utf8_general_ci 是 NULL
comid char(8) utf8_general_ci 是 NULL
occupation varchar(50) utf8_general_ci 是 NULL
comtel char(13) utf8_general_ci 是 NULL
comtelext char(10) utf8_general_ci 是 NULL
fax char(13) utf8_general_ci 是 NULL
level char(3) utf8_general_ci 是 NULL



mid == sid
name == name
twid == 000000000
tel == hometel
mobile == cellnum
gender == gender
address == address
zip == 000
lat == 0.0
lon == 0.0
email == mail
corpname == com
twcorpid == ""
ctime == datetime
birthday == birthday


SELECT sid, name, '000000000', hometel, cellnum, gender, address, '000', 0.0, 0.0, mail, com, '', `datetime`, birthday FROM