| |
|
|
| | Таблица:
CREATE TABLE `users_ds` (
`id_ds` int(11) NOT NULL auto_increment,
`id_hlf` int(11) default NULL,
`showhide` enum('show','hide') NOT NULL default 'hide',
`pos` int(11) NOT NULL,
`lock` enum('lock','unlock') NOT NULL default 'unlock',
`code_lock` int(11) NOT NULL,
`rights` enum('founder','ds') NOT NULL default 'ds',
`service` enum('free','commercial') default 'commercial',
`pays` enum('y','n') NOT NULL default 'n',
`partners` enum('y','n') NOT NULL default 'n',
`actuated` enum('y','n') NOT NULL default 'n',
`foto` tinytext NOT NULL,
`id_user` int(11) default NULL,
PRIMARY KEY (`id_ds`)
)
|
Запрос:
REPLACE users_ds
SET id_ds = '37',
id_hlf = '38921607',
showhide = 'show',
lock = 'lock',
rights = 'ds',
service = 'commercial',
pays = 'y',
partners = 'y',
actuated = 'y',
id_user = '309',
code_lock = '2'
|
Если убираю одно значение, то все работает. Т.е. такой запрос проходит:
REPLACE users_ds
SET id_ds = '37',
id_hlf = '38921607',
showhide = 'show',
rights = 'ds',
service = 'commercial',
pays = 'y',
partners = 'y',
actuated = 'y',
id_user = '309',
code_lock = '2'
|
| |
| |
|
|
| |
|
|
| |
для: tAleks
(06.10.2006 в 19:50)
| | | lock - ключевое слово, если им назван столбцец, его следует заключать в обратные кавычки
REPLACE users_ds
SET id_ds = '37',
id_hlf = '38921607',
showhide = 'show',
`lock` = 'lock',
rights = 'ds',
service = 'commercial',
pays = 'y',
partners = 'y',
actuated = 'y',
id_user = '309',
code_lock = '2'
|
| |
| |
|
|
|
