mysql基础部分：
1.配置环境：
找到wamp\bin\mysql\bin，即含有mysql.exe的文件夹，复制路径到PATH
2.命令提示符执行mysql -h localhost -uroot -p
-h后面是主机名 -p后面应该是密码 如果不以root登陆看不到有些信息
3.查看数据库的用户表：
select * from mysql.user;但是这么写看不出来什么 应该执行 select * from mysql.user\G
4.创建各种==
mysql> create database xsphp;
Query OK, 1 row affected (0.00 sec)
mysql> show databases
-> ;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
| xsphp |
+--------------------+
5 rows in set (0.05 sec)
mysql> use xsphp;
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql> create table users(
-> id int not null auto_increment primary key.
-> usename char(30) not null default '',
-> password varchar(32) not null default '',
-> age int not null default 0,
-> sex char(4) not null default '',
-> email varchar(80) not null default '');
ERROR 1064 (42000): Erreur de syntaxe près de '.
usename char(30) not null default '',
password varchar(32) not null default ''' à la ligne 2
mysql> create table users(
-> id int not null auto_increment primary key,
-> username char(30) not null default '',
-> password varchar(32) not null default '',
-> age int not null default 0,
-> sex char(4) not null default '',
-> email varchar(80) not null default '');
Query OK, 0 rows affected (0.35 sec)5.查看各种
mysql> show tables;
+-----------------+
| Tables_in_xsphp |
+-----------------+
| users |
+-----------------+
1 row in set (0.00 sec)
mysql> desc users;
+----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| username | char(30) | NO | | | |
| password | varchar(32) | NO | | | |
| age | int(11) | NO | | 0 | |
| sex | char(4) | NO | | | |
| email | varchar(80) | NO | | | |
+----------+-------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
mysql> show create table users;
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| users | CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` char(30) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`age` int(11) NOT NULL DEFAULT '0',
`sex` char(4) NOT NULL DEFAULT '',
`email` varchar(80) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
6.修改与更新
mysql> insert into users(username,password,age,sex,email)
-> values('MissZhou','zyj19950307',20,'female','zhouyujiaambition@163.com');
Query OK, 1 row affected, 1 warning (0.05 sec)
mysql> insert into users(username,password,age,sex,email)
-> values('admin','admin',20,'female','zhouyujiaambition@163.com');
Query OK, 1 row affected, 1 warning (0.04 sec)
mysql> update users set username='zyj' where id=2;
Query OK, 1 row affected (0.08 sec)
Enregistrements correspondants: 1 Modifi茅s: 1 Warnings: 0
mysql> select * from users;
+----+----------+-------------+-----+------+---------------------------+
| id | username | password | age | sex | email |
+----+----------+-------------+-----+------+---------------------------+
| 1 | MissZhou | zyj19950307 | 20 | fema | zhouyujiaambition@163.com |
| 2 | zyj | admin | 20 | fema | zhouyujiaambition@163.com |
+----+----------+-------------+-----+------+---------------------------+
2 rows in set (0.00 sec)7.删除
mysql> select * from users;
+----+----------+-------------+-----+------+---------------------------+
| id | username | password | age | sex | email |
+----+----------+-------------+-----+------+---------------------------+
| 1 | MissZhou | zyj19950307 | 20 | fema | zhouyujiaambition@163.com |
| 2 | zyj | admin | 20 | fema | zhouyujiaambition@163.com |
+----+----------+-------------+-----+------+---------------------------+
2 rows in set (0.00 sec)
mysql> delete from users where id=2;//没有* !!
Query OK, 1 row affected (0.05 sec)
mysql> select * from users;
+----+----------+-------------+-----+------+---------------------------+
| id | username | password | age | sex | email |
+----+----------+-------------+-----+------+---------------------------+
| 1 | MissZhou | zyj19950307 | 20 | fema | zhouyujiaambition@163.com |
+----+----------+-------------+-----+------+---------------------------+
1 row in set (0.00 sec)mysql> drop users;
ERROR 1064 (42000): Erreur de syntaxe près de 'users' à la ligne 1
mysql> drop table users;
Query OK, 0 rows affected (0.22 sec)
mysql> show table;
ERROR 1064 (42000): Erreur de syntaxe près de '' à la ligne 1
mysql> show tables;
Empty set (0.00 sec)
mysql> drop database xsphp;
Query OK, 0 rows affected (0.08 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+这些玩意讲了一年==课件15分钟搞定的==
phpmyadmin的使用
刚刚出现了一个特别惊悚的事情，我在phpmyadmin首页依据视频上的讲解删掉了原有的用户，只保留了主机是localhost的用户，并且修改了密码，再次刷新并没有让我输入密码，又修改了一遍，这下坏了，网页显示phpmyadmin不允许访问mysql说我密码错了QAQ，上网查了，原来还要修改配置文件，C:\wamp\apps\phpmyadmin4.1.14下的config.inc.php密码改成你想要的就好啦
界面简直赞啊，居然给程序员用的还有这么脑残的==啥啥都不用会，相加啥加啥==
PHP访问MySQL
查看mysql的服务是否开启==
合着linux的指令和linux都差不多啊==用之前的指令也是向上箭头（我是不是知道的太多了==
或者在服务进程中找是否有 都可以==
php也是像c#一样，支持好多类型的数据库，语法稍有差异，但都是基于sql写的，反正语言都是触类旁通的，但是多久能通是个人问题==那有没有一套能支持所有数据库的----数据库抽象层！PDO！！！
mysql是面向过程的一套函数mysqli和pdo是面向对象的。
操作mysql
Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp\www\database\test1.php on line 3
神啊==我就不该学mysql吗==不学了，反正以后用不着，官方都说淘汰了
京公网安备 11010502036488号