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
CREATE TABLE Persons ( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) );
sql table
CREATE TABLE utilisateur ( id INT PRIMARY KEY NOT NULL, nom VARCHAR(100), prenom VARCHAR(100), email VARCHAR(255), date_naissance DATE, pays VARCHAR(255), ville VARCHAR(255), code_postal VARCHAR(5), nombre_achat INT )
Source: sql.sh
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);
create sql table
column_name data_type(length) [not null] [default value] [auto_increment] column_constraint; Code language: SQL (Structured Query Language) (sql)
Source: www.mariadbtutorial.com