Create
CREATE TABLE table_name (
column1 datatype constraint…,
column2 datatype constraint,
column3 datatype constraint,
….);
CREATE TABLE Users (
userID INT PRiMARY KEY,
name CHAR(32) NOT NULL,
email CHAR(32) NULL,
age FLOAT,
isMale BOOL
);
- currently supported datatypes are INT, FLOAT, BOOL, CHAR. Where size of CHAR column must be specified (ie. column CHAR(number) constraint…)
- same constraints for table/column name apply as above
- total row size for all columns added together may not exceed 4070 bytes in total
- CHAR field will error when trying to insert strings larger than specified but will allow strings lower in size
- current constraints are nullable or not nullable and primary key
- may only have one primary key and must be integer field