Dear all,
I googled a lot and find data of all countries , cities , location
etc from Geo Spatial websites but I am able to find the data that shows
all *states their respective capitals* in world.
Please let me know if anyone as prior information about this ?
Thanks
Hiya
I got a request from a client for the rights to kill his queries if something
goes wrong. Long story short, he doesn't want to have to phone.
I see via the MySQL documentation, that the client would need PROCESS and SUPER
privileges. Im not happy with that.
Would know of an alternative
I got a request from a client for the rights to kill his queries if
something goes wrong. Long story short, he doesn't want to have to phone.
I see via the MySQL documentation, that the client would need PROCESS and
SUPER privileges. Im not happy with that.
Would know of an alternative
Here's a simple query:
select name,status,min(dt), max(dt),count(*)
from mytable
group by name
I need an efficient way to get this data, along with the status of the row with
the max(dt). 'status' is not in the group by, so I get apparently random
statuses. Is there any way to do this
Hi,
I have a query where I'm using a left outer join to connect two tables,
entries and entries_tags, where entries_tags is a join table between entries
and another table, tags. In my query I am selecting values from the entries
table where the entries have any of the provided tags - WHERE
Just to clarify, here is some more info:
Here is what the query looks like:
SELECT DISTINCT `entries`.id FROM `entries` LEFT OUTER JOIN `entries_tags`
ON `entries_tags`.entry_id = `entries`.id LEFT OUTER JOIN `tags` ON
`tags`.id = `entries_tags`.tag_id WHERE (`entries_tags`.tag_id IN (5,6));
So
2011/09/27 05:32 -0700, supr_star
Here's a simple query: select name,status,min(dt), max(dt),count(*) from
mytable group by name I need an efficient way to get this data, along with the
status of the row with the max(dt). 'status' is not in the group by, so I get
apparently random statuses.
This Link gives the capitals of all countries but I need the states and
their capitals in all these countries too..
But I think this is not possible because very few countries are divided
into states and some into cantons, county etc.
Thanks
planas wrote:
On Tue, 2011-09-27 at 12:18 +0530,
Hello List,
so far I could not find any answer on how to abort queries that exceed
certain size of internal temporary tables.
On certain quite often scenarios these internal tables are being
converted to Myisam on disk tables. And that creates a high IO
depending on situation.
Putting tmpdir in
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
This Link gives the capitals of all countries but I need the states
and their capitals in all these countries too..
But I think this is not possible because very few countries are
divided into states and some into
- Original Message -
From: Alexandr Normuradov norma...@gmail.com
so far I could not find any answer on how to abort queries that
exceed certain size of internal temporary tables.
I'm not sure there is.
On certain quite often scenarios these internal tables are being
converted to
11 matches
Mail list logo
