Am 16.09.2016 um 00:21 schrieb Johan De Meersman:
- Original Message -
From: "Reindl Harald"
Sent: Friday, 16 September, 2016 00:12:26
frankly - mysqld_safe needs to go away and life is beautiful without for
years here and yes taht worked for mysql too before switch to MariaDB
to sa
- Original Message -
> From: "Reindl Harald"
> Sent: Friday, 16 September, 2016 00:12:26
>
> frankly - mysqld_safe needs to go away and life is beautiful without for
> years here and yes taht worked for mysql too before switch to MariaDB
>
> to say it clear: running *any* code as root fo
Am 16.09.2016 um 00:05 schrieb Johan De Meersman:
This is probably of interest to many of you, and I've not seen it on the list
yet.
Kenny Gryp's blog about the vulnerability is at
https://www.percona.com/blog/2016/09/12/database-affected-cve-2016-6662/ .
For those who use it, there's an an
2016/03/17 12:47 ... lejeczek:
.. that you experts I hope can crack like a digestive biscuit...
how does one update, or merge or whatever is right technical term for it
- a my.table from my.another table (both are schematically identical, no
foreign keys, one primary key) but..
does it a way so
2014/12/09 14:25 +, Martin Mueller
I'm trying to get my feet wet with 'if' and 'when' uses in mysql. it would be
very useful for update operations, but I can't get it right.
If I read the documentation correctly, it should be possible to say
something like
UPDATE X
if WORD like '
Hello Martin,
On 12/9/2014 9:25 AM, Martin Mueller wrote:
I'm trying to get my feet wet with 'if' and 'when' uses in mysql. it would
be very useful for update operations, but I can't get it right.
If I read the documentation correctly, it should be possible to say
something like
UPDATE X
if W
You can use your login inline with nested IF expressions:
insert into foo(id,comment)
values(17, IF(WORD like 'a%','a',IF(word like 'b%','b',null)));
On Tue, Dec 9, 2014 at 9:50 AM, wagnerbianchi.com
wrote:
> You can do that, but, perhaps the only chance to have it updating a row
> bas
You can do that, but, perhaps the only chance to have it updating a row
based on a condition is developing a Stored Procedure or even having a
BEFORE Trigger associated with the main table. Those ways, you can test the
sent value and decide on what UPDATE you will execute afterwards. Consider
that
Hi Neil,
On 10/30/2013 9:55 AM, Neil Tompkins wrote:
Shawn
What I need is that if I pass say 10 parameters/variables to a query, I
only want to update the column/field if the value passed is NOT NULL.
On Wed, Oct 30, 2013 at 3:41 AM, Shawn Green wrote:
Hi,
On 10/29/2013 9:52 PM, h...@tbbs
Shawn
What I need is that if I pass say 10 parameters/variables to a query, I
only want to update the column/field if the value passed is NOT NULL.
On Wed, Oct 30, 2013 at 3:41 AM, Shawn Green wrote:
> Hi,
>
> On 10/29/2013 9:52 PM, h...@tbbs.net wrote:
>
>> 2013/10/29 11:35 -0400, Shawn Green
Hi,
On 10/29/2013 9:52 PM, h...@tbbs.net wrote:
2013/10/29 11:35 -0400, Shawn Green
My favorite technique is the COALESCE function for this on a column-by-column
basis
SET FieldName1 = Now(), FieldName2 = COALESCE(:MyVariable, FieldName2)
but if MyVariable is NULL, FieldName1 re
2013/10/29 11:35 -0400, Shawn Green
My favorite technique is the COALESCE function for this on a column-by-column
basis
SET FieldName1 = Now(), FieldName2 = COALESCE(:MyVariable, FieldName2)
but if MyVariable is NULL, FieldName1 reflects the attempt to change, not
change.
-
2013/10/28 21:23 +, Neil Tompkins
Basically the snippet of the UPDATE statement I provided shows updating only 1
field.
However in my live working example, I have about 20 possible fields that
"might" need to be updated if the variable passed for each field is NOT NULL.
We
Hello Neil,
On 10/28/2013 5:23 PM, Neil Tompkins wrote:
Hi Shawn
Thanks for your reply. Maybe my example wasn't detailed enough.
Basically the snippet of the UPDATE statement I provided shows
updating only 1 field. However in my live working example, I have about
20 possible fields that "mi
Consider:
update table1 set field1 = if( :var,:var,field1), ...
Can be in a procedure but doesn't have to be.
On Oct 28, 2013 5:28 PM, "Neil Tompkins"
wrote:
> Hi Shawn
>
> Thanks for your reply. Maybe my example wasn't detailed enough. Basically
> the snippet of the UPDATE statement I provide
Hi Shawn
Thanks for your reply. Maybe my example wasn't detailed enough. Basically
the snippet of the UPDATE statement I provided shows updating only 1 field.
However in my live working example, I have about 20 possible fields that
"might" need to be updated if the variable passed for each fiel
Try:
update my_table
set fieldname1 = Now(), Fieldname2 = :myVariable
where Fieldname3 is not null
On 10/28/13 11:06 AM, Neil Tompkins wrote:
Hi
If I have a update statement like
UPDATE MY_TABLE
SET FieldName1 = Now(), FieldName2 = :MyVariable
WHERE FieldName3 = 'Y'
How can I only update t
Hello Neil,
On 10/28/2013 2:06 PM, Neil Tompkins wrote:
Hi
If I have a update statement like
UPDATE MY_TABLE
SET FieldName1 = Now(), FieldName2 = :MyVariable
WHERE FieldName3 = 'Y'
How can I only update the FieldName2 field if the value of MyVariable is
NOT NULL ?
Thanks
Neil
This needs t
2013/06/17 11:38 +0430, Sayyed Mohammad Emami Razavi
update test set desc='test10' where id=1;
_That_ is UPDATE! It is the only means of changing, but neither inserting nor
deleting, a record.
The other fields are left the same.
MySQL also tracks whether it is an actual chang
April 05, 2013 2:56 PM
> To: Urvashi Pathak
> Cc: mysql
> Subject: Re: Update and lock question.
>
> Thanks Urvashi.
>
> Based on your answer, instead of the data I looked into the index, and
> it appears that it was an index issue...
>
> I think I have nailed the wait
ote:
> thx all, the source data is in text file.
>
>
>
>
> - Original Message -
> From: "h...@tbbs.net"
> To: mysql list
> Cc:
> Sent: Saturday, April 6, 2013 8:02 PM
> Subject: Re: update a row only if any column has changed, in a very large
&
thx all, the source data is in text file.
- Original Message -
From: "h...@tbbs.net"
To: mysql list
Cc:
Sent: Saturday, April 6, 2013 8:02 PM
Subject: Re: update a row only if any column has changed, in a very large table
>>>> 2013/04/06 13:56 -0700, Rajee
2013/04/06 13:56 -0700, Rajeev Prasad
I have a table with around 2,000,000 records (15 columns). I have to sync this
from an outside source once every day. not all records are changed/removed
/new-added everyday. so what is the best way to update only those which have
changed/added/or
Hi Andrés,
Select for update makes sure that no other process can change the data between
you selected it for update and then actually changed it and commit it.
If you do not use "select for update" then it is possible that some other
process can change the data in the mean time between you
If'n it were my nickel, here is how I would solve the problem (at a somewhat
high level). That is, assuming I had an ETL tool available.
1. Create landing tables for your source data.
2. Load data from the source table(s) to your new landing table(s).
3. Perform lookups from the new landing table
Thanks Urvashi.
Based on your answer, instead of the data I looked into the index, and it
appears that it was an index issue...
I think I have nailed the wait lock contdition due a updating indexes
unnecesarely...
On Thu, Apr 4, 2013 at 10:52 AM, Urvashi Pathak wrote:
>
>
> Hi Andrés,
>
> Sel
Some combo of IN, EXISTS, UNION? It will probably be verbose.
> -Original Message-
> From: Andrew Moore [mailto:eroomy...@gmail.com]
> Sent: Thursday, November 29, 2012 11:32 AM
> To: Chris W
> Cc: MYSQL General List
> Subject: Re: Update One of Three tables in a single
What's your use case? I've not heard of a like this done at table/sql level.
You could use stored procedures & dynamic SQL to achieve it though.
On Thu, Nov 29, 2012 at 5:44 PM, Chris W <4rfv...@cox.net> wrote:
> I have three tables, TableA, TableB, and TableC each has a unique ID
> field, idA,
On 8/20/2012 10:09 AM, Mogens Melander wrote:
On Sun, August 19, 2012 18:19, william drescher wrote:
On 8/17/2012 12:13 PM, Rik Wasmus wrote:
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more wacky, if I (usin
On Sun, August 19, 2012 18:19, william drescher wrote:
> On 8/17/2012 12:13 PM, Rik Wasmus wrote:
>>> I get 1 row affected, but the status does not change when I look
>>> at the row.
>>>
>>> If I set it to 'X' it does change.
>>>
>>> To make it even more wacky, if I (using phpMyAdmin) change it to
On 8/19/2012 5:56 PM, william drescher wrote:
mysql> select status from tasks;
++
| status |
++
| W |
++
1 row in set (0.00 sec)
mysql> update tasks set status= 'H';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed 1 Warnings: 0
mysql> select status f
On 8/19/2012 1:25 PM, Johnny Withers wrote:
The client indicates a warning after the update. Issue a show warnings
after the update.
actually, it doesn't.
but I did a show warnings and it replied: Empty Set (0.00 sec)
I also did a show triggers and it replied: Empty Set (0.00 sec)
On Aug 19,
The client indicates a warning after the update. Issue a show warnings
after the update.
On Aug 19, 2012 11:19 AM, "william drescher"
wrote:
> On 8/17/2012 12:13 PM, Rik Wasmus wrote:
>
>> I get 1 row affected, but the status does not change when I look
>>> at the row.
>>>
>>> If I set it to 'X'
On 8/17/2012 12:13 PM, Rik Wasmus wrote:
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more wacky, if I (using phpMyAdmin) change it to
'H' it will change and the row is shown change, but when I go to
examine the
> I get 1 row affected, but the status does not change when I look
> at the row.
>
> If I set it to 'X' it does change.
>
> To make it even more wacky, if I (using phpMyAdmin) change it to
> 'H' it will change and the row is shown change, but when I go to
> examine the row (using the pencil icon=
CHEMA = 'dbname'
information_schema.COLUMNS WHERE COLUMN_NAME = 'client'
> -Original Message-
> From: Ananda Kumar [mailto:anan...@gmail.com]
> Sent: Monday, April 30, 2012 2:26 AM
> To: Pothanaboyina Trimurthy
> Cc: mysql@lists.mysql.com
> Subject
Do you just want to replace current value in client column to "NEW".
You can write a stored proc , with a cursor and loop through the cursor,
update each table.
regards
anandkl
On Mon, Apr 30, 2012 at 2:47 PM, Pothanaboyina Trimurthy <
skd.trimur...@gmail.com> wrote:
> Hi all,
> i have one
;>>> 20111219 03:42 PM -0800, Jim McNeely
Not if you are using innoDB tables. For these, you use INSERT and UPDATE
triggers.
Jim McNeely
On Dec 19, 2011, at 11:58 AM, Halász Sándor wrote:
> 2011/12/19 11:30 -0800, Jim McNeely
> In the MySQL documentation, we find this tantalizin
2011/12/19 13:55 -0800, Jim McNeely
Anyway, I just thought I would share. BTW I experimented, and innoDB does
updates and fires off update triggers for REPLACE statements, but MyISAM does
delete/inserts.
Thank you. Which version?
Well, then the documentation is wrong: it is i
Not if you are using innoDB tables. For these, you use INSERT and UPDATE
triggers.
Jim McNeely
On Dec 19, 2011, at 11:58 AM, Halász Sándor wrote:
> 2011/12/19 11:30 -0800, Jim McNeely
> In the MySQL documentation, we find this tantalizing statement:
>
> "It is possible that in the c
2011/12/19 11:30 -0800, Jim McNeely
In the MySQL documentation, we find this tantalizing statement:
"It is possible that in the case of a duplicate-key error, a storage engine may
perform the REPLACE as an update rather than a delete plus insert, but the
semantics are the same. There a
With REPLACE, you just set up the query the same as an INSERT statement but
otherwise it just works. With ON DUPLICATE UPDATE you have to set up the whole
query with the entire text all over again as an update. The query strings for
what I'm doing are in some cases pushing enough text in medical
Good to know and good that you took time to read the manual, good approach.
But why bother with REPLACE if you will go with INSERT.ON DUPLICATE KEY
UPDATE?
The storage engine is a property of your table and you can set it and/or
change it, it is the low-level layer (physical) of the database
In the MySQL documentation, we find this tantalizing statement:
"It is possible that in the case of a duplicate-key error, a storage engine may
perform the REPLACE as an update rather than a delete plus insert, but the
semantics are the same. There are no user-visible effects other than a possib
Perfect!! This is the answer I was looking for. Thanks! I didn't know about
this.
Jim McNeely
On Dec 18, 2011, at 11:26 AM, Claudio Nanni wrote:
> Only if you can change the application you could use INSERTON DUPLICATE
> KEY UPDATE instead of REPLACE.
>
> Check Peter's post here: http://
Only if you can change the application you could use INSERTON DUPLICATE
KEY UPDATE instead of REPLACE.
Check Peter's post here: http://kae.li/iiigi
Cheers
Claudio
2011/12/17 Jim McNeely
> Here is a fun one!
>
> I have a set of tables that get populated and changed a lot from lots of
> R
2011/12/16 16:00 -0800, Jim McNeely
I have a set of tables that get populated and changed a lot from lots of
REPLACE statements. Now, I need an ON UPDATE trigger, but of course the trigger
never gets triggered because REPLACES are all deletes and inserts.
The trigger is going to popula
- Original Message -
> From: "Halász Sándor"
>
> mysql> update address set membersince = (select membersince from
> address where memberid = 1258) where memberid = 1724;
IIRC, subselects are allowed, except for selects that reference the table
you're updating.
--
Bier met grenadyn
Is a
Check out the GET_LOCK and RELEASE_LOCK virtual lock functions in MySQL.
-Hank
On Wed, Sep 28, 2011 at 9:15 AM, Alex Schaft wrote:
> Hi,
>
> We're busy moving legacy apps from foxpro tables to mysql. User logins were
> tracked via a record in a table which the app then locked, preventing
> mul
On Sat, Sep 10, 2011 at 01:48, Carsten Pedersen wrote:
> `userTable.userid` => `userTable`.`userid`
>
Thank you Carsten. That was indeed the problem! Have a peaceful weekend.
--
Dotan Cohen
http://gibberish.co.il
http://what-is-what.com
--
MySQL General Mailing List
For list archives: http:/
`userTable.userid` => `userTable`.`userid`
/ Carsten
On 09-09-2011 23:01, Dotan Cohen wrote:
Now that I've got the syntax right, MySQL is complaining that a field
does not exist, which most certainly does:
mysql> UPDATE
-> `userTable`
-> INNER JOIN `anotherTable`
->ON `u
Now that I've got the syntax right, MySQL is complaining that a field
does not exist, which most certainly does:
mysql> UPDATE
-> `userTable`
-> INNER JOIN `anotherTable`
-> ON `userTable.userid`=`anotherTable.userid`
-> SET `userTable.someField`="Jimmy Page"
-> WHERE `userT
On Wed, 06 Oct 2010 17:48:55 -0400
kalin m wrote:
>
>
> Simcha Younger wrote:
> >> executing this query didn't update the record.
> >>
> >> why?
> >>
> > The two values you have here are equal:
> > sample data : 12862162510269684
> > query: where unix_time < 1286216251026
Simcha Younger wrote:
On Mon, 04 Oct 2010 16:11:08 -0400
kalin m wrote:
what i'm trying to do is update the column only of one of those times
isn't yet passed. and it works. except sometimes...
like these 2 unix times:
this was in the table under unix time: 12862162385941345...
t
On Mon, 04 Oct 2010 16:11:08 -0400
kalin m wrote:
>
>
> what i'm trying to do is update the column only of one of those times
> isn't yet passed. and it works. except sometimes...
>
> like these 2 unix times:
>
> this was in the table under unix time: 12862162385941345...
>
> this 1286216
right the unix times in the example table were just that - examples
from a few days ago...
the example with the query was a 'real one' something that happened today...
it's a 64 bit machine. the unix times are stored in a bigint column.
the times in the column and the update statement
Those unix_time values don't seem to correspond to the dates you have.
select NOW(), UNIX_TIMESTAMP(NOW());
+-+---+
| NOW() | UNIX_TIMESTAMP(NOW()) |
+-+---+
| 2010-10-04 13:18:08 |1286223488
On Mon, 2010-09-27 at 11:25 +0100, Willy Mularto wrote:
> Hi,
> I work on MySQL 5 with PHP 5 and use Apache 2 as the webserver. I have a
> simple query that searches matched row id and update the field via HTTP GET
> query. On a low load it succeed update the row. But on high traffic sometimes
>-Original Message-
>From: Shawn Green (MySQL) [mailto:shawn.l.gr...@oracle.com]
>Sent: Thursday, September 16, 2010 9:51 PM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Update record count
>
>On 9/16/2010 5:12 PM, Jerry Schwartz wrote:
>> I
On Fri, Sep 17, 2010 at 3:51 AM, Shawn Green (MySQL) <
shawn.l.gr...@oracle.com> wrote:
>
> So if 10 rows of A match your conditions, 1 row from B match your
> conditions, and 10 rows from C match your conditions, then this query
> produces 10*1*10 total row combinations.
>
Umm. It's friday, so I
On 9/16/2010 5:12 PM, Jerry Schwartz wrote:
I should be able to figure this out, but I'm puzzled. Here's a simplified
example:
UPDATE a JOIN b ON a.kb = b.kb JOIN c ON b.kc = c.kc
SET a.f1 = NOW(),
b.f2 = NOW()
WHERE c.f3 IN ('x', 'y', 'z')
AND b.f4 = 'yen';
It seems to me that if there are
Try using the IS NULL operator instead of !
-Travis
-Original Message-
From: Andy Wallace [mailto:awall...@ihouseweb.com]
Sent: Thursday, September 16, 2010 10:47 AM
To: mysql@lists.mysql.com
Subject: Update query problem
So I'm having a problem with an update query. I have three tables
Thanks Dan,
I tested it just now. It works perfectly.
Dan Nelson wrote:
In the last episode (Jul 08), Egor Shevtsov said:
I wonder if possible at all to use replace() together with regex in update
statement. I want to be able to update a field of string values and
replace a 'dash' character
In the last episode (Jul 08), Egor Shevtsov said:
> I wonder if possible at all to use replace() together with regex in update
> statement. I want to be able to update a field of string values and
> replace a 'dash' character with a space in the string. Something like:
> UPDATE table SET column =
Dante,
On Tue, Dec 22, 2009 at 3:53 PM, Dante Lorenso wrote:
> All,
>
> There was a feature of another DB that I have grown extremely accustomed to
> and would like to find the equivalent in MySQL:
>
> UPDATE mytable SET
> mycolumn = mycolumn + 1
> WHERE mykey = 'dante'
> RETURNING mycolumn;
I
On Fri, Dec 11, 2009 at 6:40 PM, Victor Subervi wrote:
>
> I'm lost. I set up this database originally with auto_increment and the
> first value was 0. I thought that was always the case. Is there a problem
> here?
>
Yes, that should not have happened. For autoincrement fields, both NULL and
0 ar
On Fri, Dec 11, 2009 at 8:43 AM, Johan De Meersman wrote:
> On Fri, Dec 11, 2009 at 11:19 AM, Mark Goodge
> wrote:
>
> > Jørn Dahl-Stamnes wrote:
> >
> >> On Friday 11 December 2009 10:38, Victor Subervi wrote:
> >>
> >>> Hi;
> >>>
> >>> mysql> update products set sizes="('Small', 'Large')" where
On Fri, Dec 11, 2009 at 11:19 AM, Mark Goodge wrote:
> Jørn Dahl-Stamnes wrote:
>
>> On Friday 11 December 2009 10:38, Victor Subervi wrote:
>>
>>> Hi;
>>>
>>> mysql> update products set sizes="('Small', 'Large')" where ID=0;
>>> Query OK, 0 rows affected, 1 warning (0.00 sec)
>>> Rows matched: 1
On Fri, Dec 11, 2009 at 5:33 AM, wrote:
>
> On Fri, 11 Dec 2009 05:28:41 -0500, Victor Subervi
>
> wrote:
> > On Fri, Dec 11, 2009 at 5:13 AM, wrote:
> >
> >>
> >> On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi
> >>
> >> wrote:
> >>
> >> > mysql> update products set sizes="('Small', 'Large
On Fri, 11 Dec 2009 05:28:41 -0500, Victor Subervi
wrote:
> On Fri, Dec 11, 2009 at 5:13 AM, wrote:
>
>>
>> On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi
>>
>> wrote:
>>
>> > mysql> update products set sizes="('Small', 'Large')" where
>> SKU='prodSKU1';
>> > Query OK, 0 rows a
On Fri, Dec 11, 2009 at 5:13 AM, wrote:
>
> On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi
>
> wrote:
>
> > mysql> update products set sizes="('Small', 'Large')" where
> SKU='prodSKU1';
> > Query OK, 0 rows affected, 1 warning (0.00 sec)
> > Rows matched: 1 Changed: 0 Warnings: 1
> >
> > m
Quoting cars...@bitbybit.dk:
Of course you can have ID=0.
Definately agree
mysql> DESCRIBE test;
+-+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---
day, December 11, 2009 6:13 PM
Subject: Re: Update Doesn't Update!
>
> On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi
>
> wrote:
>
>> mysql> update products set sizes="('Small', 'Large')" where
> SKU='prodSKU1';
>> Qu
Jørn Dahl-Stamnes wrote:
On Friday 11 December 2009 10:38, Victor Subervi wrote:
Hi;
mysql> update products set sizes="('Small', 'Large')" where ID=0;
Query OK, 0 rows affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 1
Look at the
On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi
wrote:
> mysql> update products set sizes="('Small', 'Large')" where
SKU='prodSKU1';
> Query OK, 0 rows affected, 1 warning (0.00 sec)
> Rows matched: 1 Changed: 0 Warnings: 1
>
> mysql> show warnings;
> +-+--+--
On Fri, 11 Dec 2009 10:48:59 +0100, Jørn Dahl-Stamnes
wrote:
> On Friday 11 December 2009 10:38, Victor Subervi wrote:
>> Hi;
>>
>> mysql> update products set sizes="('Small', 'Large')" where ID=0;
>> Query OK, 0 rows affected, 1 warning (0.00 sec)
>> Rows matched: 1 Changed: 0 Warnings:
On Fri, Dec 11, 2009 at 4:43 AM, wrote:
>
> On Fri, 11 Dec 2009 04:38:01 -0500, Victor Subervi
>
> wrote:
> > Hi;
> >
> > mysql> update products set sizes="('Small', 'Large')" where ID=0;
> > Query OK, 0 rows affected, 1 warning (0.00 sec)
> > Rows matched: 1 Changed: 0 Warnings: 1
>
> "Warnin
[mailto:victorsube...@gmail.com]
Sent: 11 December 2009 10:06
Cc: mysql@lists.mysql.com
Subject: Re: Update Doesn't Update!
On Fri, Dec 11, 2009 at 4:48 AM, Jørn Dahl-Stamnes
wrote:
> On Friday 11 December 2009 10:38, Victor Subervi wrote:
> > Hi;
> >
> > mysql> updat
mysql> update products set sizes="('Small', 'Large')" where ID=0;
Query OK, 0 rows affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 1
Look at the message, 0 rows changed and 1 warning.
You cannot have ID=0 if ID is an index.
Are you
On Fri, Dec 11, 2009 at 4:48 AM, Jørn Dahl-Stamnes
wrote:
> On Friday 11 December 2009 10:38, Victor Subervi wrote:
> > Hi;
> >
> > mysql> update products set sizes="('Small', 'Large')" where ID=0;
> > Query OK, 0 rows affected, 1 warning (0.00 sec)
> > Rows matched: 1 Changed: 0 Warnings: 1
>
On Fri, Dec 11, 2009 at 4:48 AM, Jørn Dahl-Stamnes
wrote:
> On Friday 11 December 2009 10:38, Victor Subervi wrote:
> > Hi;
> >
> > mysql> update products set sizes="('Small', 'Large')" where ID=0;
> > Query OK, 0 rows affected, 1 warning (0.00 sec)
> > Rows matched: 1 Changed: 0 Warnings: 1
>
On Friday 11 December 2009 10:38, Victor Subervi wrote:
> Hi;
>
> mysql> update products set sizes="('Small', 'Large')" where ID=0;
> Query OK, 0 rows affected, 1 warning (0.00 sec)
> Rows matched: 1 Changed: 0 Warnings: 1
Look at the message, 0 rows cha
On Fri, 11 Dec 2009 04:38:01 -0500, Victor Subervi
wrote:
> Hi;
>
> mysql> update products set sizes="('Small', 'Large')" where ID=0;
> Query OK, 0 rows affected, 1 warning (0.00 sec)
> Rows matched: 1 Changed: 0 Warnings: 1
"Warnings: 1"
do a SHOW WARNINGS immediately after you e
Something in the ilk of
update *table* set *field* = concat("prefix_", *field*) where *condition *
should do the trick.
On Mon, Oct 19, 2009 at 4:56 PM, lejeczek wrote:
> dear all, a novice here
> quickie regarding query syntax - is it possible to take fields values from
> one column
> and updat
Check out replication.
On Sun, Aug 23, 2009 at 09:00, m. zamil wrote:
> Hello all,
> due to connection state, I need to keep an updated copy of the database on
> the client.
> How can I accomplish this?
> TIA
> Mos
--
Walter Heck, Engineer @ Open Query (http://openquery.com)
Affordable Trai
Perfect. Thank you.
Victor
On Sun, Jul 26, 2009 at 2:18 PM, Darryle Steplight wrote:
> Hi Vicor,
>Look into INSERT ON DUPLICATE or REPLACE statements. You need to
> have a primary key or unique key for these too work.
>
> On Sun, Jul 26, 2009 at 1:11 PM, Victor Subervi
> wrote:
> > Hi;
> > I
Hi Vicor,
Look into INSERT ON DUPLICATE or REPLACE statements. You need to
have a primary key or unique key for these too work.
On Sun, Jul 26, 2009 at 1:11 PM, Victor Subervi wrote:
> Hi;
> I would like to test the following:
>
> update maps set map where site=mysite;
>
> to see if there is s
from: http://dev.mysql.com/doc/refman/5.1/en/insert.html:
INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name
SET col_name={expr | DEFAULT}, ...
[ ON DUPLICATE KEY UPDATE
col_name=expr
[, col_name=expr] ... ]
The ON DUPLICATE KEY predicate tells you
Nathan,
That was exactly what I was looking for, thanks for your help.
John
-Original Message-
From: Nathan Sullivan [mailto:nsulli...@cappex.com]
Sent: Monday, June 29, 2009 2:55 PM
To: John Furlong; mysql@lists.mysql.com
Subject: RE: Update email address domain
John,
I think this
John,
I think this should work:
UPDATE members SET email=REPLACE(email, SUBSTRING(email,INSTR(email,'@')+1),
'Thanks_in_advance.com.com')
Regards,
Nathan
-Original Message-
From: John Furlong [mailto:john.furl...@rakutenusa.com]
Sent: Monday, June 29, 2009 12:54 PM
To: mysql@lists.my
On Fri, May 22, 2009 at 1:22 PM, Chris W <4rfv...@cox.net> wrote:
> Of course study to profile is a one to many relationship. How do I run an
> update to set p.`Date` equal to s.`Date`?
This is covered in the docs for UPDATE. Read that and come back if
you're stuck.
- Perrin
--
MySQL General
Is there ever more than one order per day?
I also think you might mean "most current order per product", but you
didn't say that.
On Tue, Jan 27, 2009 at 8:38 AM, Adria Stembridge
wrote:
> I have a table like this:
>
> ID PRODUCT DATEORDERED
> 152005-02-18
> 22
How about this?
update t set onoffflag = if (name <> 'China', onoffflag, ( if (location =
'Table', 1, 0) ));
This leaves any onoffflag untouched if name is not China, which I assume you
wanted to do.
On Thu, Jan 8, 2009 at 2:18 PM, Christoph Boget
wrote:
> Consider the folowing dataset:
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
Thanks, I'll take a look at that.
Appreciate the help,
Waynn
On Sat, Jul 12, 2008 at 9:02 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> On Sat, Jul 12, 2008 at 8:01 PM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> > Is there any way to have an UPDATE statement change a column value based
> on
> > the WH
On Tue, Jul 15, 2008 at 7:59 AM, Guenter Ladstaetter
<[EMAIL PROTECTED]> wrote:
> UPDATE `phpbt_bug`
> SET title = REPLACE (phpbt_bug.title,"ö","ö")
> WHERE bug_id IN
> (select bug_id, title from phpbt_bug where `title` LIKE "%ö%");
>
>
> The error message is: Operand should contain 1 column(s) 12
On Sat, Jul 12, 2008 at 8:01 PM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> Is there any way to have an UPDATE statement change a column value based on
> the WHERE statement?
>
> Essentially, I want to do something like this
>
> UPDATE Actions SET ActionsSent = WHERE ActionsReceived =
>
> where foo a
> -Original Message-
> From: Albert E. Whale [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 02, 2008 4:06 PM
> To: mysql@lists.mysql.com
> Subject: Update with select
>
> I am trying to update a field on a record in a table. Here is the
> statement I created:
>
> UPDATE pdata SET pv
1 - 100 of 568 matches
Mail list logo
