what is difference between empty and drop?

  • Resolved alexlii

    (@alexlii)


    7 years ago

    Hello,

    I need delete some data sheet of a plugin completely, so that I can reinstall it, would you please let me know the different between empty and drop?

    Thanks
    Alex

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Lester Chan

    (@gamerz)

    Empty runs the TRUNCATE table command https://dev.mysql.com/doc/refman/5.7/en/truncate-table.html aka clear the contents but the table is still there

    Drop runs the DROP table command https://dev.mysql.com/doc/refman/5.7/en/drop-table.html aka remove the table and contents.

    Thread Starter alexlii

    (@alexlii)

    Thanks so much.

    there are always change and ask for database update, but the latest version always so much stable, so we have to roll back to the previous version, so there will some issue happens by this way.

    If it is a fresh install without any important, should I delete all of the database sheet or tables related to that plugin and reinstall and activate it again?

    Your professional suggestion would be appreciated.

    Alex

    Plugin Author Lester Chan

    (@gamerz)

    I recommend dropping the table and let the plugin create again on activation.

    Thread Starter alexlii

    (@alexlii)

    oh, I got it. thanks a lot.

    Have a nice day.

    Alex

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘what is difference between empty and drop?’ is closed to new replies.