creating table SQL code example
Example 1: create table sql
CREATE TABLE vehicle(
vehicleId INT NOT NULL,
make VARCHAR(64),
model VARCHAR(128),
derivative VARCHAR(255),
PRIMARY KEY(vehicleId)
);
INSERT INTO vehicle VALUES(1000,'Volkswagen','Golf','1.5 TSI EVO Match Edition 5dr');
Example 2: how to create table in sql
CREATE TABLE user (
userId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(100),
password VARCHAR(100)
) ENGINE=InnoDB;
Example 3: sql create table
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
....
);
Example 4: create table syntax
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
....
);