Home > database >  MySQL basic operation
MySQL basic operation

Time:09-16

1?? The basic operations of a database

View the current of all database
SHOW the DATABASE;
Create a basic database SQL syntax format
The CREATE DATABASE database_name;
Created database, check the database definition
SHOW the CREATE DATABASE;
Delete the database
The DROP DATABASE database_name;//need to be very cautious when using, MySQL does not give any hint, delete after deleted along with data tables and data, and cannot be recovered,
2?? Database storage engine
Check the system supported by the engine type
SHOW ENGINES;