Variable Assignment

Dear List -

I cannot figure this one out:

mysql> $st=1000;
ERROR 1064 (42000): 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 '$st=1000' at line 1

Ethan

MySQL 5.1 PHP 5 Linux [Debian (sid)]



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Variable Assignment

mysql> SET @st=3D100;
mysql> SELECT @st;
+------+
| @st |
+------+
| 100 |
+------+

Cheers.

On 28 October 2010 19:10, Ethan Rosenberg wrote:
> Dear List -
>
> I cannot figure this one out:
>
> mysql> $st=3D1000;
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manua=
l
> that corresponds to your MySQL server version for the right syntax to use
> near '$st=3D1000' at line 1
>
> Ethan
>
> MySQL 5.1  PHP 5  Linux [Debian (sid)]
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>



--=20
Andrés G. Montañez
Zend Certified Engineer
Montevideo - Uruguay

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Variable Assignment

At 05:13 PM 10/28/2010, Andrés G. Montañez wrote:
>mysql> SET @st=3D100;
>mysql> SELECT @st;
>+------+
>| @st |
>+------+
>| 100 |
>+------+
>
>Cheers.
>
>On 28 October 2010 19:10, Ethan Rosenberg wrote:
> > Dear List -
> >
> > I cannot figure this one out:
> >
> > mysql> $st=3D1000;
> > ERROR 1064 (42000): 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 '$st=3D1000' at line 1
> >
> > Ethan
> >
> > MySQL 5.1 =C2 PHP 5 =C2 Linux [Debian (sid)]
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
>
>--
>Andrés G. Montañez
>Zend Certified Engineer
>Montevideo - Uruguay

Andres -

Thanks.

It works!

However, I am totally confused. All the texts=20
state that to set a variable, the code is: $st=3D100;

What are they missing and what am I missing?

Ethan

MySQL 5.1 PHP 5 Linux [Debian (sid)]=20



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Variable Assignment

> However, I am totally confused. All the texts state that to set a
> variable, the code is: $st=100;

That's how you do it in php.

Doing it in the db is different and depends on the db you are using.

--
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php