程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
您现在的位置: 程式師世界 >> 編程語言 >  >> 更多編程語言 >> Python

Introduction to Python development learning notes master the addition, deletion, modification and query of the concept Library

編輯:Python

The point of this section

Master the addition, deletion, modification and query of concept base
The duration of this section needs to be controlled 10 Within minutes

One System database

information_schema: Virtual Library , No disk space , It stores some parameters after the database is started , Such as user table information 、 Column information 、 Permission information 、 Character information, etc
performance_schema: MySQL 5.5 Start adding a database : Mainly used to collect database server performance parameters , Record various events that occur when processing query requests 、 Lock and so on
mysql: Authorization Library , Main storage system user's permission information
test: MySQL Database system automatically created test database

Two Create database

1 grammar (help create database)

CREATE DATABASE Database name charset utf8;

2 Database naming rules :

 It can be made of letters 、 Numbers 、 Underline 、@、#、$
Case sensitive
Uniqueness
You can't use keywords like create select
Numbers cannot be used alone
The longest 128 position

3、 ... and Database related operations

 view the database
show databases;
show create database db1;
select database();
Select database
USE Database name
Delete database
DROP DATABASE Database name ;
modify the database
alter database db1 charset utf8;

  1. 上一篇文章:
  2. 下一篇文章:
Copyright © 程式師世界 All Rights Reserved