ODBC MySQL Data connection in Excel
After swatting up on connecting QlikView to a MySQL database, I used the knowledge gained to create a similar set-up,…
productivity through technology
After swatting up on connecting QlikView to a MySQL database, I used the knowledge gained to create a similar set-up,…
I got stuck writing a query for Firebird today. And here I was thinking that SQL was a standard — if…
I battled for ages to find the correct syntax to create a trigger in MySQL — the examples I could…
I love the fact that the best solutions are almost always the simplest! I spend a lot of time sanitising…
I am creating an Excel Report that queries a MySQL database using an ODBC connection. The data is the returned…
I have always stored IP addresses as strings in VARCHAR fields in MySQL. I am currently reading “High Performance MySQL”…
Got this question as part of a skills evaluation test. It requires a query to calculate summary-like data from tables…