Doubt with regard to MySQL4.1
Posted by: sankara narayanan sivaraman
Date: August 07, 2005 10:33PM

Hi,
I have a client code that does some DB operations to MySQL server via MySQL C APIs.
The code works very fine with MySQL4.0
When i upgraded to MySQL4.1, there is some error message displayed when am trying to create a table or insert rows into it through APIs.

The SQL query still reads

create table tale( RECORD VARCHAR(30), custID VARCHAR(30), conID VARCHAR(30), ConName VARCHAR(30), Dur VARCHAR(30), ACT_TIME VARCHAR(30), ACTE_TIME VARCHAR(30), SES_DUR VARCHAR(30))

I get the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1.

If i try the same SQL query in command interface, it works just fine.
I dont know how to proceed with this.
Can anyone give me any pointers as how to proceed.

Options: ReplyQuote


Subject
Views
Written By
Posted
Doubt with regard to MySQL4.1
889
August 07, 2005 10:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.