Emmett Bishop <[EMAIL PROTECTED]> wrote:
> I ran into this problem when I installed 4.0.18. All
> of the tables in my database are INNODB and the
> REPLACE statement was failing on tables that had
> foreign key constraints. I just rolled back to 4.0.16
> and the problems went away. Not much of a so
I ran into this problem when I installed 4.0.18. All
of the tables in my database are INNODB and the
REPLACE statement was failing on tables that had
foreign key constraints. I just rolled back to 4.0.16
and the problems went away. Not much of a solution,
but it's buying me a little time. Will I ha
Kevin Carlson <[EMAIL PROTECTED]> wrote:
> I have a table with four columns, the first three of which are combined
> into a unique key:
>
>
> create table Test {
> cid int(9) NOT NULL default '0',
> sid int(9) NOT NULL default '0',
> uid int(9) NOT NULL default '0',
> rat
Worked like a dream Dan
Thanks Paul for being patient :)
Thank you
Andrew
>-Original Message-
>From: Dan Greene [mailto:[EMAIL PROTECTED]
>Sent: 17 November 2003 21:27
>To: [EMAIL PROTECTED]; Mikael Fridh; MySQL-Lista
>Subject: RE: replace query + RTFM?
>
>
>you
On Monday 17 November 2003 01:18 pm, Andrew wrote:
> Can someone kindly tell me what I doing wrong and help with this query?
>
> I want to replace / update the text for every record within table items
> field ItemDescription. This is what I have so far and its isn't corroect :(
>
> UPDATE items SET
[EMAIL PROTECTED]
> Sent: Monday, November 17, 2003 4:19 PM
> To: [EMAIL PROTECTED]; Mikael Fridh; MySQL-Lista
> Subject: RE: replace query + RTFM?
>
>
>
>
> Can someone kindly tell me what I doing wrong and help with
> this query?
>
> I want to replace / update the te
Can someone kindly tell me what I doing wrong and help with this query?
I want to replace / update the text for every record within table items field
ItemDescription. This is what I have so far and its isn't corroect :(
UPDATE items SET ItemDescription='A-Z Business Directory Please
call 0870
>Looks to me like you want to use UPDATE instead. Specify a WHERE clause
>that identifies the rows you want to update, and in the SET clause specify
>the new value for the description column.
>
>To pre-flight your UPDATE, you can write a SELECT that has the same WHERE
>clause. This will show you
3 18:31
To: [EMAIL PROTECTED]; MySQL-Lista; Rodolphe Toots
Subject: RE: replace query + RTFM?
Andrew,
Please allow a small amount of grief to come from these lists...
People are usually glad to help, and Mike sent the info that he knew
to you. There is a certain amount of frustration that develops w
ta; Rodolphe Toots
>Subject: RE: replace query + RTFM?
>
>
>Andrew,
>
>Please allow a small amount of grief to come from these lists...
>People are usually glad to help, and Mike sent the info that he knew
>to you. There is a certain amount of frustration that develops when
>
box]
Dan Greene
> -Original Message-
> From: Andrew [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 17, 2003 1:16 PM
> To: MySQL-Lista; Rodolphe Toots
> Subject: RE: replace query + RTFM?
>
>
> amazing, and you guys are errr intelligent!!! can't actually
&g
[EMAIL PROTECTED]
>Subject: SV: replace query + RTFM?
>
>
>RTFM = "read the fucking manual"..
>
>-Ursprungligt meddelande-
>Från: Andrew [mailto:[EMAIL PROTECTED]
>Skickat: den 17 november 2003 18:55
>Till: Mikael Fridh; [EMAIL PROTECTED]; MySQL-Lista
>
ge-
>From: Mikael Fridh [mailto:[EMAIL PROTECTED]
>Sent: 17 November 2003 17:12
>To: [EMAIL PROTECTED]; MySQL-Lista
>Subject: Re: replace query
>
>
>On Monday 17 November 2003 18.04, Andrew wrote:
>> I have a MySQL database with records in a table that i would like to
On Monday 17 November 2003 18.04, Andrew wrote:
> I have a MySQL database with records in a table that i would like to
> replace. The table is
>
> items and the field is description. I would like to replace the existing
> text within this filed with some new text.
>
> I did this before and it was
speters,
Thursday, September 19, 2002, 10:55:41 PM, you wrote:
samdc> If i use a replace query, and there isn't an error, then either
samdc> a new row was inserted, or an existing row was updated.
samdc> The primary key in the table i'm replacing to is defined as
samdc> mprid int not null auto_i
> -Original Message-
> Hi,
> i have a table with 2000 rows.
> One column (name answer)has a string ("ok --") in all the
> rows.(e.g "ok --
> yes we support this.").
> now i want to remove all these 'ok --' in this
> column..leaving(e.g yes we
> support this)
> I tried to do it with the r
On 10 Jul 2002, at 12:13, Anil Garg wrote:
> One column (name answer)has a string ("ok --") in all the rows.(e.g
> "ok -- yes we support this."). now i want to remove all these 'ok --'
> in this column..leaving(e.g yes we support this) I tried to do it with
> the replace query but being a newbie
On Wednesday, 10. July 2002 18:13, Anil Garg wrote:
Hi!
> I tried to do it with the replace query but being a newbie to mysql i
> couldnt find the right syntax.
> Can someone help.
>
http://www.mysql.com/doc/U/P/UPDATE.html
Regards
Georg
--
18 matches
Mail list logo
