if table created without any error then it will show following statement
Query OK,0rows affected(1.44sec)
This query will result a table with the above fields. The first column will hold number while other columns are type of varchar.
Create Table in Mysql with primary key
Above mysql create statement create a student table with primary key id, with auto increment field value and two unique keys mobile_no and email_id, at the time of creating user add_date is added CURRENT_TIMESTAMP as default value.
This table also uses mysql create table auto_increment
MySql create table if not exists
Syntax of create table if not exist is CREATE TABLE IF NOT EXISTS table_name(............);
To modity the student table with CREATE TABLE IF NOT EXISTS the query is as below
InnoDB Monitors provide information about the InnoDB internal state. This information is useful for performance tuning. Each Monitor can be enabled by creating a table with a special name, which causes InnoDB to write Monitor output periodically. Also, output for the standard InnoDB Monitor is available on demand through the SHOW ENGINE INNODB STATUS SQL statement.
There are several types of InnoDB Monitors:
The standard InnoDB Monitor displays the following types of information:
Table and record locks held by each active transaction
Lock waits of a transactions
Semaphore waits of threads
Pending file I/O requests
Buffer pool statistics
Purge and insert buffer merge activity of the main InnoDB thread
To enable the standard InnoDB Monitor for periodic output, create a table named innodb_monitor. To obtain Monitor output on demand, use the SHOW ENGINE INNODB STATUS SQL statement to fetch the output to your client program. If you are using the mysql interactive client, the output is more readable if you replace the usual semicolon statement terminator with \G: