您好,登錄后才能下訂單哦!
1、創(chuàng)建custom數(shù)據(jù)庫
create database custom;
2、創(chuàng)建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、下載造數(shù)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
備注:(這個(gè)sql是這兩天上班空余時(shí)間,整理出來了)這里執(zhí)行注意一定要是全路徑
4、整理數(shù)據(jù)空格,因?yàn)槭怯肬E慢慢調(diào)整出來了,所以最后一列數(shù)據(jù)空格較大。
如有更好的方法,還請(qǐng)不吝賜教
mysql> update cuser set email = trim(email); #去掉數(shù)據(jù)庫里面列字段內(nèi)容的空格 Query OK, 131493 rows affected (4.06 sec) Rows matched: 131653 Changed: 131493 Warnings: 0
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。