Eksempler

Create Table tblUpload (
Upload_ID INT NOT NULL AUTO_INCREMENT,
Thread_ID INT NOT NULL,
File_name MEDIUMTEXT NOT NULL,
PRIMARY KEY (Upload_ID),
KEY(Thread_ID)) TYPE=MyISAM


ALTER TABLE tblThread
MODIFY Thread_ID Int NOT NULL

ALTER TABLE tblThread
ADD PRIMARY KEY (Thread_ID)

ALTER TABLE tblThread
Add KEY (Author_Id, Message_date, Topic_ID)

ALTER TABLE tblThread CHANGE Thread_ID Thread_ID INT AUTO_INCREMENT

ALTER TABLE `TestTabel` ADD `Postnr` INT DEFAULT '0' NOT NULL ,
ADD `Distrikt` VARCHAR( 30 ) NOT NULL

ALTER TABLE `TestTabel` CHANGE `Distrikt` `Distrikt` VARCHAR( 30 ) CHARACTER SET latin1 COLLATE latin1_danish_ci NOT NULL DEFAULT 'Kastrup'

ALTER TABLE `TestTabel` CHANGE `Postnr` `Postnr` INT( 11 ) NOT NULL DEFAULT '2770'

ALTER TABLE `TestTabel` ADD `ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST

ALTER TABLE `tblTest` CHANGE `Felt3` `Felt3` DATETIME NOT NULL DEFAULT 'NOW'

Type Value Type Description
FIELD_TYPE_TINY TINYINT field
FIELD_TYPE_SHORT SMALLINT field
FIELD_TYPE_LONG INTEGER field
FIELD_TYPE_INT24 MEDIUMINT field
FIELD_TYPE_LONGLONG BIGINT field
FIELD_TYPE_DECIMAL DECIMAL or NUMERIC field
FIELD_TYPE_FLOAT FLOAT field
FIELD_TYPE_DOUBLE DOUBLE or REAL field
FIELD_TYPE_TIMESTAMP TIMESTAMP field
FIELD_TYPE_DATE DATE field
FIELD_TYPE_TIME TIME field
FIELD_TYPE_DATETIME DATETIME field
FIELD_TYPE_YEAR YEAR field
FIELD_TYPE_STRING CHAR field
FIELD_TYPE_VAR_STRING VARCHAR field
FIELD_TYPE_BLOB BLOB or TEXT field (use max_length to determine the maximum length)
FIELD_TYPE_SET SET field
FIELD_TYPE_ENUM ENUM field
FIELD_TYPE_NULL NULL-type field
FIELD_TYPE_CHAR Deprecated; use FIELD_TYPE_TINY instead