On Fri, Feb 4, 2011 at 8:03 AM, Angela liu wrote:
> Is MySQL Administrator still available for MySQL 5.1 and 5.5?
>
I believe that line of applications has been superceded by the MySQL
Workbench.
If you must use MySQL administrator for some reason, they will undoubtedly
connect to 5.1 and 5.5,
2011/2/4 Yannis Haralambous
> SELECT * FROM wasfoundin WHERE yakoright LIKE '%geography%'
>
That won't use a regular index. Have a look at fulltext indexing.
For the phpmyadmin, I personally feel it's an abomination, not to mention a
disaster waiting to happen; but if you really want to keep us
Hi,
Anybody knows:
Is MySQL Administrator still available for MySQL 5.1 and 5.5?
That is exactly what I was worried about. He could try restructuring the data,
increasing the timeouts to compensate for the long run time, or find better
hardware. Any other ideas?
From: w...@pythian.com [mailto:w...@pythian.com] On Behalf Of Singer X.J. Wang
Sent: Thursday, February 03, 2011 7
just a single table with an ID field (primary index) and three data fields
(indexed):
id bigint(20) NO PRI NULLauto_increment
yagoid varchar(32) NO UNI NULL
yagoleftvarchar(32) NO MUL NULL
yakoright varchar(255)NO
Yannis,
How is the data structured? Can you give us an example of the queries
that you are trying to run? Do you have indexes in place? A very inefficient
query, or poorly structured database can lead to this type of timeout issue on
the type of low end hardware that you are using.
Than
Hi everybody,
I have loaded a very big amount of data in my MySQL database (coming from the
YAGO project):
-rw-rw 1 yannis admin 65 3 fév 16:07 db.opt
-rw-rw 1 yannis admin 6392030392 3 fév 21:35 wasfoundin.MYD
-rw-rw 1 yannis admin 11085793280 4 fév 04:54 wasf
Something like this might help you find all of the times where your user_id
switched to a different team_id:
select team_id, user_id, min(last_changed)
from
(select home_team_id as team_id, home_user_id as user_id, last_changed
from data
union all
select away_team_id as team_id, away_user_id as us
You might check here: http://www.census.gov/geo/www/tiger/
-Travis
-Original Message-
From: viraj [mailto:kali...@gmail.com]
Sent: Wednesday, February 02, 2011 3:31 AM
To: mysql@lists.mysql.com
Subject: map polygon data for popular us cities
dear list,
where can i find a list of map pol
On Thu, 3 Feb 2011 13:55:36 +
Tompkins Neil wrote:
> SELECT DISTINCT(away_teams_id) AS teams_id
> FROM fixtures_results
> WHERE (fixtures_results.away_users_id = *users.users_id*)
> Any ideas why I'm getting Unknown column 'users.users_id' in 'where clause'
> for the part of the statement th
I remember a few years back I was doing some terrain modeling, and I think
there was a repository of files on a US government web site. It's been so long
that I don't remember what the file format was, but I was importing them into
a 3D graphics program. There might be flattened versions.
Regar
Hi,
I've the following SELECT statement
SELECT users.gamer_tag, UNIX_TIMESTAMP(users.created_on) AS time_registered,
(SELECT fixtures_results.last_changed
FROM fixtures_results
WHERE (home_users_id = users.users_id AND home_teams_id =
users_teams.teams_id)
OR (away_users_id = users.users_id AND a
Hi,
I've the following list of sample data, and need a SELECT statement to help
me identify the point at which I've highlighted the data :
Season, Competition, home_team_id, away_team_id, home_user_id, away_user_id,
last_changed
1, 18, 11, 23, 3, 2010-11-14 17:18:17
1, 11, 8, 3, 82, 2010-11-14 18
> **On master server I have two databases *A and B*. App team use database B
> temporarily for there application to compute calculation and insert the
> values on A database.
For certain statements you could start with "SET SQL_BIN_LOG=0" so it
doesn't log that statement, and it won't be replicat
Hi
Please unsubscribe my ID from the list
Best
Swagat Lenka
This message is for the designated recipient only and may contain privileged,
proprietary, or otherwise private information. If you have received it in
error, please notify the sender immediately and delete the original. Any other
Besides the above,
I recall Flickr (you know the photo-sharing site) being able to extract
(kind of rough) polygons from exif-data of photos (containing lat/longs) .
Since often these photo's are tagged by city they could extract city
boundaries.
See this old posts I dug up quickly, I'm not sure
16 matches
Mail list logo
