Dns-lab.com

The problem of how to handle trees in SQL has been talked about alot. The basic 3 ways are: store the full path for each entry store the parent for each node use nested tree Nested tree is good for read-many-write-less applications where the tree...

Mysql Database Event and Procedure(2)Store Procedure F.Y.I mysqldump command >mysqldump -h localhost -u root -P 7778 -ppassword databasename table name --where "click_time >= '2016-12-01'" > affiliate_clicks_2016_12_01.sql Import Command...

One great thing about having our free Code Writer Windows 8 text/code editing app out is that we now get a lot of feedback directly from end users of the SyntaxEditor control.  Normally we only receive feedback from our own customers, who are developers...

In the previous part of this tutorial series, we populated the dashboard page of our application with the wishes created by different users. We also attached a like button to each wish so that a user could like a particular wish. In this part of the...

In a previous post I showed how to implement multi-source round-robin replication in pure SQL using the tables that are needed for crash-safe replication. I also outlined a revised version of this approach in the Replication Tips & Tricks presentation...