onlinetutorialspoint.com
MySQL Create Table Syntax Example
Here we will understand the MySQL create table syntax with constraints. 1. MySQL Create Table: A simple create table example without applying any keys and constraints. CREATE TABLE `employee` ( `id` INT(11), `firstname` VARCHAR(150), `middlename` VARCHAR(150), `lastname` VARCHAR(150), `salary` DOUBLE, `designation` VARCHAR(100) )ENGINE=InnoDB; If we don't provide any constraints to the columns SQL