MySQL database creation and deletion instance

Create DATABASE syntax

Create DATABASE Tutorial Name

Used to create a database and name it. If you want to use the CREATE DATABASE, you will need to get the DB Create permission.

ALTER TABLE syntax

alter [ignore] table Tbl_name

ALTER TABLE is used to change the structure of an existing table. For example, you can add or subtract columns, create or cancel an index, change the type of an existing column, or rename a column or table. You can also change the annotation of the table and the type of the table.

The syntax of many clauses is similar to the syntax of the clauses in CREATE table in the allowed changes. These include table_options modifications, options with engine, auto_increment and Avg_row_length

Note:

To use ALTER TABLE, you need to obtain alter, INSERT, and create permissions for the table

Ignore is an extension of the MySQL tutorial relative to standard SQL. If you have duplicate keywords in a new table, or if a warning occurs after strict mode starts