[SOLVED] MySQL user-defined variables

[mrherman]

Trying to understand user-defined variables in MySQL.

 

@pull_date = "20081003"
UPDATE t1 
   SET pull_date = @pull_date ;

 

Problem: NULLs are posted to the table.  What am I doing wrong?

 

Thanks!

[Barand]

mysql_query ("SELECT @pull_date := '20081003' ");
mysql_query ("UPDATE t1 SET pull_date = @pull_date ");