нужен Sql запрос
10 replies115 viewsCurrently viewing: 1
· 10/05/2009, 03:00 PM
Нужен запрос чтобы уменьшить цены в магазинах например в три раза, есть такой? ![]()
0
· 10/05/2009, 03:04 PM
update etcitem set price=1 where price > 1;
update weapon set price=1 where price > 1;
update armor set price=1 where price > 1;
А вопще http://la2base.ru/forum/index.php?showtopic=14453
Спасибку тыкни )
0
· 10/05/2009, 03:14 PM
wetlook: update etcitem set price=1 where price > 1;
update weapon set price=1 where price > 1;
update armor set price=1 where price > 1;
А вопще http://la2base.ru/forum/index.php?showtopic=14453
Спасибку тыкни )
Этот запрос я уже видел, но это не то что мне нужно.
0
· 10/05/2009, 03:15 PM
Код
UPDATE `etcitem` SET `price` / 3 WHERE `price` > 1;
UPDATE `weapon` SET `price` / 3 WHERE `price` > 1;
UPDATE `armor` SET `price` / 3 WHERE `price` > 1;
UPDATE `weapon` SET `price` / 3 WHERE `price` > 1;
UPDATE `armor` SET `price` / 3 WHERE `price` > 1;
You can't feeling! No you can't feeling! And you can't feeling!
— People = Shit
0
· 10/05/2009, 03:23 PM
Цитата
[Err] 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 '/ 3 WHERE `price` > 1' at line 1
[Err] UPDATE `etcitem` SET `price` / 3 WHERE `price` > 1;
[Msg] Finished - Unsuccessfully
[Err] UPDATE `etcitem` SET `price` / 3 WHERE `price` > 1;
[Msg] Finished - Unsuccessfully
0
· 10/05/2009, 03:39 PM
Код
UPDATE `etcitem` SET `price` = `price` / 3 WHERE `price` > 1;
UPDATE `weapon` SET `price` = `price` / 3 WHERE `price` > 1;
UPDATE `armor` SET `price` = `price` / 3 WHERE `price` > 1;
UPDATE `weapon` SET `price` = `price` / 3 WHERE `price` > 1;
UPDATE `armor` SET `price` = `price` / 3 WHERE `price` > 1;
sorry)
You can't feeling! No you can't feeling! And you can't feeling!
— People = Shit
0
Войдите или зарегистрируйтесь чтобы ответить




