MySQL Library operations

I. Creating a Database

1. Syntax

Create database name CharSet UTF8;

2. Database Naming conventions

Can be composed of letters, numbers, underscores, @,#,$

Case sensitive

Uniqueness

You cannot use keywords such as create select

Numbers cannot be used alone

Maximum 128 bits

 1   view database show databases; Show  create  database   DB1;  select  database   ();  2   select database  use   database name  3   delete database  drop  database   database name;  4   Modify database  alter  database  db1 CharSet UTF8 

MySQL Library operations