Increment a column in MySQL using the UPDATE queryhttps://joellipman.com/articles/database/mysql/increment-a-column-in-mysql-using-the-update-query.html

18 February 2010 have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1 WHERE...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Change Regional Settings for your Reporthttps://joellipman.com/articles/microsoft/ssrs/change-regional-settings-for-your-report.html

17 May 2010 (dd/MM/yyyy). You can override this in the report by: Go to Design Select the View tab Check that the "Properties" pane is displayed/ticked Change Language under Report Properties > Localization to en-GB Save the report and test.

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

MySQL Commands to display all columnshttps://joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 * FROM information_schema.COLUMNS ORDER BY TABLE_NAME, COLUMN_NAME The following is a MYSQL query that finds all columns (displayed as "tablename.columnname") that had the data_type TEXT across all databases: SELECT CONCAT(TABLE_NAME, '.', COLUMN_NAME)...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB