set global foobar = expression does not work

set global foobar = expression does not work

This is a discussion on set global foobar = expression does not work within the MySQL forums, part of the Database Server Software category; --> Why doesn't a construction like this work ? set global foobar = CONCAT( 'lalala ', 'qqq' ); ERROR 1231 ...

		Unix Technical Forum > Database Server Software > MySQL
set global foobar = expression does not work

#1 (permalink)

02-28-2008, 09:36 AM

MasterZiv

Posts: n/a

set global foobar = expression does not work

Why doesn't a construction like this work ?

set global foobar = CONCAT( 'lalala ', 'qqq' );
ERROR 1231 (42000): Variable 'foobar' can't be set to the value of
'(null)'

How can I do something similar in a stored procedure ?
How can I programmatically form a new value of global variable and set
it ?

Thank you.

« more indexes needed when normalizing tables | FoxPro vs. SQL »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 04:14 PM.