SQLDatabaseQueryHelp < Main

create table [table name] ([column 1 name] [data 1 type], [column 2 name] [data 2 type], ... ) [constraints];

...where the constraints can be...

Examples:

CREATE TABLE `main` ( `id` INT UNSIGNED NOT NULL auto_increment, `hash` CHAR(32), `info` VARCHAR(255), `data` LONGBLOB, PRIMARY KEY (`id`));

show columns from <table>

All rows: DELETE FROM some_table
Selected stuff: DELETE FROM some_table WHERE `some_column` = "some_value";

INSERT INTO [table name] ([column 1 name], [column 2 name], ...) VALUES ([column 1 value], [column 2 value], ...);

char(size) - Fixed-length character string. size is specified in parenthesis. Max 255 bytes.
varchar(size) - Variable-length character string. size specifies the maximum size
number(size) - Number value. size specifies max number of column digits
number(size,d) - Number value. size specifies max number of total column digits, d specifies number of decimal places
date - for date values

-- MattWalsh - 07 Aug 2002

Topic revision: r4 - 07 Nov 2006 - MattWalsh