Creating a table in sql

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
);

How to create table in sql

//to create a table
CREATE TABLE students
( student_id number(4) primary key,
  last_name varchar2(30) NOT NULL,
  course_id number(4) NULL );

//to insert value
INSERT INTO students VALUES (200, 'Jones', 101);
INSERT INTO students VALUES (201, 'Smith', 101);
INSERT INTO students VALUE (202, 'Lee' , 102);

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 Persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
);

Creating a table in sql

//to create a table
CREATE TABLE students
( student_id number(4) primary key,
  last_name varchar2(30) NOT NULL,
  course_id number(4) NULL );

//to insert value
INSERT INTO students VALUES (200, 'Jones', 101);
INSERT INTO students VALUES (201, 'Smith', 101);
INSERT INTO students VALUE (202, 'Lee' , 102);

Sql create table

CREATE TABLE li_wedding (
   guest_id INT,
   last_name VARCHAR(255),
   first_name VARCHAR(255),
   attending BOOL,
   diet VARCHAR(255)
);

Source: education.launchcode.org

Similar codes

0 vote253 views1 answer
Trigger value from maltiple table to single table mysql
SQL
1 vote264 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
12 votes261 views4 answers
Mysql get date difference in hours
SQL
10 votes255 views2 answers
Linux command line import mysql database
SQL
4 votes297 views3 answers
Postgres drop all tables
SQL
0 vote258 views2 answers
How to generate a unique random number in mysql
SQL
0 vote253 views1 answer
Postgresql create user roles
SQL
3 votes244 views1 answer
Search for column name in psql
SQL
10 votes211 views2 answers
Django mysql
SQL
3 votes262 views2 answers
Create schema postgres
SQL