MySQL / SQL Server
MySQL / SQL Server
Wednesday, 17 March 2010 17:39
Search and Replace in a MySQL Database
Ok is it just me who does everything slowly and badly until someone comes along and says why are you doing it like that? My justification is that the job has to be done no matter what.
If you've ever sat there with phpMyAdmin or a MySQL Administration Tool (like…
Last modified on Tuesday, 30 November 1999 00:00
Thursday, 18 February 2010 15:32
Increment a column in MySQL using the UPDATE query
Suppose you 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 column1='this_article'
Add 1 to counter_field_value…
Last modified on Tuesday, 02 March 2010 15:24
