MySQL Forums
Forum List  »  MySQL for Excel

Advanced Search
New Topic

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.

Thanks

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Truncate Table to import new Data to SQL
1462
Samantha Winslow
May 25, 2016 12:33PM
Re: Truncate Table to import new Data to SQL
1021
Javier Treviño
May 27, 2016 01:50PM
Re: Truncate Table to import new Data to SQL
3026
Samantha Winslow
May 28, 2016 08:45AM
Re: Truncate Table to import new Data to SQL
1143
Javier Treviño
June 06, 2016 12:14PM


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.