phpBB.de

Code: Alles auswählen

INSERT INTO `pb1config` VALUES ('allow_medal_display', '0');
INSERT INTO `pb1config` VALUES ('medal_display_row', '1');
INSERT INTO `pb1config` VALUES ('medal_display_col', '1');
INSERT INTO `pb1config` VALUES ('medal_display_width', '');
INSERT INTO `pb1config` VALUES ('medal_display_height', '');
INSERT INTO `pb1config` VALUES ('medal_display_order', '');
INSERT INTO `pb1medal_cat` VALUES ('1', 'Default', '10');

Code: Alles auswählen

SQL-Befehl: 

INSERT INTO `pb1config` 
VALUES (

'allow_medal_display', '0'
);



MySQL meldet:  

#1062 - Duplicate entry 'allow_medal_display' for key 1 

Code: Alles auswählen

SQL-Befehl:  

SELECT * 
FROM 
WHERE CONCAT_WS( "-", 'allow_medal_display', '0' ) = "allow_medal_display"
ORDER BY 'allow_medal_display', '0' 

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 'WHERE CONCAT_WS("-", 'allow_medal_display',  '0')
                        = "al' at line 3