Create and delete an instance for a mysql database

Create database syntax

Create database tutorial name

Create and name a database. To use create database, you must obtain the create permission for the database.

Alter table syntax

Alter [ignore] table tbl_name

Alter table is used to change the structure of the original table. For example, you can add or delete columns, create or cancel indexes, change the type of original columns, or rename columns or tables. You can also modify the table comment and table type.

In the changes allowed, the syntax of many clauses is similar to that of the clauses in create table. This includes table_options modification. The options include engine, auto_increment, and avg_row_length.

Note:

To use alter table, you must obtain the alter, insert, and create permissions for the table.

Ignore is an extension of the mysql tutorial to the standard SQL. If there are duplicate keywords in the new table, or a warning appears when strict mode is enabled