MySQL Forums
Forum List  »  MySQL for Excel

Re: Truncate Table to import new Data to SQL
Posted by: Samantha Winslow
Date: May 28, 2016 08:45AM

I want the option to delete the data in the table when I append excel data to table.

I have tried the edit data function, but the only way to get more data in the table is to copy and paste that data in.

I would like to automate the process more.

I have looked through the forums and it seems as though you can add php code somewhere to tell your database to truncate prior to importing data, I just don't know where to add that code.


Options: ReplyQuote

Written By
Re: Truncate Table to import new Data to SQL
May 28, 2016 08:45AM

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.