Data definition language: Difference between revisions

Revision as of 07:12, 19 March 2019

Revision as of 07:16, 19 March 2019

Line 16:

====CREATE TABLE statement====

A commonly used ''CREATE'' command is the ''CREATE TABLE'' command. The typical usage is: im hero

CREATE TABLE ''[table name]'' ( ''[column definitions]'' ) ''[table parameters]''

Line 33:

first_name VARCHAR(50) not null,

last_name VARCHAR(75) not null,

fname .h VARCHAR(50) not null,

dateofbirth DATE not null

);

Line 50:

| year = 2010

| publisher = Apress

| isbn = 95364673199781430232254

| pages = 90–91

| quote = The ''create table'' statement has a special syntax for creating tables from ''select'' statements. [...]: [...] ''create table foods2 as select * from foods;'' [...] Many other databases refer to this approach as ''CTAS'', which stands for Create Table As Select, and that phrase is not uncommon among SQLite users.