Topic: msyql

Sveiki,

Gal kas galit pasakyt kaip per db kada paspaudi ant table "sql" nuimt visiem uzeriam tarkim balansa pinigus? moku nuimt visiem iskart balansa bet man reikia nuimt tik tiem nick pas ka tarkim yra 20 LT balanse. o pas ka maziau liktu kiek yra. nuimtu tik pas ka 20LT ir padarytu 0 dekui.

kaip nuimt visiem tai taip veikia:

update server_users set balansas='0'

bandziau taip bet neveikia :D

update server_users where balansas='20' set balansas='0'  bet neveikia :D


Deprecated: Function create_function() is deprecated in /home/pasokime/domains/mysql.lt/public_html/forumas/include/parser.php on line 756

Deprecated: Function create_function() is deprecated in /home/pasokime/domains/mysql.lt/public_html/forumas/include/parser.php on line 811

Deprecated: Function create_function() is deprecated in /home/pasokime/domains/mysql.lt/public_html/forumas/include/parser.php on line 811

Deprecated: Function create_function() is deprecated in /home/pasokime/domains/mysql.lt/public_html/forumas/include/parser.php on line 811

Deprecated: Function create_function() is deprecated in /home/pasokime/domains/mysql.lt/public_html/forumas/include/parser.php on line 811

Deprecated: Function create_function() is deprecated in /home/pasokime/domains/mysql.lt/public_html/forumas/include/parser.php on line 811

Deprecated: Function create_function() is deprecated in /home/pasokime/domains/mysql.lt/public_html/forumas/include/parser.php on line 811

Deprecated: Function create_function() is deprecated in /home/pasokime/domains/mysql.lt/public_html/forumas/include/parser.php on line 811

Deprecated: Function create_function() is deprecated in /home/pasokime/domains/mysql.lt/public_html/forumas/include/parser.php on line 811

Deprecated: Function create_function() is deprecated in /home/pasokime/domains/mysql.lt/public_html/forumas/include/parser.php on line 811

Deprecated: Function create_function() is deprecated in /home/pasokime/domains/mysql.lt/public_html/forumas/include/parser.php on line 816

Re: msyql

toms wrote:

update server_users where balansas='20' set balansas='0'  bet neveikia :D

UPDATE `server_users` SET balansas='0' WHERE balansas='20'

Re: msyql

Dekui veikia.