I was trying to assist someone with the difference between backtics, apostrophes and quotation marks. The three are used in different circumstances and the the basic rules I use with ‘, ` and " are:- I only use ` in MySQL and only where the field or table name is a reserved word i.e. you [...]
Browsing Posts in SQL
I recently had to back up a MySQL database on a windows server so I could restore it to my local MySQL server for analysing the structure of an existing site which we are going to be rebuilding. I have done this hundreds of times on linux server but the usual command did not appear [...]
This has been updated to work with Symfony 1.3/1.4 – Please go to the updated article: Raw SQL from Doctrine Query Object – Revised As my use of Symfony is increasing I find myself frustrated that there doesn’t appear to be an easy way to get the raw SQL from a doctrine query object so [...]
For several months now I’ve been using eSense Visualizers for Microsoft Sharepoint to output the contents of a database in a meaningful and easy to understand view that is suitable for the client, although lately I’ve not been using it as much. Just this morning I’ve had to use it for a few hours again and [...]
