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 -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server 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 its
affiliates. Other names may be trademarks of their respective
owners.
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 custom
Database changed
mysql> 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
亿速云「云数据库 MySQL」免部署即开即用,比自行安装部署数据库高出1倍以上的性能,双节点冗余防止单节点故障,数据自动定期备份随时恢复。点击查看>>
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。