Операция с числами в sql

[BDSG]

если поле uid выставлено как primary или unique, тогда так:

INSERT INTO `pre_common_member_verify`
(`uid`, `verify1`, `verify2`, `verify3`, `verify4`, `verify5`, `verify6`, `verify7`)
VALUES ($uid, 0, 0, 0, 0, 0, 1, 0)
ON DUPLICATE KEY UPDATE SET verify6='1'

 

[SocMaster]

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 'SET verify6='1''

 

[SocMaster]

если что

CREATE TABLE IF NOT EXISTS `pre_common_member_verify` (
`uid` mediumint(8) unsigned NOT NULL,
`verify1` tinyint(1) NOT NULL DEFAULT '0',
`verify2` tinyint(1) NOT NULL DEFAULT '0',
`verify3` tinyint(1) NOT NULL DEFAULT '0',
`verify4` tinyint(1) NOT NULL DEFAULT '0',
`verify5` tinyint(1) NOT NULL DEFAULT '0',
`verify6` tinyint(1) NOT NULL DEFAULT '0',
`verify7` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`uid`),
KEY `verify1` (`verify1`),
KEY `verify2` (`verify2`),
KEY `verify3` (`verify3`),
KEY `verify4` (`verify4`),
KEY `verify5` (`verify5`),
KEY `verify6` (`verify6`),
KEY `verify7` (`verify7`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

 

[esche]

SET не нужен.

 

[BDSG]

да.. SET лишний.. виноват, погорячился.. ))

 

[SocMaster]

Спасибо ребятки за помощь!
Тему офф