JCDenton
17.03.2007, 11:31
Нужна помощь.
Кто хорошо разбирается в MYSQL?
Был сделан запрос:
INSERT INTO `fusion_admin` VALUES (35, 'S3', 'settings_forum.gif', 'Attachment Admin', 'attachments_forum.php', 3);
CREATE TABLE `fusion_attachment_settings` (
`allow_multi` tinyint(1) unsigned NOT NULL default '0',
`files_num` int(2) unsigned NOT NULL default '3'
) TYPE=MyISAM;
INSERT INTO `fusion_attachment_settings` VALUES (1, 5);
Получен ответ:
#1062 - Duplicate entry '35' for key 1
Расширенно:
SELECT *
FROM
WHERE CONCAT_WS( "-", 35, 'S3', 'settings_forum.gif', 'Attachment Admin', 'attachments_forum.php', 3 ) = "35"
ORDER BY 35 , 'S3', 'settings_forum.gif', 'Attachment Admin', 'attachments_forum.php', 3
MySQL said:
#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("-", 35, 'S3', 'settings_forum.gif',
'Attachment Admin', 'at' at line 3
Если можно - поподробнее обо всей этой бадяге...
Кто хорошо разбирается в MYSQL?
Был сделан запрос:
INSERT INTO `fusion_admin` VALUES (35, 'S3', 'settings_forum.gif', 'Attachment Admin', 'attachments_forum.php', 3);
CREATE TABLE `fusion_attachment_settings` (
`allow_multi` tinyint(1) unsigned NOT NULL default '0',
`files_num` int(2) unsigned NOT NULL default '3'
) TYPE=MyISAM;
INSERT INTO `fusion_attachment_settings` VALUES (1, 5);
Получен ответ:
#1062 - Duplicate entry '35' for key 1
Расширенно:
SELECT *
FROM
WHERE CONCAT_WS( "-", 35, 'S3', 'settings_forum.gif', 'Attachment Admin', 'attachments_forum.php', 3 ) = "35"
ORDER BY 35 , 'S3', 'settings_forum.gif', 'Attachment Admin', 'attachments_forum.php', 3
MySQL said:
#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("-", 35, 'S3', 'settings_forum.gif',
'Attachment Admin', 'at' at line 3
Если можно - поподробнее обо всей этой бадяге...