《Mysql基础》【Mysql删除数据库、新建数据库、修改数据库】 编程入门 学习分享 【公开免费】
-- mysql数据库程序设计笔记:
数据定义: 1、创建数据库: 如: create database db_pro_1 default charset gb2312 collate gb2312_chinese_ci; Query OK, 1 row affected (0.00 sec) 或: create database db_pro_2 default character set gb2312 default collate gb2312_chinese_ci; Query OK, 1 row affected (0.00 sec) -------- 查看整个mysql数据库字符集:show variables like 'character%'; +--------------------------+---------------------------------------------------------+ | Variable_name | Value | +--------------------------+---------------------------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ | +--------------------------+---------------------------------------------------------+ 8 rows in set (0.05 sec) -------- 2、选择与查询数据库: 选择数据库: use db_pro_1; 查看数据库: show databases; 3、修改数据库: alter database db_pro_1 default character set utf8 default collate utf8_general_ci; Query OK, 1 row affected (0.00 sec) 4、删除: drop database 库名;