MySQL Forums
Forum List  »  MySQL for Excel

Re: Insert column in existing Mysql database
Posted by: Javier Treviño
Date: July 17, 2015 09:50PM

Hi John,
Thanks for writing in our forums.

You can try using the Edit Data feature in MySQL for Excel to insert those values into the existing column of your table. If you are not in a multi-user environment or if it is multi-user but most likely the table will not be updated by another user while you insert that data; you should turn off the optimistic updates option of the Edit Data session.

You can see more information about it here:
https://blogs.oracle.com/MySqlOnWindows/entry/optimistic_updates_for_edit_data

Regards.

====================================
Javier Treviño
MySQL on Windows Team

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Insert column in existing Mysql database
1178
July 17, 2015 09:50PM


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.