[KLUG Members] Setting user variables in MYSQL

Patrick McGovern members@kalamazoolinux.org
Thu, 09 May 2002 11:01:43 -0400 

--=_7D20967C.DDBCFF0A
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

How do you set user variables in MYSQL? =20
Here is a basic example that I thought would work:

SET @variable_name=3D0
select @variable_name:=3D(@variable_name + 1) as var
from table_name;

--=_7D20967C.DDBCFF0A
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type=
>
<META content=3D"MSHTML 5.00.3314.2100" name=3DGENERATOR></HEAD>
<BODY style=3D"FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px; MARGIN-TOP: =
2px">
<DIV><FONT size=3D1>How do you set user variables in MYSQL?&nbsp; =
</FONT></DIV>
<DIV><FONT size=3D1>Here is a basic example that I thought would=20
work:</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT size=3D1>SET @variable_name=3D0</FONT></DIV>
<DIV><FONT size=3D1>select @variable_name:=3D(@variable_name + 1) as=20
var</FONT></DIV>
<DIV><FONT size=3D1>from table_name;</FONT></DIV></BODY></HTML>

--=_7D20967C.DDBCFF0A--