Details
Category: MySQL
Hits: 3309

If you can't connect to MySQL over PHP from your localhost, then try something like:


In the Windows/System32/drivers/etc/hosts file remove the entry like this: 
::1             localhost 


and make sure you still have: 
127.0.0.1       localhost


Taken from here.

Details
Category: MySQL
Hits: 3895

Question is, how to get count records in union query?

For example, we have this query:

select count(*) from hdxbh_content
union all
select count(*) from jos_users

As a result, we will have two records:

 

count(*)
904 
1 


And we want to get result as one record, 905, how?

Like this:

select ((select count(*) from hdxbh_content) + (select count(*) from jos_users)) count

Taken from here.

Details
Category: HeidiSQL
Hits: 3463

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, and then open it with UltraEdit but where you will choose:

Format: 1250
Open as: UTF-8

Same is when you are opening the file from HeidiSQL.

Subcategories

MySQL

HeidiSQL