Mysql 造数测试

1、创建custom数据库

create database custom;

2、创建cuser表

create table cuser (

id int unsigned auto_increment primary key ,

account varchar(50) not null ,

password varchar(20) not null ,

username varchar(20) not null ,

card_id varchar(20) not null ,

user_id varchar(30) not null ,

telphone bigint(20) not null ,

email varchar(50)

);

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

C:\Users\yuri_bai>mysql -u root -pEnter password: ******Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 8Server version: 5.7.19-log MySQL Community Server (GPL)Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || custom             || mysql              || performance_schema || sys                |+--------------------+5 rows in set (0.00 sec)mysql> use customDatabase changedmysql> show tables;+------------------+| Tables_in_custom |+------------------+| cuser            |+------------------+1 row in set (0.00 sec)mysql> source C:\Users\yuri_bai\Desktop\12306.sql

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

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

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

mysql> update cuser set email = trim(email);  #去掉数据库里面列字段内容的空格Query OK, 131493 rows affected (4.06 sec)Rows matched: 131653  Changed: 131493  Warnings: 0