List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 24 1999 10:16pm
Subject:RE: Is there a SQLPrepare in MYSQL
View as plain text  
At 4:53 PM -0500 9/24/99, adhir@stripped wrote:
>Not an answer, but a datapoint:  this works great in perl using the DBI
>driver for Mysql...

That's because the DBD::mysql module does placeholder emulation, not
because the MySQL C API actually supports it.

Still, who cares as long as it works, eh? :-)

>
>> -----Original Message-----
>> From: mysql-return-14208-adhir=forumone.com@stripped
>> [mailto:mysql-return-14208-adhir=forumone.com@stripped]
>> On Behalf
>> Of Ramesh Theivendran
>> Sent: Friday, September 24, 1999 5:04 PM
>> To: mysql@stripped
>> Subject: Is there a SQLPrepare in MYSQL
>>
>>
>> Hello,
>> After reading the  C Api for MYSQL I could not see any reference to
>> preparing a SQL query and binding parameter at run time.
>> For example, in most databases I can do a Prepare on a SQL like INSERT
>> INTO TAB ( COL1,COL2)  VALUES (?,?) once and
>> then in a loop bind parameter and  execute. Looks like the only way in
>> MYSQL is to generate a diff. query evertime I need to execute
>> with diff.
>> data like INSERT INT TAB (COL1,COL2) VALUES ('data1','data2'). Please
>> correct me if iam wrong.
>>
>> T.Ramesh.

--
Paul DuBois, paul@stripped
Thread
Is there a SQLPrepare in MYSQLRamesh Theivendran25 Sep
RE: Is there a SQLPrepare in MYSQLadhir25 Sep
  • Re: Is there a SQLPrepare in MYSQLRamesh Theivendran25 Sep
  • RE: Is there a SQLPrepare in MYSQLPaul DuBois25 Sep