17. januar 2013 - 10:50
Der er
6 kommentarer
jeg mangler hjælp til at kunne oprette denne her i phpmyadmin den siger der er fejl jeg kan ikke finde fejlen i den
CREATE TABLE 'fusion5G5B8_wow_panel'( 'id'INT UNSIGNED NOT NULL AUTO_INCREMENT , 'druid'TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0', 'hunter'TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0', 'mage'TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0', 'priest'TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0', 'rogue'TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0', 'shaman'TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0', 'warlock'TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0', 'warrior'TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0', 'paladin'TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0', 'deathnight'TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0', 'address'VARCHAR( 100 ) DEFAULT NULL , 'color'VARCHAR( 100 ) DEFAULT NULL , 'colora'VARCHAR( 100 ) DEFAULT NULL , 'coloro'VARCHAR( 100 ) DEFAULT NULL , 'oname'VARCHAR( 100 ) DEFAULT NULL , 'cname'VARCHAR( 100 ) DEFAULT NULL , 'app'VARCHAR( 100 ) DEFAULT NULL , 'rt'VARCHAR( 100 ) DEFAULT NULL , PRIMARY KEY ( id ) ) TYPE = MYISAM ; MySQL returnerede: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''fusion5G5B8_wow_panel' ( 'id' INT UNSIGNED NOT NULL AUTO_INCREMENT, 'druid' T' at line 1
Annonceindlæg fra Infor
17. januar 2013 - 10:53
#1
dine 'er skal vel være `er
17. januar 2013 - 10:54
#2
dem der omkranser feltnavnene
17. januar 2013 - 12:10
#3
sådant her CREATE TABLE `fusion5G5B8_wow_panel`( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT , `druid`TINYINT(1) UNSIGNED NOT NULL DEFAULT `0`, `hunter`TINYINT(1) UNSIGNED NOT NULL DEFAULT `0`, `mage`TINYINT(1) UNSIGNED NOT NULL DEFAULT `0`, `priest`TINYINT(1) UNSIGNED NOT NULL DEFAULT `0`, `rogue`TINYINT(1) UNSIGNED NOT NULL DEFAULT `0`, `shaman`TINYINT(1) UNSIGNED NOT NULL DEFAULT `0`, `warlock`TINYINT(1) UNSIGNED NOT NULL DEFAULT `0`, `warrior`TINYINT(1) UNSIGNED NOT NULL DEFAULT `0`, `paladin`TINYINT(1) UNSIGNED NOT NULL DEFAULT `0', `deathnight`TINYINT(1) UNSIGNED NOT NULL DEFAULT `0`, `address`VARCHAR(100) DEFAULT NULL , `color`VARCHAR(100) DEFAULT NULL , `colora`VARCHAR(100) DEFAULT NULL , `coloro`VARCHAR(100) DEFAULT NULL , `oname`VARCHAR(100) DEFAULT NULL , `cname`VARCHAR(100) DEFAULT NULL , `app`VARCHAR(100) DEFAULT NULL , `rt`VARCHAR(100) DEFAULT NULL , PRIMARY KEY (id) ) TYPE = MYISAM ; men den siger stadigvæk fejl hvis det var sådant koden skulle laves
17. januar 2013 - 12:11
#4
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`0`, `hunter`TINYINT(1) UNSIGNED NOT NULL DEFAULT `0`, `mage`TINYINT(1) UNSIG' at line 3 er fejlen
17. januar 2013 - 12:45
#5
Hvis du vil have stroffer omkring tal, så skal det ikke være `0`, med '0' - eller bare uden: 0 `...` sættes omkring feltnavne, tabelnavne, databasenavne etc
17. januar 2013 - 13:03
#6
tak for hjælpen :) hvordant giver jeg point
Computerworld tilbyder specialiserede kurser i database-management