1.

Explain create table statement and its difference with show create table

Answer»

CREATE TABLE [IF NOT EXISTS] table_name(     column_list ) ENGINE=storage_engine CREATE TABLE `test`.`car` ( `id` INT(12) NULL AUTO_INCREMENT , `NAME` VARCHAR(20) NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;

SHOW create table statement shows the CREATE TABLE statement that CREATES the named table.


Discussion

No Comment Found

Related InterviewSolutions