Sql create table

This article is tagged with: Sql create table and mysql

how to create table in sql

# Creates a Simple User table
# Uses an auto-incrementing primary key as userId
CREATE TABLE user (
userId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(100),
password VARCHAR(100)
) ENGINE=InnoDB;

create table sql

# Simple table describing a vehicle
CREATE TABLE vehicle(
# vehicleId: Unique ID for Primary Key.
# This is how we will reference a record
vehicleId INT NOT NULL,
make VARCHAR(64), # String 64 chars max
model VARCHAR(128),
derivative VARCHAR(255),
PRIMARY KEY(vehicleId)
);
# Add a record
INSERT INTO vehicle VALUES(1000,'Volkswagen','Golf','1.5 TSI EVO Match Edition 5dr');

create table sql

CREATE TABLE table_name(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255), # String 255 chars max
date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
longtext BLOB
);

sql create table

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype,
  
....
);

sql create table

Creates a new table .
Example: Creates a new table called ‘users’ in the ‘websitesetup’ database.
CREATE TABLE users (
id int,
first_name varchar(255),
surname varchar(255),
address varchar(255),
contact_number int
);

sql create table

CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,

....
);

This article is tagged with: Sql create table and mysql