Statement based replication writes the queries that modify data in the Binary Log to replicate them on the slave or to use it as a PITR recovery. Here we will see what is the behavior of the MySQL when it needs to log “not usual” queries like Events, Functions, Stored Procedures, Local Variables, etc. We’ll [...] [...more]
First off, apologies to those who left comments on my past posts and your comments didn’t show up. Apparently, I didn’t have my blog settings setup correctly, and I just noticed (and approved) them. So for the past few weeks, Patrick Crews and myself have been trying to chase down a really nasty transaction log [...] [...more]
Use code to create an if-then statement in Excel VBA by using corresponding worksheet cells. Use an if-then statement in Excel VBA withtips from a software developer in this free video on using Microsoft Excel. Expert: Dave Andrews Contact: www.daveandrews.org Bio: Dave Andrews is a software developer that holds a degree in computer science. Currently, [...] [...more]
SItuation: Table containing many rows that each include a GameID and a Unix Timestamp (for when the game is played). What’s the most efficient way to select all rows after a certain date (I know how to do that part) that orders by the GameID’s that are most prevalant for that time period (not sure)? [...] [...more]
say, i have fname, mname and lname in my table employees.. then a user enters a query, and then i want to compare it to the aforesaid columns.. sample input: search by: name query: b [...more]
