Fehlerausgabe
Script
MySQL meldet:
#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 'div tinyint(1) NOT NULL default '0',
PRIMARY KEY (ID),
KEY ID (ID)
) TYP' at line 10
#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 'div tinyint(1) NOT NULL default '0',
PRIMARY KEY (ID),
KEY ID (ID)
) TYP' at line 10
Code:
# # Table structure for table `itemgrinfo` # CREATE TABLE itemgrinfo ( ID int(8) unsigned NOT NULL auto_increment, itemgrID int(8) NOT NULL default '1', langID int(8) NOT NULL default '1', name varchar(20) NOT NULL default '', div tinyint(1) NOT NULL default '0', PRIMARY KEY (ID), KEY ID (ID) ) TYPE=MyISAM; # # Dumping data for table `itemgrinfo` # INSERT INTO itemgrinfo VALUES (1, 1, 1, 'DSL und mehr ...', '0'); INSERT INTO itemgrinfo VALUES (2, 1, 2, 'DSL and more ...', '0'); INSERT INTO itemgrinfo VALUES (14, 2, 2, 'Email', '0'); INSERT INTO itemgrinfo VALUES (13, 2, 1, 'Email', '0'); INSERT INTO itemgrinfo VALUES (15, 3, 1, 'Laser', '0'); INSERT INTO itemgrinfo VALUES (16, 4, 1, 'Tintenstrahl', '0'); INSERT INTO itemgrinfo VALUES (17, 2, 3, 'Email', '0'); INSERT INTO itemgrinfo VALUES (18, 5, 1, 'Zubehör', '0'); INSERT INTO itemgrinfo VALUES (19, 5, 2, 'Accessories', '0'); INSERT INTO itemgrinfo VALUES (20, 5, 3, 'Accesorios', '0'); INSERT INTO itemgrinfo VALUES (21, 3, 2, 'Laser', '0'); INSERT INTO itemgrinfo VALUES (22, 3, 3, 'Laser', '0'); INSERT INTO itemgrinfo VALUES (23, 1, 4, 'DSL and more ...', '0'); INSERT INTO itemgrinfo VALUES (24, 6, 1, 'Gemüse', '0'); INSERT INTO itemgrinfo VALUES (33, 28, 1, 'Gummi', '0'); INSERT INTO itemgrinfo VALUES (233, 129, 1, 'Elektrogroßgeräte', '0'); INSERT INTO itemgrinfo VALUES (234, 130, 1, 'Fisch & Fleisch', '0'); INSERT INTO itemgrinfo VALUES (236, 132, 1, 'Komponente', '0');
Comment