数据库的基本操作

Mysql语句的规法
- 关键字与函数名称全部大写
- 数据库名称、表名称、字段名称全小写
- SQL语句必须以分号结尾

创建数据库

CREATE {DATABSE | SCHEMA} [IF NOT EXISTS] db_name [DEFAULT] CHARACTER SET [=] charset_name {内是必须写的} [可选的].

 root@localhost  (none)>CREATE DATABASE ti;
Query OK, 1 row affected (0.00 sec)

root@localhost  (none)>USE ti
Database changed

mysql> CREATE DATABASE ti;
ERROR 1007 (HY000): Can't create database 'ti'; database exists


mysql> CREATE DATABASE IF NOT EXISTS ti;
Query OK, 1 row affected, 1 warning (0.00 sec)

#查看警告
mysql> SHOW WARNINGS;
+-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Code | Message                                                                                                                                                   |
+-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
| Error | 1064 | 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 'WARNING' at line 1 |
+-------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

查看数据库

SHOW { DATABASES | SCHEMAS } [ LINE ‘pattern’ | WHERE expr ]

mysql> SHOW CREATE DATABASE ti;
+----------+-------------------------------------------------------------+
| Database | Create Database                                             |
+----------+-------------------------------------------------------------+
| ti       | CREATE DATABASE `ti` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+-------------------------------------------------------------+
1 row in set (0.00 sec)

修改数据库

ALTER {DATABASE | SCHENA } [db_name] [DEFAULT] CHARACTER SET [=] charset_name #修改数据库的编码方式

删除数据库

DROP { DATABASE | SCHEMA } [IF EXISTS] db_name

修改 MySQL密码

mysql> SET PASSWORD=PASSWORD('root')
    -> ;
Query OK, 0 rows affected, 1 warning (0.13 sec)

mysql> \q
Bye

C:\Windows\system32>mysql -uroot -proot