This code will convert (pivot) your MySQL database table from rows to columns. Here is an example of what this code will do: Original Table ID Name Color 1 James…
Continue Reading
This code will convert (pivot) your MySQL database table from rows to columns. Here is an example of what this code will do: Original Table ID Name Color 1 James…
The code below will export every column name and value from your database into an excel document. Note: Delete the line spaces if you receive a parse error.
This is a very useful code for making edits on the fly, especially if you have extra spacing or quotes after importing values into your database. UPDATE tablename SET tablefield…
This code will send exactly two query’s to update a INT (0 or 1) checkbox field in a MySQL database. The IN operational statement let’s you match on a list…