1. Union count.

Question is, how to get count records in union query? For example, we have this query: select count(*) from jos_content union all select count(*) from jos_users As a result, we will have two records: count(*) 904  ...

Wednesday, 20 August 2008 | 294 hits | Print | PDF | Report | Read more

2. UTF8 export.

When I tried to export database with UTF8 characters in one big file, and then open it in the UltraEdit, I received strange characters like: ÄŤ Instead of letter: č Solution is to change the font, like it is describe it here,...

Tuesday, 24 August 2010 | 25 hits | Print | PDF | Report | Read more