Try searching for a row that has a login_date of '-00-00 00:00:00'
- Derek
On Sep 9, 2011, at 8:52 AM, umapathi b wrote:
> Any update from anybody ?
>
>
> -- Forwarded message --
> From: umapathi b
> Date: Thu, Sep 8, 2011 at 4:28 AM
> Su
Any update from anybody ?
-- Forwarded message --
From: umapathi b
Date: Thu, Sep 8, 2011 at 4:28 AM
Subject: Re: strange mysql update ..
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Here is the o/p after the update ..
user_id: 16078845
drivers_license
. instead of where I used and )
> > update user_info set login_date='2011-08-05 04:15:05' where user_id
> > =16078845 limit 1 ; ( this is the query intended )
> >
> > after the update ..I got this message ..
> > mysql> update user_info set login_date=&#
:15:05' where user_id
> =16078845 limit 1 ; ( this is the query intended )
>
> after the update ..I got this message ..
> mysql> update user_info set login_date='2011-08-05 04:15:05' and user_id
> =16078845 limit 1;
> Query OK, 1 row affected, 1 warning (0.02 sec)
>
> =16078845
>> limit 1 ;
>> ( I forgot to use where . instead of where I used and )
>> update user_info set login_date='2011-08-05 04:15:05' where user_id
>> =16078845 limit 1 ; ( this is the query intended )
>>
>> after the update ..I got this message ..
>
5 04:15:05' and user_id =16078845
> limit 1 ;
> ( I forgot to use where . instead of where I used and )
> update user_info set login_date='2011-08-05 04:15:05' where user_id
> =16078845 limit 1 ; ( this is the query intended )
>
> after the update ..I got this message
after the update ..I got this message ..
mysql> update user_info set login_date='2011-08-05 04:15:05' and user_id
=16078845 limit 1;
Query OK, 1 row affected, 1 warning (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 0
It shows that one record is affected and one row changed ..
I
Hi,
How big is sample.sql dump ?
there are many different things, might taking the time. dns resolve issue,
network issue
tcp0 0 www.myweb.:mysql A.B.C.D:8366 *TIME_WAIT* (It should
established)
load on the server, check mysql processlist (any wrong query is there)
Thanks,
Krishn
Did you check the server load when it took 10 min.
Check the query log, number of connections and the number of queries in
query log at that time.
We need to analyze the system with the collected data what we have for
monitoring.
Thanks
Suresh Kuna
On Fri, Jan 22, 2010 at 12:25 PM, madunix wrote
I have the following update procedure that update mySQL DB over the
internet between source Linux Centos (local machine on my net behind a
DMZ with real IP A.B.C.D) and target Linux fedora (web server
www.myweb.com) every day on a specific time 18:00 through a crontab on
my source linux server
ser
Increase your Innodb_buffer_pool_size. It will solve your problem.
Thanks,
Krishna
On Sat, Aug 29, 2009 at 10:39 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Hi All,
>
> I have a query which gives an error of lock wait timeout only this
> transaction is running with 2 recor
Hi,
You are right. The storage engine i m using is InnoDB. but then my concern
is why this simple update query takes so long. Is it true that if its
innodb table then even after specifying where condition it scans all
indexed rows. I am bit confused as mysql.com have mentioned on there site
that e
On Sat, Aug 29, 2009 at 12:09 PM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Hi All,
>
> I have a query which gives an error of lock wait timeout only this
> transaction is running with 2 records in the table.
>
> The query is :
>
> Update Test
> Set TestFlag = 1
> Where TestID
Hi All,
I have a query which gives an error of lock wait timeout only this
transaction is running with 2 records in the table.
The query is :
Update Test
Set TestFlag = 1
Where TestID = 5;
Can this one transaction lock my entire table?
--
Thanks and Regards,
Manasi Save
Artificial Machines
Hello,
got this error when upgrading our MySQL:
rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm
Preparing...### [100%]
file /usr/lib/libmysqlclient.so.12.0.0 from install of MySQL-shared-4.0.20-0
conflicts with file from package MySQL-shared-compat-4
On 12/3/03 7:27 PM [EMAIL PROTECTED] wrote:
Hi,
yah that's what I'm looking for, creating a "cronjob" whereby this "cron" will
automatically delete the record once 30 days is up...maybe using something
like that:
"DELETE FROM tablename
WHERE (DATA_SUB(NOW()), INTERVAL 30 DAY) > name_of_date_
Hi all:
Having some doubts with sql select queries here :
Right now, I have a "student" and a "withdraw" tables.
For example, when student "John" has withdrawn, his name will be inserted
into "withdraw" table but John's record will be kept in "student" table for a
period of 30 days befor
Hi all:
Having some doubts with sql select queries here :
Right now, I have a "student" and a "withdraw" tables.
For example, when student "John" has withdrawn, his name will be inserted
into "withdraw" table but John's record will be kept in "student" table for a
period of 30 days before
Prem Soman <[EMAIL PROTECTED]> wrote:
> i want to update every row in the mysql table that
> matches a part of each row in it.
>
> ie.
>
> for example if a table contains the following rows :
>
> Pid:21577
> PPid: 21174
> Uid:501
> Gid:501
>
> i want to change the firs
i want to update every row in the mysql table that
matches a part of each row in it.
ie.
for example if a table contains the following rows :
Pid:21577
PPid: 21174
Uid:501
Gid:501
i want to change the first row to
Pid:30209
similarly for any row
plz advice me
Hi there,
I'm running MySQL-server-4.0.10-0.i386 on a Linux Box (SuSE 8.1) and all
tables are MyISM. Today a made strange observation. All update
statements on one table where completely "ignored" by the server. There
was no error message - just a "0 rows affected". After restart of mysqld
everyti
Hi everybody
I sent a couple of mail recently, asking some help for some strange
behaviour with select and updates.
I hope many of you have read it...the problem was that making a
SELECT something FROM table WHERE 'Where_Clause'
gave some results, >0.
the query:
UPDATE table SET something WHE
joseph,
Wednesday, October 30, 2002, 9:53:57 PM, you wrote:
js> On Tue, Oct 29, 2002 at 11:56:01AM +0200, Egor Egorov wrote:
>> Marco,
>> Tuesday, October 29, 2002, 7:22:44 AM, you wrote:
>>
>> MB> I need your expert and slow guided assistance.
>>
>> MB> I would some one to teach me how to do fo
On Tue, Oct 29, 2002 at 11:56:01AM +0200, Egor Egorov wrote:
> Marco,
> Tuesday, October 29, 2002, 7:22:44 AM, you wrote:
>
> MB> I need your expert and slow guided assistance.
>
> MB> I would some one to teach me how to do for that user
> MB> and allow him/website to have access to that database
Marco,
Tuesday, October 29, 2002, 7:22:44 AM, you wrote:
MB> I need your expert and slow guided assistance.
MB> I would like someone to explain to me the correct mysql commands
MB> monitor to achive the following correctly.
MB> It would greatly help if you work for a hosting company.
MB> The qu
Hello there,
I need your expert and slow guided assistance.
I would like someone to explain to me the correct mysql commands
monitor to achive the following correctly.
It would greatly help if you work for a hosting company.
The question is:
User asks to be given access to mysql database for hi
Steve,
Tuesday, July 23, 2002, 7:36:39 AM, you wrote:
S> Can anyone tell me how do achieve the following in MySQL:
S> Update oitems
S> SET Pstatus = SELECT product.Pstatus from products
S> WHERE oitems.Pstatus not like "%Printed%"
S>AND oitems.ProdCode=products.Code
S> i.e.
OOps somehow my last request got re: on the Subject
Can anyone tell me how do achieve the following in MySQL:
Update oitems
SET Pstatus = SELECT product.Pstatus from products
WHERE oitems.Pstatus not like "%Printed%"
AND oitems.ProdCode=products.Code
i.e. I need to
Can anyone tell me how do achieve the following in MySQL:
Update oitems
SET Pstatus = SELECT product.Pstatus from products
WHERE oitems.Pstatus not like "%Printed%"
AND oitems.ProdCode=products.Code
i.e. I need to update all order item status flields that hav
At 21:30 11/7/2002 -0300, [EMAIL PROTECTED] wrote:
Hi,
>I am trying to update my version and I am not getting. My current version is
>3.23.49-nt. I am using MySql in Windows 2000.
>
>When I try to install it happens the mistake -103:
>
>An error occurred during the moves date process: -103
>Compo
I am trying to update my version and I am not getting. My current version is
t> 3.23.49-nt. I am using MySql in Windows 2000.
t> When I try to install it happens the mistake -103:
t> An error occurred during the moves date process: -103
t> Component: servers
t> File group:
t> File:
Did you rem
I am trying to update my version and I am not getting. My current version is
3.23.49-nt. I am using MySql in Windows 2000.
When I try to install it happens the mistake -103:
An error occurred during the moves date process: -103
Component: servers
File group:
File:
thank you
--
I'm told that one cannot write an Update Query with a Join in MySQL.
Does anyone know if this is true?
Thank you for your help
Joe
Joseph W. Cherner, President
SmokeFree Educational Services, Inc.
http://www.smokefree.org
"Never doubt that a small group of thoughtful citizens can change the w
* USER
> Is there any way to do an Update...Select like an InsertSelect?
>
> For instance can I fill one table with data from another table.
> The columns
> do not match exactly so a table copy won't do much good. But the data
> retrieved in the select command is compatible with the new table
Is there any way to do an Update...Select like an InsertSelect?
For instance can I fill one table with data from another table. The columns
do not match exactly so a table copy won't do much good. But the data
retrieved in the select command is compatible with the new table fields.
sql,que
Comments inline below.
On Wednesday 09 January 2002 18:13, Paul DuBois wrote:
> At 17:23 -0800 1/9/02, Kyle Hayes wrote:
[snipped replication explanation]
> >The program works by getting the contents of the update log and using
> > the Perl DBI do() function on each statement.
> >
> >The problem
At 17:23 -0800 1/9/02, Kyle Hayes wrote:
>I am putting the finishing touches on a completely reworked replication
>server/client scheme (we cannot use MySQL's native replication for what we
>are doing). The whole thing is written in Perl/DBI and runs
>on Linux (x86). We are using various version
I am putting the finishing touches on a completely reworked replication
server/client scheme (we cannot use MySQL's native replication for what we
are doing). The whole thing is written in Perl/DBI and runs
on Linux (x86). We are using various versions of MySQL, but all 3.23.x
series. We a
On Fri, Sep 21, 2001 at 01:43:32AM -0400, Will French wrote:
>
> Actually yes (if I read the documentation correctly - I have not
> tried this).
But if his ISP won't allow it, he can't do it.
Maybe I misunderstood.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Financ
Preface #1: Hi MySQL Admin!
There's an oddity at http://www.mysql.com/doc/. Entering my.cnf returns no
hits. Entering cnf returns all relevant hits.
Preface #2: Hi All!
Folks, this is the *best* online documentation I have ever ever seen. You
can save youself lotsa time waiting for replies here
on 9/21/01 12:43 AM, Will French at [EMAIL PROTECTED] wrote:
> Actually yes (if I read the documentation correctly - I have not tried
> this).
> In MySql Manual section "4.10.5 Replication Options in my.cnf", I find:
> binlog-do-db=database_name
> Tells the master it should log updates fo
nd exclude all others not explicitly mentioned.
(Example: binlog-do-db=some_database)
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 21, 2001 1:34 AM
> To: Christopher Raymond
> Cc: MySQL Mailing List
> Subje
On Thu, Sep 20, 2001 at 04:25:29PM -0500, Christopher Raymond wrote:
>
> Friends:
>
> My ISP does not enable update logging with their MySQL server. Is it
> possible for them or me to turn on update logging just for MY database(s)
> ???
No.
Jeremy
-
Friends:
My ISP does not enable update logging with their MySQL server. Is it
possible for them or me to turn on update logging just for MY database(s)
???
I appreciate any help & God Bless America,
Christopher Raymond
As far as I know, 'update' is a reserved word
and you should quote it with reversed quotes
(you know they are on my keyboard near '1').
I hope it helps.
Daniel BI
> Hi,
>I'm useing mysql php and SSL on a colbalt raq, the problem I'm having
is
> that when ever I use the update query it does
Hi,
I'm useing mysql php and SSL on a colbalt raq, the problem I'm having is
that when ever I use the update query it doesn't always update, say just
UPDATE table SET f1 = 'update' WHERE id = '2'
some times when I first run the page it works but then other times it doesn't
update, I also use
Hi.
On Wed, Feb 14, 2001 at 03:28:23PM -, [EMAIL PROTECTED] wrote:
> >Description:
> Upgrading from 3.22 to 3.23 with a field having a reserved name
> ALTER TABLE barfs and doesn't let me do
> ALTER TABLE casualties CHANGE when cas_when DATE NOT NULL;
ALTER TABLE casualties CHANGE `when` cas
upgrade to 3.23
>Fix:
Manually edited the .frm file - didn't feel right
Need something to either do it automatically on upgrade, or a standalone
utility to modify the mysql files directly.
>Submitter-Id:
>Originator:David Croft
>Organization:
>MySQL support: none
>S
48 matches
Mail list logo
