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) );
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
sql create table
sdfksdmf