1、创建custom数据库

create database custom;

2、创建cuser表

create table cuser (

idint unsigned auto_increment primary key ,

accountvarchar(50) not null ,

password varchar(20) not null ,

username varchar(20) not null ,

card_idvarchar(20) not null ,

user_idvarchar(30) not null ,

telphone bigint(20)not null ,

emailvarchar(50)

);

3、下载造数sql：http://down.51cto.com/data/2334530

C:\Users\yuri_bai>mysql-uroot-pEnterpassword:******WelcometotheMySQLmonitor.Commandsendwith;or\g.YourMySQLconnectionidis8Serverversion:5.7.19-logMySQLCommunityServer(GPL)Copyright(c)2000,2017,Oracleand/oritsaffiliates.Allrightsreserved.OracleisaregisteredtrademarkofOracleCorporationand/oritsaffiliates.Othernamesmaybetrademarksoftheirrespectiveowners.Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.mysql>showdatabases;+--------------------+|Database|+--------------------+|information_schema||custom||mysql||performance_schema||sys|+--------------------+5rowsinset(0.00sec)mysql>usecustomDatabasechangedmysql>showtables;+------------------+|Tables_in_custom|+------------------+|cuser|+------------------+1rowinset(0.00sec)mysql>sourceC:\Users\yuri_bai\Desktop\12306.sql

备注：（这个sql是这两天上班空余时间，整理出来了）这里执行注意一定要是全路径

4、整理数据空格，因为是用UE慢慢调整出来了，所以最后一列数据空格较大。

如有更好的方法，还请不吝赐教

mysql>updatecusersetemail=trim(email);#去掉数据库里面列字段内容的空格QueryOK,131493rowsaffected(4.06sec)Rowsmatched:131653Changed:131493Warnings:0