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