- Details
- Written by: Stanko Milosev
- Category: MySQL
- Hits: 2109
SELECT id, Longitude, Latitude, ( 3959 * acos( cos( RADIANS(50) ) * cos( radians( Latitude ) ) * cos( radians( Longitude ) - radians(7) ) + sin( RADIANS(50) ) * sin( radians( Latitude ) ) ) ) AS distance FROM gpslocation HAVING distance < 25 ORDER BY DISTANCE LIMIT 0 , 20;Notice that number 50 is twice mentioned in query.
- Details
- Written by: Stanko Milosev
- Category: MySQL
- Hits: 7754
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
- Written by: Stanko Milosev
- Category: MySQL
- Hits: 6236
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
- Written by: Stanko Milosev
- Category: HeidiSQL
- Hits: 5760
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.