Type "CREATE TABLE" and the name of the table to create, followed by a comma-separated list of column names in parentheses. For example, type the following:CREATE TABLE employees ( name VARCHAR ...

CREATE TABLE editorial (id INT, name VARCHAR (20), email VARCHAR (20)); Note: INT stands for integer (numbers) and VARCHAR stands for variable characters (numbers and alphanumeric).

CREATE TABLE books ( bookid serial PRIMARY KEY, title varchar(100) NOT NULL, seriesid integer, authorid integer ); The above works for both MariaDB and PostgreSQL, but it doesn't work for SQLite3, ...