Jump to content
Updating IPB tonight Read more... ×

Archived

This topic is now archived and is closed to further replies.

shawnmos

MySQL database

Recommended Posts

I converted a database created in Access to MySQL but I am having a problem. All of the data inside a field in a table is missing the ending quote and I am getting this message when trying to update the information....

 

ERROR: Unclosed quote @ 72

STR: \'

SQL:`arcmessages` WHERE `iMessageID` = \'7\' AND `txMessage` = \'darn...I wanted to be first...

Error

 

SQL-query :

 

 

`arcmessages` WHERE `iMessageID` = \'7\' AND `txMessage` = \'darn...I wanted to be first...

 

MySQL said:

 

 

You have an error in your SQL syntax near \'\'darn...I wanted to be first... \' at line 1

 

 

 

Is there anyway to go through and add the ending quote to all the rows in the field?

Share this post


Link to post
Share on other sites

where do you want the quote added? e.g. -- has the access file been saved as a delimited ascii file to import?

Share this post


Link to post
Share on other sites

it is already running live on my host\'s server. I didn\'t notice this problem until now.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.