Re: Error: You can't specify target table '...' for update in FROM clause

Yves Goergen wrote: On 05.02.2008 23:25 CE(S)T, Baron Schwartz wrote: You can't select from a table you're updating at the same time. What "at the same time" means is a bit unclear unless you're one of the MySQL developers ;-) Yes, Paul DuBois already replied to me off-list. Now I found that

Re: Error: You can't specify target table '...' for update in FROM clause

On 05.02.2008 23:25 CE(S)T, Baron Schwartz wrote: You can't select from a table you're updating at the same time. What "at the same time" means is a bit unclear unless you're one of the MySQL developers ;-) Yes, Paul DuBois already replied to me off-list. Now I found that documentation part a

Re: Error: You can't specify target table '...' for update in FROM clause

Hi, On Feb 5, 2008 11:26 AM, Yves Goergen <[EMAIL PROTECTED]> wrote: > Hi, > > I've got an error message from MySQL 5.0 that I don't understand. > > UPDATE "message_revision" SET "HasData" = 1, "Data" = (SELECT "Data" > FROM "message_revision" WHERE "MessageId" = 7 AND "RevisionNumber" = 5) > WHER

Re: Deleting duplicate rows via temporary table either hung or taking way way too long [SOLVED]

Daevid Vincent wrote: WOW! You are right! That's silly. It's a table with a single column. All unique. With out the index MySQL doesn't know they are unique. Anyways, here's the magic incantation that worked for me: DROP TABLE IF EXISTS `dupes`; CREATE TEMPORARY TABLE dupes SELECT LogID

RE: Deleting duplicate rows via temporary table either hung or taking way way too long [SOLVED]

> -Original Message- > From: Chris W [mailto:[EMAIL PROTECTED] > Sent: Monday, February 04, 2008 9:05 PM > To: Daevid Vincent; MYSQL General List > Subject: Re: Deleting duplicate rows via temporary table > either hung or taking way way too long > > > > Daevid Vincent wrote: > > DRO

Re: lock the row selected by a session and lock those rows for other sessions

You said: It is not locking the entire table. It's locking the rows you're selecting. If you don't want the second session to hang and wait, then you need to tell it to lock different rows. Well if you read my message, I dont want another script to select the rows that are selected by another

Error: You can't specify target table '...' for update in FROM clause

Hi, I've got an error message from MySQL 5.0 that I don't understand. UPDATE "message_revision" SET "HasData" = 1, "Data" = (SELECT "Data" FROM "message_revision" WHERE "MessageId" = 7 AND "RevisionNumber" = 5) WHERE "MessageId" = 7 AND "RevisionNumber" = 6 SQL error: [SQLSTATE:HY000, 1093]

Re: lock the row selected by a session and lock those rows for other sessions

(Re-CCing the MySQL list) It is not locking the entire table. It's locking the rows you're selecting. If you don't want the second session to hang and wait, then you need to tell it to lock different rows. It might help if you explain what you're trying to accomplish. It sounds like you're try

mysqld segfault (InnoDB)

Hi, I have a MySQL 5.0.54 instance with a 5.0.22 datadir from a corrupted filesystem, backed up what was readable and am now trying to get it back to life. Unfortunately, mysqld segfaults on startup: --8<-- InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence nu

Re: lock the row selected by a session and lock those rows for other sessions

1) is the table InnoDB? 2) is AUTOCOMMIT on? On Feb 5, 2008 8:44 AM, Frederic Belleudy <[EMAIL PROTECTED]> wrote: > Select for update is not working like the way I expected it: > > FIRST SESSION: > mysql> start transaction; > Query OK, 0 rows affected (0.00 sec) > > mysql> select video_id from vid

Re: lock the row selected by a session and lock those rows for other sessions

Select for update is not working like the way I expected it: FIRST SESSION: mysql> start transaction; Query OK, 0 rows affected (0.00 sec) mysql> select video_id from videos_innodb where state='QUEUE' limit 5 FOR UPDATE; +--+ | video_id | +--+ |1 | |2 | |

Re: Need help to locate SetSRID(),Makebox2D(),Distance_Sphere()

Rakesh! The distance_sphere and makebox2d functions are specific to postgis. MySQL GIS Implementation is based on the Open GIS Simple SQL Specification (read more on www.opengeospatial.com). The SetSRID is also not in the specification as far as I know (it should be, but I can't find it), b

Re: update to last 5.0 GA

Thomas Raso wrote: Hi all, I want to know the main differences between mysql 5.0.41 and MySQL 5.0.51a(last GA release) I read this page : http://dev.mysql.com/doc/refman/5.0/en/mysql-nutshell.html but there is nothing about the developments made by such update... thnaks all... Try this:

Re: How to delete duplicates with full row comapring

On Feb 4, 2008 7:17 PM, Baron Schwartz <[EMAIL PROTECTED]> wrote: > On Feb 4, 2008 11:36 AM, Artifex Maximus <[EMAIL PROTECTED]> wrote: > > Hello! > > > > I am looking for an easy solution for eliminate duplicates but on a row > > level. > > > > I am having 2 tables. 1 destination for all not dupl

update to last 5.0 GA

Hi all, I want to know the main differences between mysql 5.0.41 and MySQL 5.0.51a(last GA release) I read this page : http://dev.mysql.com/doc/refman/5.0/en/mysql-nutshell.html but there is nothing about the developments made by such update... thnaks all...

Can anybody please let me know the counterpart functions for SetSRID(),Makebox2D(),Distance_Sphere() of PostGIS in MySQL

Hello I want to use functions - SetSRID(),Makebox2D(),Distance_Sphere() of Post GIS in MySQL. Can please let me know the similar functions in MySQL. Environment === Operating System : Red Hat Linux 3.4 Database : MySQL Version 5.0.51 PostgreSQL 8.2.6 with PostGIS 1.2.1 Functions whi