Simple database operation

To create a database:

Creating a database of the default character set CREATE Database Oldboy;show Create databases oldboy\g creates a DB Odlboy_utf8 default character for the specified character set Set UTF8 collate utf8_general_ci;show CREATE database oldboy_utf8\gcreate database OLDBOY_GBK default character set GBK Co Llate gbk_chinese_ci;show CREATE Database Odlboy_gbk\g

Display Database

Shows all databases show databases; Displays the current database select database (); Displays the specified databases like ' Oldboy '; Displays the database of the specified range show as '%o ldboy% ';

Deleting a database

Drop database Oldboy;

Connecting to a database

Use Oldboy; Add or add; Select Database (); Display the current DB select version (); Display version number select User (); Show users select Now (); Show time

　　

　

Simple database operation