CREATETABLE table_name(
id INTAUTO_INCREMENTPRIMARYKEY,
name VARCHAR(255),# String 255 chars maxdateDATETIMENOTNULLDEFAULTCURRENT_TIMESTAMP,longtextBLOB);
//to create a tableCREATETABLE students
( student_id number(4)primarykey,
last_name varchar2(30)NOTNULL,
course_id number(4)NULL);//to insert valueINSERTINTO students VALUES(200,'Jones',101);INSERTINTO students VALUES(201,'Smith',101);INSERTINTO students VALUE(202,'Lee',102);
//to create a tableCREATETABLE students
( student_id number(4)primarykey,
last_name varchar2(30)NOTNULL,
course_id number(4)NULL);//to insert valueINSERTINTO students VALUES(200,'Jones',101);INSERTINTO students VALUES(201,'Smith',101);INSERTINTO students VALUE(202,'Lee',102);
#create a table and name itCREATETABLE test_name(#create some vars in the table like id, name, age and etc.
id INTNOTNULL,
name VARCHAR,
age FLOATNOTNULLPRIMARYKEY(id)#define the primary key of the table(primary key is a var that will never be the same in each column in the table it will be "unique" rise up for each column);
Creates a new table.
Example: Creates a new table called ‘users’ in the ‘websitesetup’ database.CREATETABLE users (
id int,
first_name varchar(255),
surname varchar(255),
address varchar(255),
contact_number int);
#create a tableCREATETABLE employees( id INTNOTNULLAUTO_INCREMENT,
first_name VARCHAR(30)NOTNULL,
last_name VARCHAR(30)NOTNULL,
middle_name VARCHAR(30),
age INTEGERNOTNULL,
current_status VARCHAR(100)NOTNULLDEFAULT'employed',PRIMARYKEY(id));#fill the table with dataINSERTINTO employees (first_name, last_name, middle_name, age, current_status)VALUES('testname','testlastname','testmiddlename',23,'Searching');#view all the data inside the tableSELECT*FROM employees;