shawnmos Posted March 17, 2003 Share Posted March 17, 2003 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? Link to comment https://forums.phpfreaks.com/topic/231-mysql-database/ Share on other sites More sharing options...
effigy Posted March 17, 2003 Share Posted March 17, 2003 where do you want the quote added? e.g. -- has the access file been saved as a delimited ascii file to import? Link to comment https://forums.phpfreaks.com/topic/231-mysql-database/#findComment-688 Share on other sites More sharing options...
shawnmos Posted March 17, 2003 Author Share Posted March 17, 2003 it is already running live on my host\'s server. I didn\'t notice this problem until now. Link to comment https://forums.phpfreaks.com/topic/231-mysql-database/#findComment-689 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.