一、wamp安装
1、映射hosts
2、配置虚拟主机
#
<VirtualHost *:8081>
ServerName localhost
DocumentRoot c:/wamp64/www/niubi
<Directory "c:/wamp64/www/niubi">
Options +Indexes +Includes +FollowSymLinks +MultiViews
AllowOverride All
#-{~~self add to~~}-
# Require local
#-{~~self add to~~}-
Require all granted
</Directory>
</VirtualHost>
#
<VirtualHost *:8081>
ServerName localhost
DocumentRoot c:/wamp64/www/niubi
<Directory "c:/wamp64/www/niubi">
Options +Indexes +Includes +FollowSymLinks +MultiViews
AllowOverride All
#-{~~self add to~~}-
# Require local
#-{~~self add to~~}-
Require all granted
</Directory>
</VirtualHost>
#
3、
二、MySQL基本知识
1、MySQL入门
# =>修改MySQL密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'wxp'
# =>查看当前数据库
SHOW DATABASES;
# =>创建数据库
create database liansan;
# =>删除数据库
drop database liansan
# =>进入数据库
use liansan;
# =>创建表
CREATE TABLE dptjb (
ID int PRIMARY KEY AUTO_INCREMENT,
wwh VARCHAR(20) NOT NULL,
dpname VARCHAR(20) NOT NULL,
grade VARCHAR(10) NOT NULL,
dphref VARCHAR(200) NOT NULL,
linkman VARCHAR(20) NOT NULL,
phone VARCHAR(11) NOT NULL,
QQ VARCHAR(20) NOT NULL,
Record VARCHAR(4) NOT NULL,
Nickname VARCHAR(12) NOT NULL,
postscript VARCHAR(300) NULL
);
# =>查看数据表引擎
SHOW CREATE TABLE dptjb;
# =>插入一条数据
insert into dptjb (wwh,dpname,grade,dphref,linkman,phone,QQ,Record,Nickname,postscript) VALUES('shuimo87','历夏韩范女装','五心','https://aver91.taobao.com/','郑丹','15882231418','1444825386','是否0','菲琳','B');
insert into dptjb (wwh,dpname,grade,dphref,linkman,phone,QQ,Record,Nickname,postscript) VALUES('抬头瞧月','MIRUI 高端定制','三钻','https://shop149596562.taobao.com/','孟庆松','18752292058','598537144','是否8','庆松','C');
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'wxp'
# =>查看当前数据库
SHOW DATABASES;
# =>创建数据库
create database liansan;
# =>删除数据库
drop database liansan
# =>进入数据库
use liansan;
# =>创建表
CREATE TABLE dptjb (
ID int PRIMARY KEY AUTO_INCREMENT,
wwh VARCHAR(20) NOT NULL,
dpname VARCHAR(20) NOT NULL,
grade VARCHAR(10) NOT NULL,
dphref VARCHAR(200) NOT NULL,
linkman VARCHAR(20) NOT NULL,
phone VARCHAR(11) NOT NULL,
QQ VARCHAR(20) NOT NULL,
Record VARCHAR(4) NOT NULL,
Nickname VARCHAR(12) NOT NULL,
postscript VARCHAR(300) NULL
);
# =>查看数据表引擎
SHOW CREATE TABLE dptjb;
# =>插入一条数据
insert into dptjb (wwh,dpname,grade,dphref,linkman,phone,QQ,Record,Nickname,postscript) VALUES('shuimo87','历夏韩范女装','五心','https://aver91.taobao.com/','郑丹','15882231418','1444825386','是否0','菲琳','B');
insert into dptjb (wwh,dpname,grade,dphref,linkman,phone,QQ,Record,Nickname,postscript) VALUES('抬头瞧月','MIRUI 高端定制','三钻','https://shop149596562.taobao.com/','孟庆松','18752292058','598537144','是否8','庆松','C');
# =>查询数据表的记录
SELECT * FROM dptjb; #查询全部记录
SELECT linkman FROM dptjb where QQ = '1444825386'; #按照条件查询具体某个字段信息
SELECT linkman,phone FROM dptjb where grade = '三钻'; #
SELECT dphref FROM dptjb where ID = 1;
# =>修改记录(条件)
UPDATE dptjb SET postscript = 'A+';
UPDATE dptjb SET postscript = 'A+' WHERE linkman = '孟庆松';
UPDATE dptjb SET phone = '1383838438',postscript = 'D' WHERE linkman = '孟庆松';
# =>删除记录(*条件)
DELETE FROM dptjb WHERE linkman = '孟庆松';
# =>查看数据库编码
show variables like 'character_set_%';
# =>乱码解决方法
[client]
default-character-set=utf8
[mysqld]
default-storage-engine=INNODB
character-set-server=utf8
collation-server=utf8_general_ci
# =>备份数据库
mysqldump -u root -p niubi > d:/test.bak
# =>还原数据库
source d:/test.bak