MySQL Forums
Forum List  »  MySQL for Excel

Re: Excel to MySQL
Posted by: laptop alias
Date: June 12, 2012 01:35AM

>After some digging I discovered MySQL tables must be created with a flag TYPE=InnoDB;

What version are you using? 'TYPE' is (supposed to be) deprecated by now. Use 'ENGINE=InnoDB' instead.

Note that BDB and InnoDB both support transactions. MyISAM does not.

You will need to 'escape' apostrophes. The following methods are available. The first is the most common...

'Briggs\'s'
'Brigg''s'
"Briggs's"

Options: ReplyQuote


Subject
Views
Written By
Posted
3532
June 11, 2012 07:42AM
1306
June 11, 2012 07:50AM
1396
June 11, 2012 06:10PM
Re: Excel to MySQL
1423
June 12, 2012 01:35AM
1290
June 12, 2012 06:09AM
1343
June 13, 2012 02:02AM
1257
October 11, 2012 03:36AM


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.