Sunday, March 20, 2016

This Week

1. QUOTE OF THE WEEK
Q: I am trying to remove duplicate rows from a database containing 4446 tables and when finished, merge data from that database to an existing database with the same structure. Is there an easy way to remove duplicate rows from all those 4446 tables?

A1: Please tell us "what is a 4446 table?" And, please give examples of duplicate records.

A2: Recreate your database with unique primary keys. 2) Copy records from original database to recreated database, one table at a time. The duplicate records will drop on the floor. 3) Fix the thousands of bugs in your application code that created the duplicate rows in the first place.

A3: I'm creating temporary tables + I add unique index to that table and insert data into and then I rename it to the original one.

--stackoverflow.com


2. TO LAUGH OR CRY?


3. ONLINE DEBUNKINGS



5. INTERESTING ELSEWHERE

6. HOUSEKEEPING 

  • Added Join, join, join you said to LINKS page
  • Added forthcoming revisions of the PRACTICAL DATABASE FOUNDATIONS papers that will incorporate elements of the elements of McGoveran interpretation of the RDM to the WRITINGS page.
 

7. AND NOW FOR SOMETHING COMPLETELY DIFFERENT

 "The PostWest" (or The future of the West is all behind it)

The source of morality (the pope should shut the fuck up and dismantle his criminal organization)

Book of the week (order via the link to support this site)
Nuzzi, G., RATZINGER WAS AFRAID: The secret documents, the money and the scandals that overwhelmed the pope
Videos of the week

Do you like this post? Please link back to this article by copying one of the codes below.

URL: HTML link code: BB (forum) link code:

No comments:

Post a Comment