符合中小企业对网站设计、功能常规化式的企业展示型网站建设
本套餐主要针对企业品牌型网站、中高端设计、前端互动体验...
商城网站建设因基本功能的需求不同费用上面也有很大的差别...
手机微信网站开发、微信官网、微信商城网站...
1、创建custom数据库
创新互联主要从事网站建设、成都网站制作、网页设计、企业做网站、公司建网站等业务。立足成都服务秀洲,十多年网站建设经验,价格优惠、服务专业,欢迎来电咨询建站服务:18980820575
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