For the curious: As usual "select is not broken".
Lesson learned: Always watch out for warnings:
http://bugs.mysql.com/bug.php?id=41007
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Gautam
nope yours is not a bug. That's all fine. Hex numbers are 64 bit
unsigned.
So for -1 you have to insert cast(0x as signed).
Cheers,
Daniel
Hi Daniel,
I can see the problem without using "update". However, I am a newbie
at
mysql,
so can't say for certain if it's
Hi Daniel,
I can see the problem without using "update". However, I am a newbie at
mysql,
so can't say for certain if it's a bug:
mysql> drop table if exists foo;
mysql> create table foo (id int signed, val bigint signed);
mysql> insert into foo values (0x, 0x), (-1, -1
At 12:03 -0300 7/5/04, j llarens wrote:
Hi people
I'm facing a (not huge) problem with mysqlimport.
The mysql version I'm using is MySQL
4.0.11a-gamma'-Max'
For updating a #29000 records table from fixed-lenght
ASCII file, I'm using a php script that gets a record
and executes and UPDATE for each o
echo $updatequery to screen and see what the sql looks like.
> I am trying to update a table from results generated from a select query,
> but can't seem to get the queries running right. The select query works
> fine, but when I try to use the results for an update it error out. Here
> is
> my
Paul
Thanks alot that help out alot.
-Blake
Paul McNeil wrote:
You have to use
UPDATE MyTABLE set MyTABLE.1 = myValue.
Otherwise you are saying that the numeric value 1 = some other numeric
value.
God Bless
GOD BLESS AMERICA!
To God Be The Glory!
--
MySQL General Mailing List
For list arc
Juha,
select dep.Ref, dep.ActionDate as Departure, arr.ActionDate as Arrival,
dlv.ActionDate as Delivery
from
Table1 dep left join Table1 arr on (dep.Ref = arr.Ref and arr.Timestamp =
'ARR')
left join Table1 dlv on (dep.Ref = dlv.Ref and
dlv.Timestamp = 'DLV')
where
The problem is that you're setting all the rows to "%". The % symbol is only
recognized as a wildcard in like expressions, as documented in the manual. Try this
instead:
UPDATE words_bak1 SET word = LEFT(word, LENGTH(word) - 1) WHERE word LIKE "%s";
Steve Meyers
> -Original Message---
Will,
First of all, if I sounded condescending, it was not my intent. I apologize
if that's how you (or anyone else) took it. I will, however, respond to
your smoking response to mine:
> > I think no-one's replied because the answer is really simple
>
> Oh I don't know Jay, I've seen some thre
s many points with your users
as it did with me?
Will French
> -Original Message-
> From: Jay Fesco [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 24, 2001 8:30 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
> [EMAIL PROTECTED]
> Subject: RE: Update problem
>
&
>
> imho, the fact that mysql does not support joins in UPDATE and DELETE
> statements is by far its greatest weakness. I have posted a couple of
> messages to this group to see what creative work-arounds others
> have used to
> fill this gaping hole in functionality. Alas, no one has felt
> lik
In answer to your question - your statement does not work becuase mysql does
not allow joins in update statements.
imho, the fact that mysql does not support joins in UPDATE and DELETE
statements is by far its greatest weakness. I have posted a couple of
messages to this group to see what creati
You only need to specify SET once.
update Pictures set Date_Posted = '2001-05-09', Notes = 'Test' where ID
='1';
- Original Message -
From: "Barry L. Jeung" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 11, 2001 12:55 PM
Subject: Update problem, or more likely and problem
I don't believe you need the second set
update Pictures set Date Posted = '2001-05-09', Notes = 'Test' where
ID ='1';
I think that should work
-Original Message-
From: Barry L. Jeung [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 3:56 PM
To: [EMAIL PROTECTED]
Subject: Update pro
petro writes:
> Hello!
> Need some help.
> I have two tables
> t1 with fields id and site
> t2 with fields id, from, to, koef
> I want to update t2 set koef=2 if the from field in t2 table exist in
> t1.url
> such update return error.
> update t2, t1 set t2.koef=0 where t2.from=t1
15 matches
Mail list logo
