findnerd.com

How to delete duplicate rows in a table set MySql

Hello readers!. If you having the much of redundant/duplicate data growing in your database you can delete it with just a single query as I wrote here. Let say I have a table Address and want to ...
Ars Technica

Recursively delete items in a MySQL table - foreign key, or something else?

I'm working on a web app, and it part of it, there is a very simple database-driven file/document manager. As a file manager, there is the possibility of sub-folders. So in the DB, I have the ...
GitHub

Involves creation of triggers to a table and keeping track of the changes(insert/update/delete) by using a new table which is similar to the original one, but with some ...

Please do the following string replacements in the track_mysql_table_history.sql file before executing in the Mysql database: a. Replace the string 'MyDB' with the name of your database. b. Replace ...
GitHub

when do flashback table. The mysql.gc_delete_range table is not emptied.After gc the data will gone.

ddl: fix a bug that 'flashback table' does not handle mysql.gc_delete… … ...