sql query to create table 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: create table sql
CREATE TABLE table_name(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255),
date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
longtext BLOB
);
Example 3: how to create table in sql
CREATE TABLE students
( student_id number(4) primary key,
last_name varchar2(30) NOT NULL,
course_id number(4) NULL );
INSERT INTO students VALUES (200, 'Jones', 101);
INSERT INTO students VALUES (201, 'Smith', 101);
INSERT INTO students VALUE (202, 'Lee' , 102);
Example 4: create table in mysql
CREATE TABLE user (
userId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(100),
password VARCHAR(100)
) ENGINE=InnoDB;
Example 5: 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 6: sql create table
CREATE TABLE Persons (
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);