Shulou(Shulou.com)06/01 Report--

System database:

Information_schema: virtual library, which mainly stores the information of some database objects in the system, such as user table information, column information, permission information, character information, etc.

Informance_schema: mainly stores performance parameters of the database server

Mysql: authorization library, which mainly stores the permission information of system users.

Sys: mainly stores performance parameters of the database server

Database naming rules:

Case sensitive

Uniqueness

Cannot use keywords such as create select

You cannot use numbers alone.

Every sql statement ends with; and\ g

\ G end: the function is to rotate the found structure 90 degrees to become longitudinal.

Create a database: DDL

Create database wing

View the database

Show databases

Show create database wing

View the current library:

Select database ()

Switch database

Use wing

Show tables

Delete database

Drop database

Drop database wing

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.