Eksempler Create Table tblUpload (
ALTER TABLE tblThread ALTER TABLE tblThread ALTER TABLE tblThread CHANGE Thread_ID Thread_ID INT AUTO_INCREMENT ALTER TABLE `TestTabel` ADD `Postnr` INT DEFAULT '0' 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' |
|