To be perfectly honest I believe you have completely confused the programming language you are using with the SQL statements you need to use to interact with the server. These are two separate languages and have their own separate syntaxes.
You can use almost any programming language and the programming-language-appropriate MySQL library to make a connection to a MySQL server and interact with it through SQL statements. The SQL you send to the server can be constructed using your programming language or can be partially compiled for you by using the library's "prepared statement" feature, if it has one. The exact syntax of the commands and data structures that you will use to send those SQL statements and receive the results of those statements will depend *ABSOLUTELY* on the library you are using to connect your programming language to the MySQL server. I think that if you take a step back and discover both what statements the MySQL SQL language supports AND what the library you are using to connect your language to the MySQL server can do, things will begin to make better sense. Respectfully, Shawn Green Database Administrator Unimin Corporation - Spruce Pine <[EMAIL PROTECTED]> wrote on 12/13/2004 04:36:07 AM: > > Hi, > > I am building the insert string for inserting into particular table t1 > using C program. The below string is stored in a variable. > > > say sqlstmt = 'INSERT INTo T1 values(:id,:ename);' > > The values for the field's id, name will come from the front end. The > sql string will be executed using Pro *C in Oracle. > > Can we get the MySQL Equivalent so that we can use the same in our C > program? Do we have bind variable or host variable concepts in MySQL? > > In MySQL tried with @, i.e set the values of id, ename as > @id = 10, @ename = 'Sample' after that used > > Insert into t1 values(@id,@ename). This worked > fine. Can we use the same "@" for the binding values in "C' Program for > mysql?. > > Thanks for help in advance. > > Regards, > > Narasimha > > > > > > > > > > > > Confidentiality Notice > > > The information contained in this electronic message and any > attachments to this message are intended > for the exclusive use of the addressee(s) and may contain > confidential or privileged information. If > you are not the intended recipient, please notify the sender at > Wipro or [EMAIL PROTECTED] immediately > and destroy all copies of this message and any attachments.