MySQL Forums
Forum List  »  MySQL for Excel

Re: Excel to MySQL
Posted by: richard briggs
Date: June 11, 2012 06:10PM

ok!

Tested with MySQL and so far so good!

Test 1 : Excel to MySQL table
===============================
I had a couple of problems:
1/ I had the wrong string terminator ` instead of '

2/ Transactions!
This is why I wanted to ask the MySQL experts .. the Excel to database utility uses transactions to test that the row data is valid, then rolls the transaction back.

I found however that the transaction would not roll back. After some digging I discovered MySQL tables must be created with a flag TYPE=InnoDB;

After correcting my test table, all went well.

3/ If data contains apostrophes(') then the utility fails the row database validation (row colour amber):


Please can you tell me the best way to handle this in MySQL Syntax?

Test 2 : Excel to MySQL Stored Procedure
===========================================
I will let you know how I get on with testing this .. I may need some help ..

Excel to MySQL

Thanks



Edited 1 time(s). Last edit at 06/15/2012 03:43PM by richard briggs.

Options: ReplyQuote


Subject
Views
Written By
Posted
3470
June 11, 2012 07:42AM
1282
June 11, 2012 07:50AM
Re: Excel to MySQL
1371
June 11, 2012 06:10PM
1399
June 12, 2012 01:35AM
1262
June 12, 2012 06:09AM
1323
June 13, 2012 02:02AM
1213
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.