第15章 MySQL数据库

最新推荐文章于 2022-08-25 11:07:58 发布
最新推荐文章于 2022-08-25 11:07:58 发布
阅读量199 收藏
点赞数
分类专栏： 阅-PHP 文章标签： 数据库 php

打开 mySQL 客户端

 

Demo1.txt

Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select version();
+--------------------------+
| version()                |
+--------------------------+
| 5.0.51b-community-nt-log |
+--------------------------+
1 row in set (0.01 sec)

mysql> select version(),current_date();
+--------------------------+----------------+
| version()                | current_date() |
+--------------------------+----------------+
| 5.0.51b-community-nt-log | 2015-04-23     |
+--------------------------+----------------+
1 row in set (0.02 sec)

mysql> select version() as version;
+--------------------------+
| version                  |
+--------------------------+
| 5.0.51b-community-nt-log |
+--------------------------+
1 row in set (0.00 sec)

mysql> select version() as '版本号';
+--------------------------+
| 版本号                       |
+--------------------------+
| 5.0.51b-community-nt-log |
+--------------------------+
1 row in set (0.00 sec)

mysql> select (20+5)*4;
+----------+
| (20+5)*4 |
+----------+
|      100 |
+----------+
1 row in set (0.00 sec)

mysql> select (20+5)*4 as result;
+--------+
| result |
+--------+
|    100 |
+--------+
1 row in set (0.00 sec)

mysql> select version();
+--------------------------+
| version()                |
+--------------------------+
| 5.0.51b-community-nt-log |
+--------------------------+
1 row in set (0.01 sec)

mysql> select
    -> version();
+--------------------------+
| version()                |
+--------------------------+
| 5.0.51b-community-nt-log |
+--------------------------+
1 row in set (0.00 sec)

mysql> select
    ->
    ->
    -> now()
    ->
    -> ;
+---------------------+
| now()               |
+---------------------+
| 2015-04-23 13:34:26 |
+---------------------+
1 row in set (0.02 sec)

mysql> select user(),NOW();
+----------------+---------------------+
| user()         | NOW()               |
+----------------+---------------------+
| root@localhost | 2015-04-23 13:35:53 |
+----------------+---------------------+
1 row in set (0.00 sec)

mysql> SELECT USER();SELECT NOW();
+----------------+
| USER()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

+---------------------+
| NOW()               |
+---------------------+
| 2015-04-23 13:36:20 |
+---------------------+
1 row in set (0.00 sec)

mysql> SELECIT
    -> \c
mysql> exit;

 

Demo2.txt

Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT VERSION();
+--------------------------+
| VERSION()                |
+--------------------------+
| 5.0.51b-community-nt-log |
+--------------------------+
1 row in set (0.00 sec)

mysql> SELECT VERSION() AS '版本号';
+--------------------------+
| 版本号                       |
+--------------------------+
| 5.0.51b-community-nt-log |
+--------------------------+
1 row in set (0.00 sec)

mysql> fsdfssg
    -> \c
mysql>

 

Demo3.txt

'ab  '

//文本型
//这个如果采用 CHAR 类型，客格也是一个字符
//CHAR 定长类型 //访问速度快

//CHAR 用于，性别，密码

//VARCHAR 会把后面的空格给删除，可变长度的类型，自己本身的长度 +1
//占用容量小

//用户名，文章标题

//备注型：string + 1

//比较常用的是 TEXT,用于备注，大文章，贴子，新闻内容

 

Demo4.txt

Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| guest              |
| mysql              |
| phpmyadmin         |
| test               |
| ultrax             |
+--------------------+
6 rows in set (0.05 sec)

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| guest              |
| mysql              |
| phpmyadmin         |
| test               |
| ultrax             |
+--------------------+
6 rows in set (0.00 sec)

mysql> USE guest;
Database changed
mysql> SELECT DATABASE();
+------------+
| DATABASE() |
+------------+
| guest      |
+------------+
1 row in set (0.00 sec)

mysql> SHOW TABLES;
+-----------------+
| Tables_in_guest |
+-----------------+
| g_article       |
| g_flower        |
| g_friend        |
| g_message       |
| g_photo         |
| g_photocomment  |
| g_photolist     |
| g_system        |
| g_users         |
+-----------------+
9 rows in set (0.00 sec)

mysql> SELECT * FROM g_friend;
+------+--------------+-----------------+----------+---------------------+
| G_ID | G_ToUser     | G_FromUser      | G_Degree | G_Date              |
+------+--------------+-----------------+----------+---------------------+
|    1 | 澶у姘撮ズ     | 鐐庢棩            |        0 | 2009-04-21 14:56:03 |

|    2 | 灏忕嚂瀛?      | 鐐庢棩            |        0 | 2009-05-03 10:51:11 |
|    5 | 鐐庢棩         | 妯辨灏忎父瀛?     |        1 | 2009-05-03 10:56:31 |

+------+--------------+-----------------+----------+---------------------+
3 rows in set (0.02 sec)

mysql> SET NAMES GBK;
Query OK, 0 rows affected (0.02 sec)

mysql> SELECT * FROM g_friend;
+------+----------+------------+----------+---------------------+
| G_ID | G_ToUser | G_FromUser | G_Degree | G_Date              |
+------+----------+------------+----------+---------------------+
|    1 | 大娘水饺        | 炎日           |        0 | 2009-04-21 14:56:03 |
|    2 | 小燕子        | 炎日           |        0 | 2009-05-03 10:51:11 |
|    5 | 炎日         | 樱桃小丸子         |        1 | 2009-05-03 10:56:31 |
+------+----------+------------+----------+---------------------+
3 rows in set (0.02 sec)

mysql>

 

Demo5.txt

+-----------------+
1 row in set (0.00 sec)

mysql> select * from users;
ERROR 1146 (42S02): Table 'books.users' doesn't exist
mysql> selct * form uses;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'selc
 * form uses' at line 1
mysql> select * from uses;
Empty set (0.00 sec)

mysql> select * from uses;
Empty set (0.00 sec)

mysql> DESCRIBE USES;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| username | varchar(20) | YES  |     | NULL    |       |
| sex      | char(1)     | YES  |     | NULL    |       |
| birth    | datetime    | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
3 rows in set (0.02 sec)

mysql> INSERT INFO uses (username,sex birth) VALUES('oneStopWeb','0',NOW());
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'uses
(username,sex birth) VALUES('oneStopWeb','0',NOW())' at line 1
mysql> INSERT INFO uses (username,sex,birth) VALUES('oneStopWeb','0',NOW());
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'uses
(username,sex,birth) VALUES('oneStopWeb','0',NOW())' at line 1
mysql> INSERT INTO uses (username,sex,birth) VALUES('oneStopWeb','0',NOW());
Query OK, 1 row affected (0.01 sec)

mysql> SELECT * FROM uses;
+------------+------+---------------------+
| username   | sex  | birth               |
+------------+------+---------------------+
| oneStopWeb | 0    | 2015-04-23 14:46:16 |
+------------+------+---------------------+
1 row in set (0.00 sec)

mysql> INSERT INTO uses (username,sex,birth) VALUES('chaoyv','1',NOW());
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM uses;
+------------+------+---------------------+
| username   | sex  | birth               |
+------------+------+---------------------+
| oneStopWeb | 0    | 2015-04-23 14:46:16 |
| chaoyv     | 1    | 2015-04-23 14:47:45 |
+------------+------+---------------------+
2 rows in set (0.00 sec)

mysql> INSERT INTO uses (username,sex,birth) VALUES('一站式建网站','0',NOW());
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> SET NAMES GBK;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT * FROM uses;
+------------+------+---------------------+
| username   | sex  | birth               |
+------------+------+---------------------+
| oneStopWeb | 0    | 2015-04-23 14:46:16 |
| chaoyv     | 1    | 2015-04-23 14:47:45 |
| ???        | 0    | 2015-04-23 14:48:24 |
+------------+------+---------------------+
3 rows in set (0.00 sec)

mysql> INSERT INTO uses (username,sex,birth) VALUES('一站式建网站','0',NOW());
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM USES;
+--------------+------+---------------------+
| username     | sex  | birth               |
+--------------+------+---------------------+
| oneStopWeb   | 0    | 2015-04-23 14:46:16 |
| chaoyv       | 1    | 2015-04-23 14:47:45 |
| ???          | 0    | 2015-04-23 14:48:24 |
| 一站式建网站         | 0    | 2015-04-23 14:49:27 |
+--------------+------+---------------------+
4 rows in set (0.00 sec)

mysql> INSERT INTO uses (username,sex,birth) VALUES('冼生','0',NOW());
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM USES;
+--------------+------+---------------------+
| username     | sex  | birth               |
+--------------+------+---------------------+
| oneStopWeb   | 0    | 2015-04-23 14:46:16 |
| chaoyv       | 1    | 2015-04-23 14:47:45 |
| ???          | 0    | 2015-04-23 14:48:24 |
| 一站式建网站         | 0    | 2015-04-23 14:49:27 |
| 冼生             | 0    | 2015-04-23 14:50:14 |
+--------------+------+---------------------+
5 rows in set (0.02 sec)

mysql> SELECT username FROM USES;
+--------------+
| username     |
+--------------+
| oneStopWeb   |
| chaoyv       |
| ???          |
| 一站式建网站         |
| 冼生             |
+--------------+
5 rows in set (0.00 sec)

mysql> SELECT username,sex FROM USES;
+--------------+------+
| username     | sex  |
+--------------+------+
| oneStopWeb   | 0    |
| chaoyv       | 1    |
| ???          | 0    |
| 一站式建网站         | 0    |
| 冼生             | 0    |
+--------------+------+
5 rows in set (0.01 sec)

mysql> SELECT * FROM USES;
+--------------+------+---------------------+
| username     | sex  | birth               |
+--------------+------+---------------------+
| oneStopWeb   | 0    | 2015-04-23 14:46:16 |
| chaoyv       | 1    | 2015-04-23 14:47:45 |
| ???          | 0    | 2015-04-23 14:48:24 |
| 一站式建网站         | 0    | 2015-04-23 14:49:27 |
| 冼生             | 0    | 2015-04-23 14:50:14 |
+--------------+------+---------------------+
5 rows in set (0.00 sec)

mysql> SELECT * FROM uses WHERE sex = '1';
+----------+------+---------------------+
| username | sex  | birth               |
+----------+------+---------------------+
| chaoyv   | 1    | 2015-04-23 14:47:45 |
+----------+------+---------------------+
1 row in set (0.02 sec)

mysql> DELETE FROM uses WHERE SEX = '1';
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM USES;
+--------------+------+---------------------+
| username     | sex  | birth               |
+--------------+------+---------------------+
| oneStopWeb   | 0    | 2015-04-23 14:46:16 |
| ???          | 0    | 2015-04-23 14:48:24 |
| 一站式建网站         | 0    | 2015-04-23 14:49:27 |
| 冼生             | 0    | 2015-04-23 14:50:14 |
+--------------+------+---------------------+
4 rows in set (0.00 sec)

mysql> DELETE FROM uses WHERE username = '???';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT * FROM USES;
+--------------+------+---------------------+
| username     | sex  | birth               |
+--------------+------+---------------------+
| oneStopWeb   | 0    | 2015-04-23 14:46:16 |
| ???          | 0    | 2015-04-23 14:48:24 |
| 一站式建网站         | 0    | 2015-04-23 14:49:27 |
| 冼生             | 0    | 2015-04-23 14:50:14 |
+--------------+------+---------------------+
4 rows in set (0.02 sec)

mysql> DELETE FROM uses WHERE username = '%?%';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT * FROM USES;
+--------------+------+---------------------+
| username     | sex  | birth               |
+--------------+------+---------------------+
| oneStopWeb   | 0    | 2015-04-23 14:46:16 |
| ???          | 0    | 2015-04-23 14:48:24 |
| 一站式建网站         | 0    | 2015-04-23 14:49:27 |
| 冼生             | 0    | 2015-04-23 14:50:14 |
+--------------+------+---------------------+
4 rows in set (0.00 sec)

mysql> DELETE FROM uses WHERE username like '???';
Query OK, 0 rows affected (0.02 sec)

mysql> SELECT * FROM USES;
+--------------+------+---------------------+
| username     | sex  | birth               |
+--------------+------+---------------------+
| oneStopWeb   | 0    | 2015-04-23 14:46:16 |
| ???          | 0    | 2015-04-23 14:48:24 |
| 一站式建网站         | 0    | 2015-04-23 14:49:27 |
| 冼生             | 0    | 2015-04-23 14:50:14 |
+--------------+------+---------------------+
4 rows in set (0.00 sec)

mysql> DELETE FROM uses WHERE username like '%?%';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT * FROM USES;
+--------------+------+---------------------+
| username     | sex  | birth               |
+--------------+------+---------------------+
| oneStopWeb   | 0    | 2015-04-23 14:46:16 |
| ???          | 0    | 2015-04-23 14:48:24 |
| 一站式建网站         | 0    | 2015-04-23 14:49:27 |
| 冼生             | 0    | 2015-04-23 14:50:14 |
+--------------+------+---------------------+
4 rows in set (0.00 sec)

mysql> SELECT * FROM USES ORDER BY birth DESC;
+--------------+------+---------------------+
| username     | sex  | birth               |
+--------------+------+---------------------+
| 冼生             | 0    | 2015-04-23 14:50:14 |
| 一站式建网站         | 0    | 2015-04-23 14:49:27 |
| ???          | 0    | 2015-04-23 14:48:24 |
| oneStopWeb   | 0    | 2015-04-23 14:46:16 |
+--------------+------+---------------------+
4 rows in set (0.00 sec)

mysql> SHOW TABLES;
+-----------------+
| Tables_in_books |
+-----------------+
| uses            |
+-----------------+
1 row in set (0.00 sec)

mysql> DROP TABLE USES;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW TABLES;
Empty set (0.00 sec)

mysql> SELECT * FROM USES;
ERROR 1146 (42S02): Table 'books.uses' doesn't exist
mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| books              |
| guest              |
| mysql              |
| phpmyadmin         |
| test               |
| ultrax             |
+--------------------+
7 rows in set (0.00 sec)

mysql> DROP DATABASE BOOKS;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| guest              |
| mysql              |
| phpmyadmin         |
| test               |
| ultrax             |
+--------------------+
6 rows in set (0.00 sec)

mysql> use guest;
Database changed
mysql> select * from g_friend;
+------+----------+------------+----------+---------------------+
| G_ID | G_ToUser | G_FromUser | G_Degree | G_Date              |
+------+----------+------------+----------+---------------------+
|    1 | 大娘水饺        | 炎日           |        0 | 2009-04-21 14:56:03 |
|    2 | 小燕子        | 炎日           |        0 | 2009-05-03 10:51:11 |
|    5 | 炎日         | 樱桃小丸子         |        1 | 2009-05-03 10:56:31 |
+------+----------+------------+----------+---------------------+
3 rows in set (0.00 sec)

mysql> UPDATE g_friend set g_touser='oneStopWeb' where g_id =1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from g_friend;
+------+------------+------------+----------+---------------------+
| G_ID | G_ToUser   | G_FromUser | G_Degree | G_Date              |
+------+------------+------------+----------+---------------------+
|    1 | oneStopWeb | 炎日           |        0 | 2009-04-21 14:56:03 |
|    2 | 小燕子          | 炎日           |        0 | 2009-05-03 10:51:11 |
|    5 | 炎日           | 樱桃小丸子         |        1 | 2009-05-03 10:56:31 |

+------+------------+------------+----------+---------------------+
3 rows in set (0.00 sec)

mysql>

 

Demo6.txt

Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT CONCAT('Mr.','One');
+---------------------+
| CONCAT('Mr.','One') |
+---------------------+
| Mr.One              |
+---------------------+
1 row in set (0.00 sec)

mysql> SELECT CONCAT('Mr.','One') AS '两个字符串相连';
+----------------+
| 两个字符串相连              |
+----------------+
| Mr.One         |
+----------------+
1 row in set (0.00 sec)

mysql> SELECT LENGTH('OneStopWeb');
+----------------------+
| LENGTH('OneStopWeb') |
+----------------------+
|                   10 |
+----------------------+
1 row in set (0.02 sec)

mysql> SELECT LEFT('2');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ')' at
 line 1
mysql> SELECT LEFT('OneStopWeb',2);
+----------------------+
| LEFT('OneStopWeb',2) |
+----------------------+
| On                   |
+----------------------+
1 row in set (0.02 sec)

mysql> SELECT TRIM('    5454     ');
+-----------------------+
| TRIM('    5454     ') |
+-----------------------+
| 5454                  |
+-----------------------+
1 row in set (0.00 sec)

mysql> SELECT SUBSTRING('This is a OneStopWeb',2,5);
+---------------------------------------+
| SUBSTRING('This is a OneStopWeb',2,5) |
+---------------------------------------+
| his i                                 |
+---------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT MD5('123456');
+----------------------------------+
| MD5('123456')                    |
+----------------------------------+
| e10adc3949ba59abbe56e057f20f883e |
+----------------------------------+
1 row in set (0.00 sec)

mysql> SELECT ABS(-5);
+---------+
| ABS(-5) |
+---------+
|       5 |
+---------+
1 row in set (0.01 sec)

mysql> SELECT ROUND(4.50);
+-------------+
| ROUND(4.50) |
+-------------+
|           5 |
+-------------+
1 row in set (0.00 sec)

mysql> SELECT FLOOR(4.67);
+-------------+
| FLOOR(4.67) |
+-------------+
|           4 |
+-------------+
1 row in set (0.00 sec)

mysql> SELECT CEILING(4.07);
+---------------+
| CEILING(4.07) |
+---------------+
|             5 |
+---------------+
1 row in set (0.00 sec)

mysql> SELECT RAND();
+------------------+
| RAND()           |
+------------------+
| 0.86286346042795 |
+------------------+
1 row in set (0.00 sec)

mysql> SELECT RAND();
+------------------+
| RAND()           |
+------------------+
| 0.58029021376771 |
+------------------+
1 row in set (0.01 sec)

mysql> SELECT RAND()*10;
+-----------------+
| RAND()*10       |
+-----------------+
| 3.1286071828833 |
+-----------------+
1 row in set (0.00 sec)

mysql> SELECT ROUND(RAND()*10);
+------------------+
| ROUND(RAND()*10) |
+------------------+
|                8 |
+------------------+
1 row in set (0.00 sec)

mysql> SELECT NOW();
+---------------------+
| NOW()               |
+---------------------+
| 2015-04-23 16:39:11 |
+---------------------+
1 row in set (0.00 sec)

mysql> SELECT HOUR(NOW());
+-------------+
| HOUR(NOW()) |
+-------------+
|          16 |
+-------------+
1 row in set (0.00 sec)

mysql> SELECT MINUTE(NOW());
+---------------+
| MINUTE(NOW()) |
+---------------+
|            40 |
+---------------+
1 row in set (0.00 sec)

mysql> SELECT DAYNAME(NOW());
+----------------+
| DAYNAME(NOW()) |
+----------------+
| Thursday       |
+----------------+
1 row in set (0.00 sec)

mysql> SELECT DAYOFMONTY(NOW());
ERROR 1046 (3D000): No database selected
mysql> SELECT DAYOFMONTH(NOW());
+-------------------+
| DAYOFMONTH(NOW()) |
+-------------------+
|                23 |
+-------------------+
1 row in set (0.02 sec)

mysql> SELECT MONTHNAME(NOW());
+------------------+
| MONTHNAME(NOW()) |
+------------------+
| April            |
+------------------+
1 row in set (0.01 sec)

mysql> SELECT MONTH(NOW());
+--------------+
| MONTH(NOW()) |
+--------------+
|            4 |
+--------------+
1 row in set (0.00 sec)

mysql> SELECT YEAR(NOW());
+-------------+
| YEAR(NOW()) |
+-------------+
|        2015 |
+-------------+
1 row in set (0.00 sec)

mysql> SELECT CORDATE();
ERROR 1046 (3D000): No database selected
mysql> SELECT CURDATE();
+------------+
| CURDATE()  |
+------------+
| 2015-04-23 |
+------------+
1 row in set (0.02 sec)

mysql> SELECT CURTIME();
+-----------+
| CURTIME() |
+-----------+
| 16:45:35  |
+-----------+
1 row in set (0.00 sec)

mysql> SELECT NOW();
+---------------------+
| NOW()               |
+---------------------+
| 2015-04-23 16:45:48 |
+---------------------+
1 row in set (0.00 sec)

mysql> SELECT DATA_FORMAT(NOT(),'%y');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '),'%y
')' at line 1
mysql> SELECT DATE\_FORMAT(NOT(),'%Y');
ERROR:
Unknown command '\_'.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '\_FOR
MAT(NOT(),'%Y')' at line 1
mysql> SELECT DATE_FORMAT(NOT(),'%Y');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '),'%Y
')' at line 1
mysql> SELECT DATE_FORMAT(NOW(),'%Y');
+-------------------------+
| DATE_FORMAT(NOW(),'%Y') |
+-------------------------+
| 2015                    |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT DATE_FORMAT(NOW(),'%e');
+-------------------------+
| DATE_FORMAT(NOW(),'%e') |
+-------------------------+
| 23                      |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT DATE_FORMAT(NOW(),'%D');
+-------------------------+
| DATE_FORMAT(NOW(),'%D') |
+-------------------------+
| 23rd                    |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT DATE_FORMAT(NOW(),'%W');
+-------------------------+
| DATE_FORMAT(NOW(),'%W') |
+-------------------------+
| Thursday                |
+-------------------------+
1 row in set (0.02 sec)

mysql> SELECT DATE_FORMAT(NOW(),'%m');
+-------------------------+
| DATE_FORMAT(NOW(),'%m') |
+-------------------------+
| 04                      |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT DATE_FORMAT(NOW(),'%c');
+-------------------------+
| DATE_FORMAT(NOW(),'%c') |
+-------------------------+
| 4                       |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT DATE_FORMAT(NOW(),'%T');
+-------------------------+
| DATE_FORMAT(NOW(),'%T') |
+-------------------------+
| 17:03:35                |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT DATE_FORMAT(NOW(),'%r');
+-------------------------+
| DATE_FORMAT(NOW(),'%r') |
+-------------------------+
| 05:03:43 PM             |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT DATE_FORMAT(NOW(),'%p');
+-------------------------+
| DATE_FORMAT(NOW(),'%p') |
+-------------------------+
| PM                      |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT DATE_FORMAT(NOW(),'%H,%i,%S,%p');
+----------------------------------+
| DATE_FORMAT(NOW(),'%H,%i,%S,%p') |
+----------------------------------+
| 17,04,38,PM                      |
+----------------------------------+
1 row in set (0.00 sec)

mysql> SELECT DATE_FORMAT(NOW(),'%H:%i:%S:%p');
+----------------------------------+
| DATE_FORMAT(NOW(),'%H:%i:%S:%p') |
+----------------------------------+
| 17:05:00:PM                      |
+----------------------------------+
1 row in set (0.00 sec)

mysql>

 

Demo7.txt

id:学员的编号，性质：每个人的编号不得重复，而且可以排序，
那么 ID 这个字段，采用的是整型，范围：0-99
	TINYINT(2) 0-255 UNSIGEND 表示无符号 TINYINT(2) 整数
	NOT NUll 表示这个字段不能为空
	AUTO_INCREMENT 表示 1，2，3，4，5 自动新增累计
	主键：表示一个字段唯一性，不得重复，方便搜索与排序

 

Demo8.txt

Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| guest              |
| mysql              |
| phpmyadmin         |
| test               |
| ultrax             |
+--------------------+
6 rows in set (0.02 sec)

mysql> CREATA DATABASE school;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'CREAT
A DATABASE school' at line 1
mysql> CREATE DATABASE school;
Query OK, 1 row affected (0.01 sec)

mysql> SHOW BATABASES;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'BATAB
ASES' at line 1
mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| guest              |
| mysql              |
| phpmyadmin         |
| school             |
| test               |
| ultrax             |
+--------------------+
7 rows in set (0.00 sec)

mysql> SHOW school;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'schoo
l' at line 1
mysql> USE school;
Database changed
mysql> SHOW school;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'schoo
l' at line 1
mysql> show TABLES;
Empty set (0.00 sec)

mysql> CREATA TABLE grade(
    -> id TINYINT(2) UNSIGEND NOT NULL AUTO_INCREMENT,
    -> name VARCHAR(20) NOT NULL,
    -> email VARCHAR(40),
    -> point TINYINT(3) UNSIGNED NOT NULL,
    -> regdate DATETIME NOT NULL,
    -> PRIMARY KEY(id)
    -> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'CREAT
A TABLE grade(
id TINYINT(2) UNSIGEND NOT NULL AUTO_INCREMENT,
name VARCHAR' at line 1
mysql> CREATA TABLE grade(
    -> id TINYINT(2) UNSIGEND NOT NULL AUTO_INCREMENT,
    -> name VARCHAR(20) NOT NULL,
    -> \c
mysql> CREATE TABLE grade(
    -> id TINYINT(2) UNSIGEND NOT NULL AUTO_INCREMENT,
    -> name VARCHAR(20) NOT NULL,
    -> email VARCHAR(40),
    -> point TINYINT(3) UNSIGNED NOT NULL,
    -> regdate DATETIME NOT NULL,
    -> PRIMARY KEY(id)
    -> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'UNSIG
END NOT NULL AUTO_INCREMENT,
name VARCHAR(20) NOT NULL,
email VARCHAR(40),
' at line 2
mysql> CREATE TABLE grade(
    -> id TINYINT(2) UNSIGEND NOT NULL AUTO_INCREMENT,\C
ERROR:
Usage: \C char_setname | charset charset_name
    -> \c
mysql> CREATE TABLE grade(
    -> id TINYINT(2) UNSIGEND NOT NULL AUTO_INCREMENT,
    -> name VARCHAR(20) NOT NULL,
    -> email VARCHAR(40),
    -> point TINYINT(3) UNSIGNED NOT NULL,
    -> regdate DATETIME NOT NULL,
    -> PRIMARY KEY(id)
    -> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'UNSIG
END NOT NULL AUTO_INCREMENT,
name VARCHAR(20) NOT NULL,
email VARCHAR(40),
' at line 2
mysql> CREATE TABLE grade(
    -> id TINYINT(2) UNSIGNED NOT NULL AUTO_INCREMENT,
    -> name VARCHAR(20) NOT NULL,
    -> email VARCHAR(40),
    -> point TINYINT(3) UNSIGNED NOT NULL,
    -> regdate DATETIME NOT NULL,
    -> PRIMARY KEY(id)
    -> );
Query OK, 0 rows affected (0.01 sec)

mysql> SHOW TABLES;
+------------------+
| Tables_in_school |
+------------------+
| grade            |
+------------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM grade;
Empty set (0.00 sec)

mysql> DESC grade;
+---------+---------------------+------+-----+---------+----------------+
| Field   | Type                | Null | Key | Default | Extra          |
+---------+---------------------+------+-----+---------+----------------+
| id      | tinyint(2) unsigned | NO   | PRI | NULL    | auto_increment |
| name    | varchar(20)         | NO   |     | NULL    |                |
| email   | varchar(40)         | YES  |     | NULL    |                |
| point   | tinyint(3) unsigned | NO   |     | NULL    |                |
| regdate | datetime            | NO   |     | NULL    |                |
+---------+---------------------+------+-----+---------+----------------+
5 rows in set (0.02 sec)

mysql> INSERT INTO grage (name,email,point,regdate) VALUES ('oneStopWeb','oneSto
pWeb@163.com',88,NOW())
    -> ;
ERROR 1146 (42S02): Table 'school.grage' doesn't exist
mysql> INSERT INTO grade (name,email,point,regdate) VALUES ('oneStopWeb','oneSto
pWeb@163.com',88,NOW());
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM grade;
+----+------------+--------------------+-------+---------------------+
| id | name       | email              | point | regdate             |
+----+------------+--------------------+-------+---------------------+
|  1 | oneStopWeb | oneStopWeb@163.com |    88 | 2015-04-23 17:45:02 |
+----+------------+--------------------+-------+---------------------+
1 row in set (0.00 sec)

mysql> INSERT INTO grade (name,email,point,regdate) VALUES ('chaoyi','chaoyi@163
.com',92,NOW());
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO grade (name,email,point,regdate) VALUES ('chaoyi77','chaoyi@1
63.com',92,NOW());
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO grade (name,email,point,regdate) VALUES ('chaoyv','chaoyv@163
.com',32,NOW());
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM grade;
+----+------------+--------------------+-------+---------------------+
| id | name       | email              | point | regdate             |
+----+------------+--------------------+-------+---------------------+
|  1 | oneStopWeb | oneStopWeb@163.com |    88 | 2015-04-23 17:45:02 |
|  2 | chaoyi     | chaoyi@163.com     |    92 | 2015-04-23 17:46:45 |
|  3 | chaoyi77   | chaoyi@163.com     |    92 | 2015-04-23 17:46:53 |
|  4 | chaoyv     | chaoyv@163.com     |    32 | 2015-04-23 17:47:17 |
+----+------------+--------------------+-------+---------------------+
4 rows in set (0.00 sec)

mysql> INSERT INTO grade (name,email,point,regdate) VALUES ('yike',NULL,32,NOW()
);
Query OK, 1 row affected (0.00 sec)

mysql> SELECT id,name,email FROM grade;
+----+------------+--------------------+
| id | name       | email              |
+----+------------+--------------------+
|  1 | oneStopWeb | oneStopWeb@163.com |
|  2 | chaoyi     | chaoyi@163.com     |
|  3 | chaoyi77   | chaoyi@163.com     |
|  4 | chaoyv     | chaoyv@163.com     |
|  5 | yike       | NULL               |
+----+------------+--------------------+
5 rows in set (0.00 sec)

mysql>

 

Demo9.txt

Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.0.51b-community-nt-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> USE grade;
ERROR 1049 (42000): Unknown database 'grade'
mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| guest              |
| mysql              |
| phpmyadmin         |
| school             |
| test               |
| ultrax             |
+--------------------+
7 rows in set (0.00 sec)

mysql> CREATA DATABASE school;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'CREAT
A DATABASE school' at line 1
mysql> USE school
Database changed
mysql> select * from grade;
+----+------------+--------------------+-------+---------------------+
| id | name       | email              | point | regdate             |
+----+------------+--------------------+-------+---------------------+
|  1 | oneStopWeb | oneStopWeb@163.com |    88 | 2015-04-23 17:45:02 |
|  2 | chaoyi     | chaoyi@163.com     |    92 | 2015-04-23 17:46:45 |
|  3 | chaoyi77   | chaoyi@163.com     |    92 | 2015-04-23 17:46:53 |
|  4 | chaoyv     | chaoyv@163.com     |    32 | 2015-04-23 17:47:17 |
|  5 | yike       | NULL               |    32 | 2015-04-23 17:51:27 |
+----+------------+--------------------+-------+---------------------+
5 rows in set (0.00 sec)

mysql> SELECT * FROM grade WHERE name='chaoyi';
+----+--------+----------------+-------+---------------------+
| id | name   | email          | point | regdate             |
+----+--------+----------------+-------+---------------------+
|  2 | chaoyi | chaoyi@163.com |    92 | 2015-04-23 17:46:45 |
+----+--------+----------------+-------+---------------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM grade WHERE porint > 90;
ERROR 1054 (42S22): Unknown column 'porint' in 'where clause'
mysql> SELECT * FROM grade WHERE point > 90;
+----+----------+----------------+-------+---------------------+
| id | name     | email          | point | regdate             |
+----+----------+----------------+-------+---------------------+
|  2 | chaoyi   | chaoyi@163.com |    92 | 2015-04-23 17:46:45 |
|  3 | chaoyi77 | chaoyi@163.com |    92 | 2015-04-23 17:46:53 |
+----+----------+----------------+-------+---------------------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM grade WHERE email IS NOT NULL;
+----+------------+--------------------+-------+---------------------+
| id | name       | email              | point | regdate             |
+----+------------+--------------------+-------+---------------------+
|  1 | oneStopWeb | oneStopWeb@163.com |    88 | 2015-04-23 17:45:02 |
|  2 | chaoyi     | chaoyi@163.com     |    92 | 2015-04-23 17:46:45 |
|  3 | chaoyi77   | chaoyi@163.com     |    92 | 2015-04-23 17:46:53 |
|  4 | chaoyv     | chaoyv@163.com     |    32 | 2015-04-23 17:47:17 |
+----+------------+--------------------+-------+---------------------+
4 rows in set (0.00 sec)

mysql> SELECT * FROM grade WHERE email IS NULL;
+----+------+-------+-------+---------------------+
| id | name | email | point | regdate             |
+----+------+-------+-------+---------------------+
|  5 | yike | NULL  |    32 | 2015-04-23 17:51:27 |
+----+------+-------+-------+---------------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM grade WHERE point BETWEEN 70 AND 90;
+----+------------+--------------------+-------+---------------------+
| id | name       | email              | point | regdate             |
+----+------------+--------------------+-------+---------------------+
|  1 | oneStopWeb | oneStopWeb@163.com |    88 | 2015-04-23 17:45:02 |
+----+------------+--------------------+-------+---------------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM grade WHERE point IN(32,88,92);
+----+------------+--------------------+-------+---------------------+
| id | name       | email              | point | regdate             |
+----+------------+--------------------+-------+---------------------+
|  1 | oneStopWeb | oneStopWeb@163.com |    88 | 2015-04-23 17:45:02 |
|  2 | chaoyi     | chaoyi@163.com     |    92 | 2015-04-23 17:46:45 |
|  3 | chaoyi77   | chaoyi@163.com     |    92 | 2015-04-23 17:46:53 |
|  4 | chaoyv     | chaoyv@163.com     |    32 | 2015-04-23 17:47:17 |
|  5 | yike       | NULL               |    32 | 2015-04-23 17:51:27 |
+----+------------+--------------------+-------+---------------------+
5 rows in set (0.00 sec)

mysql> SELECT * FROM grade WHERE name = 'oneStopWeb' or name = 'chaoyi'
    -> ;
+----+------------+--------------------+-------+---------------------+
| id | name       | email              | point | regdate             |
+----+------------+--------------------+-------+---------------------+
|  1 | oneStopWeb | oneStopWeb@163.com |    88 | 2015-04-23 17:45:02 |
|  2 | chaoyi     | chaoyi@163.com     |    92 | 2015-04-23 17:46:45 |
+----+------------+--------------------+-------+---------------------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM grade WHERE email LIKE '%163.com';
+----+------------+--------------------+-------+---------------------+
| id | name       | email              | point | regdate             |
+----+------------+--------------------+-------+---------------------+
|  1 | oneStopWeb | oneStopWeb@163.com |    88 | 2015-04-23 17:45:02 |
|  2 | chaoyi     | chaoyi@163.com     |    92 | 2015-04-23 17:46:45 |
|  3 | chaoyi77   | chaoyi@163.com     |    92 | 2015-04-23 17:46:53 |
|  4 | chaoyv     | chaoyv@163.com     |    32 | 2015-04-23 17:47:17 |
+----+------------+--------------------+-------+---------------------+
4 rows in set (0.02 sec)

mysql> SELECT * FROM grade WHERE email LIKE '163.com%';
Empty set (0.00 sec)

mysql> SELECT * FROM grade WHERE email LIKE '%chaoyi%';
+----+----------+----------------+-------+---------------------+
| id | name     | email          | point | regdate             |
+----+----------+----------------+-------+---------------------+
|  2 | chaoyi   | chaoyi@163.com |    92 | 2015-04-23 17:46:45 |
|  3 | chaoyi77 | chaoyi@163.com |    92 | 2015-04-23 17:46:53 |
+----+----------+----------------+-------+---------------------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM grade WHERE email NOT LIKE '%chaoyi%';
+----+------------+--------------------+-------+---------------------+
| id | name       | email              | point | regdate             |
+----+------------+--------------------+-------+---------------------+
|  1 | oneStopWeb | oneStopWeb@163.com |    88 | 2015-04-23 17:45:02 |
|  4 | chaoyv     | chaoyv@163.com     |    32 | 2015-04-23 17:47:17 |
+----+------------+--------------------+-------+---------------------+
2 rows in set (0.01 sec)

mysql> SELECT * FROM grade ORDER BY DESC;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'DESC'
 at line 1
mysql> SELECT * FROM grade ORDER BY regdate DESC;
+----+------------+--------------------+-------+---------------------+
| id | name       | email              | point | regdate             |
+----+------------+--------------------+-------+---------------------+
|  5 | yike       | NULL               |    32 | 2015-04-23 17:51:27 |
|  4 | chaoyv     | chaoyv@163.com     |    32 | 2015-04-23 17:47:17 |
|  3 | chaoyi77   | chaoyi@163.com     |    92 | 2015-04-23 17:46:53 |
|  2 | chaoyi     | chaoyi@163.com     |    92 | 2015-04-23 17:46:45 |
|  1 | oneStopWeb | oneStopWeb@163.com |    88 | 2015-04-23 17:45:02 |
+----+------------+--------------------+-------+---------------------+
5 rows in set (0.00 sec)

mysql> SELECT * FROM grade LIMIT 3;
+----+------------+--------------------+-------+---------------------+
| id | name       | email              | point | regdate             |
+----+------------+--------------------+-------+---------------------+
|  1 | oneStopWeb | oneStopWeb@163.com |    88 | 2015-04-23 17:45:02 |
|  2 | chaoyi     | chaoyi@163.com     |    92 | 2015-04-23 17:46:45 |
|  3 | chaoyi77   | chaoyi@163.com     |    92 | 2015-04-23 17:46:53 |
+----+------------+--------------------+-------+---------------------+
3 rows in set (0.00 sec)

mysql> SELECT * FROM grade LIMIT 3,3;
+----+--------+----------------+-------+---------------------+
| id | name   | email          | point | regdate             |
+----+--------+----------------+-------+---------------------+
|  4 | chaoyv | chaoyv@163.com |    32 | 2015-04-23 17:47:17 |
|  5 | yike   | NULL           |    32 | 2015-04-23 17:51:27 |
+----+--------+----------------+-------+---------------------+
2 rows in set (0.00 sec)

mysql> UPDATE grade SET email='yy@qq.com' WHERE name='chaoyi77'
    -> ;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> SELECT * FROM grade;
+----+------------+--------------------+-------+---------------------+
| id | name       | email              | point | regdate             |
+----+------------+--------------------+-------+---------------------+
|  1 | oneStopWeb | oneStopWeb@163.com |    88 | 2015-04-23 17:45:02 |
|  2 | chaoyi     | chaoyi@163.com     |    92 | 2015-04-23 17:46:45 |
|  3 | chaoyi77   | yy@qq.com          |    92 | 2015-04-23 17:46:53 |
|  4 | chaoyv     | chaoyv@163.com     |    32 | 2015-04-23 17:47:17 |
|  5 | yike       | NULL               |    32 | 2015-04-23 17:51:27 |
+----+------------+--------------------+-------+---------------------+
5 rows in set (0.00 sec)

mysql> DELETE FROM grade WHERE id=3;
Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM grade;
+----+------------+--------------------+-------+---------------------+
| id | name       | email              | point | regdate             |
+----+------------+--------------------+-------+---------------------+
|  1 | oneStopWeb | oneStopWeb@163.com |    88 | 2015-04-23 17:45:02 |
|  2 | chaoyi     | chaoyi@163.com     |    92 | 2015-04-23 17:46:45 |
|  4 | chaoyv     | chaoyv@163.com     |    32 | 2015-04-23 17:47:17 |
|  5 | yike       | NULL               |    32 | 2015-04-23 17:51:27 |
+----+------------+--------------------+-------+---------------------+
4 rows in set (0.00 sec)

mysql> SELECT AVG(point) FROM grade;
+------------+
| AVG(point) |
+------------+
|    61.0000 |
+------------+
1 row in set (0.00 sec)

mysql> SELECT AVG(point) as avg FROM grade;
+---------+
| avg     |
+---------+
| 61.0000 |
+---------+
1 row in set (0.00 sec)

mysql> SELECT COUNT(*) AS count FROM grade;
+-------+
| count |
+-------+
|     4 |
+-------+
1 row in set (0.00 sec)

mysql> SELECT COUNT(email) AS count FROM grade;
+-------+
| count |
+-------+
|     3 |
+-------+
1 row in set (0.00 sec)

mysql> SELECT MAX(point) FROM grade;
+------------+
| MAX(point) |
+------------+
|         92 |
+------------+
1 row in set (0.02 sec)

mysql> SELECT SUM(point) FROM grade;
+------------+
| SUM(point) |
+------------+
|        244 |
+------------+
1 row in set (0.00 sec)

mysql> SHOW TABLE STATUS\G;
*************************** 1. row ***************************
           Name: grade
         Engine: MyISAM
        Version: 10
     Row_format: Dynamic
           Rows: 4
 Avg_row_length: 38
    Data_length: 192
Max_data_length: 281474976710655
   Index_length: 2048
      Data_free: 40
 Auto_increment: 6
    Create_time: 2015-04-23 17:39:39
    Update_time: 2015-04-23 18:22:36
     Check_time: NULL
      Collation: utf8_general_ci
       Checksum: NULL
 Create_options:
        Comment:
1 row in set (0.00 sec)

ERROR:
No query specified

mysql> OPTIMIXE TABLE grade;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'OPTIM
IXE TABLE grade' at line 1
mysql> OPTIMIZE TABLE grade;
+--------------+----------+----------+----------+
| Table        | Op       | Msg_type | Msg_text |
+--------------+----------+----------+----------+
| school.grade | optimize | status   | OK       |
+--------------+----------+----------+----------+
1 row in set (0.02 sec)

mysql> SHOW TABLE STATUS\G;
*************************** 1. row ***************************
           Name: grade
         Engine: MyISAM
        Version: 10
     Row_format: Dynamic
           Rows: 4
 Avg_row_length: 38
    Data_length: 152
Max_data_length: 281474976710655
   Index_length: 2048
      Data_free: 0
 Auto_increment: 6
    Create_time: 2015-04-23 17:39:39
    Update_time: 2015-04-23 18:24:59
     Check_time: 2015-04-23 18:24:59
      Collation: utf8_general_ci
       Checksum: NULL
 Create_options:
        Comment:
1 row in set (0.02 sec)

ERROR:
No query specified

mysql>

 

localhost.sql

-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
-- 
-- 主机: localhost
-- 生成日期: 2015 年 04 月 23 日 10:56
-- 服务器版本: 5.0.51
-- PHP 版本: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- 数据库: `school`
-- 
CREATE DATABASE `school` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `school`;

-- --------------------------------------------------------

-- 
-- 表的结构 `grade`
-- 

CREATE TABLE `grade` (
  `id` tinyint(2) unsigned NOT NULL auto_increment,
  `name` varchar(20) NOT NULL,
  `email` varchar(40) default NULL,
  `point` tinyint(3) unsigned NOT NULL,
  `regdate` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

-- 
-- 导出表中的数据 `grade`
-- 

INSERT INTO `grade` VALUES (1, '一站式建网站', 'oneStopWeb@163.com', 97, '2015-04-23 18:38:28');
INSERT INTO `grade` VALUES (2, '吴者然', 'chaoyi@163.com', 89, '2015-04-09 18:40:06');
INSERT INTO `grade` VALUES (3, '李雷', 'lilei@qq.com', 60, '2015-04-09 18:40:57');
INSERT INTO `grade` VALUES (4, '杰克', 'jack@163.com', 78, '2015-04-08 18:41:45');
INSERT INTO `grade` VALUES (5, '伊客', 'yike@163.com', 64, '2015-04-11 18:42:17');

 

创建数据库和字符编码

 

创建表

 


 

iteye_17658
关注
专栏目录
第 15 章 MySQL 数据库
08-08
MySQL 数据库是世界上最受欢迎的关系型数据库管理系统之一，广泛应用于网页应用、数据分析、云计算等领域。本章将深入探讨 MySQL 的核心概念、安装与配置、数据类型、表的设计、查询语句、索引、事务处理以及备份...
不同mysql版本数据导入出现的问题_不同mysql版本数据导入出现的问题
weixin_39657125的博客
02-11 147
原mysql的版本是：3.4.10.1deb1，目标mysql的版本是：5.0.51b-community-nt-log，导入数据时出现了一下问题：1、DELIMITERYouhaveanerrorinyourSQLsyntax;checkt原mysql的版本是：3.4.10.1deb1，目标mysql的版本是：5.0.51b-community-nt-log，导入数据时出现了一下问题：1、DEL...
控制台报错：Unknown database ‘xxxxx‘ 未知的数据库‘xxxxx’
一只努力的小Java
03-19 1万+
控制台报错：Unknown database ‘xxxxx’ 未知的数据库‘xxxxx’。 解决方案： 检查数据库：检查数据库名称是否正确，有无空格。 检查Java代码：检查Java数据库链接配置url中的数据库名字是否和数据库一致。 案例：Java程序运行报这个异常，检查了url数据库名称和数据库中的名称一致，还是一致报错，经过多次检查之后数据库名称是一样的，但是在navicat里面数据库名...
mysql登陆出现unknown database错误可能原因
weixin_34138521的博客
05-14 5606
输入了错误命令如 # mysql -u root -p test 然后客户端会出现需要输入命令的提示,即使输入正确出现错误提示 正确命令是 # mysql -u root -p 转载于:https://www.cnblogs.com/zuoxiaobing/p/3728502.html...
Unknown database ‘???????菘‘ when selecting the database
qq_41347365的博客
08-25 1610
Unknown database '???????菘' when selecting the database Warning: Using a password on the command line interface can be insecure. Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
查看Mysql版本的四种方法
clsq56933的博客
05-10 289
1.D:\MySql\bin>mysql -V mysql Ver 14.12 Distrib 5.0.51b, for Win32 (ia32) 2.mysql> status;--------------...
第15章MySQL数据库备份与还原.pdf
06-29
MySQL数据库的备份与还原是确保数据安全性和完整性的关键步骤，尤其在面临各种可能导致数据丢失的风险，如硬件故障、软件问题、自然灾害、人为错误或病毒攻击时。本章重点介绍了几种备份策略及其优缺点。 首先，...
第15章MySQL数据库备份与还原.docx
06-14
MySQL 数据库备份与还原 数据库系统原理及 MySQL 应用教程中，备份和恢复策略是非常重要的，因为数据库中的数据可能会由于各种原因而丢失或被破坏，例如计算机硬件故障、计算机软件故障、自然灾害、盗窃、病毒、...
mysql数据库武洪萍版第五章习题与答案.docx
01-12
MySQL 数据库武洪萍版第五章习题与答案 本资源摘要信息主要是基于 MySQL 数据库武洪萍版第五章习题与答案，涵盖了数据库索引、视图、触发器、存储过程和函数等多个方面的知识点。 1. 数据库索引：索引是数据库中...
控制台报错：Unknown database 'xxxxx'
Sun_xiangyan的博客
06-10 6044
https://blog.csdn.net/qq_37968867/article/details/89707149
MySQL出现：ERROR 1049 (42000): Unknown database 'XXX'解决方法
热门推荐
鄙人kunzhi96，感恩遇见！
04-11 7万+
问题 记得之前安装MySQL数据库的时候，就是通过命令行输入 mysql -u root -p password 今天在输入的时候却发现命令输入不正确，而且会要求再输入一遍密码，然后返回 “ERROR 1049 (42000): Unknown database '123'” 如图显示 这个错误提示是不知道123这个数据库，意思是-p后面的password代表的是数据库名称。但-p后面的参数...
SQLite中出现错误：Error: near ")": syntax error
www121104115的博客
07-13 7万+
如图片中黄色线框中，是因为在创建表格时最后一句中多加了一个 “逗号”，去掉就行了！
mysql怎么导入数据库 1049 42000 unknown database
weixin_33958366的博客
01-12 1304
前很多年, 使用mysqldump / mysql 进行数据库的备份和恢复, 都非常成功, 但是, 这周换了windows2012 r2 和 mysql 5.6.15后, 并加一个discuz论坛是可以访问的 备份数据库是没有问题的, 但数据库恢复有两个错误: 1 测试1 命令行 .\mysql -uroot -p...
mysql ERROR 1049 (42000): Unknown database *********错误处理办法
K的博客
07-31 6万+
当初刚装MySQL的时候，到网上查的命令行登陆MySQL的方法都是mysql -h localhost -u root -p password 例如：mysql -h localhost -u root -p password 但是奇怪的是这条命令我输进去死活都不对，它都会要求再输入一遍密码，然后返回 “ERROR 1049 (42000): Unknown database
Unknown database连接数据库错误
m0_50659983的博客
10-30 3万+
Unknown database连接数据库错误 新建了一个数据库的URL，可是链接的时候发现找不到数据库名称，显 示： Unknown database ‘webstore’ 检查了用户名和密码都没有错误，我用的工具是navicat,后来看了别人博客，有类似问题，是因为建立了链接后，还要在目录 下再建立数据库 这样就可以了，就能连接数据库了 新建数据库的字符集和排序顺序可以是： ...
解决Unknown database ‘XXX‘
qq_45256347的博客
04-21 7519
运行项目就老是出现 Unknown database 'psychology’这个，psychology是我的数据库名称，我也在navicat里面建了数据库了，可是就是显示找不到，后来我查了资料要在里面建 一开始只有1，后来我新建了2，就不会显示了。 来源：https://blog.csdn.net/weixin_30270889/article/details/96253778 ...
MySQL8.0数据库全面教程，包含26章PPT及源代码
第15章 MySQL日志 本章深入介绍了MySQL中不同类型的日志，包括错误日志、查询日志、慢查询日志、二进制日志等，以及它们的使用和管理。 第16章 性能优化 本章讲解了数据库性能优化的基本概念和技术，包括查询优化、...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值