mySQL problem - Printable Version

mySQL problem - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mySQL problem (/showthread.php?tid=376484)

mySQL problem - Roel - 10.09.2012

Hello.
I'm working at pl/sql developer from Oracle.
I have to follow SQL/Program script:

Код:

DECLARE
  var_newnum NUMBER;
  var_oldnum NUMBER;
  var_valeu NUMBER := 10;
BEGIN
  SELECT bank
  INTO var_oldnum
  FROM USERS
  WHERE ID='81';
  
  var_newnum := var_oldnum - var_valeu;
  
  UPDATE USERS SET(bank=var_newnum) WHERE ID='81';

END;

Is it possible to convert this somehow to Mysql code for sa-mp.

Respect for the one who knows how.

Re: mySQL problem - Roel - 12.09.2012

bump