Hi,
With MySQL you can use variables which are represented using "@" character.
You can not use this variable like in Oracle or DB2 because ,for the moment,
MySQL didn't have necessary "tools" which can handle like "bind", this
variables.
I guess you can make some "improvisations" to suit at your needs.
For example :
If you wish to store an entire row(...or selective items from one row) in
the
one variable and after this to insert in other table:
@a:=''; /* initialise the variable a*/
select @a:=CONCAT(FIRST_ITEM,',',SECOND_ITEM,',',THIRD_ITEM...etc) from
YOUR_TABLES where SOME_CONDITIONS.
insert into other_table
values(MID(@,POSITION_OF1-st_ITEM,LENGTH),MID(@,POSITION_2-nd,LENGTH)....etc
)
Also, this can be replaced very well,if you use INSERT...SELECT statement.
Another example which can help you to avoid bind array variable and also to
avoid FOREACH() function is:
insert into YOUR_TABLES SET
YOUR_1-st_FIELD=1-st_ITEM,YOUR_2-nd_FIELD=2-nd_ITEM...etc select
IF(1-st_ITEM SOME_FILTERING_CONDITIONS,RETURN_IF_TRUE,RETURN_IF_FALSE)...etc
from OTHER_TABLE where CONSTRAINT_CONDITION...
I hope it help,
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Alvaro Avello" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 24, 2003 1:54 PM
Subject: [Fwd: Bind Variables.]
> Hi everybody:
>
> I 'm actually having an problem trying to mygrate to mysql. it's true
> that mysql does not support bind variables ? . Actually the development
> in my company is over Centura team developer connected to Centura
> Sqlbase , and the code of the aplications is widely using bind variables
> . there is a workaround for this ? there is a posibility that in the
> future releases of mysql bind variables will be supported ?' thanks in
> advance.
>
> Alvaro.
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
