-Original Message-
From: ratlhaga...@yahoo.com [mailto:ratlhaga...@yahoo.com]
Sent: September 18, 2012 7:31 AM
To: mysql@lists.mysql.com
Subject: [Possible Spam]Php programmer
Hi,
I need help, I'm working on a project that need time query in Mysql. I
want
to display a time in
-Original Message-
From: Rick James [mailto:rja...@yahoo-inc.com]
Sent: September 17, 2012 3:04 PM
To: peter.braw...@earthlink.net; mysql@lists.mysql.com
Subject: RE: function INTERVAL in view
INTERVAL is a keyword. This is probably the root of the hiccup.
Is that your Stored
-Original Message-
From: Andrés Tello [mailto:mr.crip...@gmail.com]
Sent: May 12, 2012 10:08 AM
To: mysql
Subject: Mysql is toying me... why sometimes an insert or update can be
slow!? I getting bald cuz this
While doning a batch process...
show full processlist show:
| 544
AFAIK the tables will be locked one by one until checked/repaired.
On May 10, 2012, at 3:07 PM, Adrian Fita wrote:
On 10/05/12 21:51, Mihail Manolov wrote:
You can enable check/recovery automatically by using
myisam_recover. Look it up in the documentation.
There is no way to
Hello!
I am trying to do something, but I can't seem to figure out how...
My query is as follows:
SELECT `user_id`, GROUP_CONCAT(DISTINCT `login_ip`) AS 'login_ips',
COUNT(`id`) AS 'connections'
FROM `mysql_test`
WHERE `login_datetime` BETWEEN '2012-03-19 00:00:00' AND '2012-03-19
23:59:59'
-Original Message-
From: Mihail Manolov [mailto:mihail.mano...@liquidation.com]
Sent: March 19, 2012 12:44 PM
To: Steven Staples
Cc: mysql@lists.mysql.com
Subject: Re: Group_Concat help...
Try this
SELECT `user_id`, `login_ip`,
COUNT(`id`) AS 'connections'
FROM `mysql_test
shell() command instead, but I would rather avoid that if
at all possible.
Thanks in advance!
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
-Original Message-
From: Peter Brawley [mailto:peter.braw...@earthlink.net]
Sent: February 22, 2012 11:07 AM
To: Steven Staples; mysql@lists.mysql.com
Subject: Re: MySQL Session Variables with PHP
On 2/22/2012 9:47 AM, Steven Staples wrote:
Good [insert time of day here] all
Good morning list,
I am having issues with my replication setup. it seems that every few
weeks/months something happens, and I have to restart it, skip a row, or
delete, rsync and restart replication from scratch.
The databases that are being replicated, are rather large... there are about
12
: November 10, 2011 8:42 AM
To: mysql@lists.mysql.com
Subject: Re: Relication Issues
replication is buggy sometimes
but without any outputs desribing your problem nobody can really help you
-
memory tables as example are making much more troubles as myisam
Am 10.11.2011 14:26, schrieb Steven
DATE_ADD(NOW(), INTERVAL 1 DAY) will give you tomorrow...
Not sure if that is what you're looking for or not...
Steven Staples
-Original Message-
From: Eric Bloomquist [mailto:eric_bloomqu...@cooley-dickinson.org]
Sent: August 27, 2010 12:17 PM
To: mysql@lists.mysql.com
Subject
I am not too good with charting (even though I would like to be), but what
about getting the max, min and avg, if the max/min is greater than x% of the
avg, show that... ?
Just throwing out ideas... prolly not useful... but may cause a better idea ;)
Steven Staples
-Original Message
On another thought, what about if you group it by whatever, if the MIN()/MAX()
is greater than X times STDDEV(), show MIN() or MAX() ?
I just recalled a conversation with my boss the other week about the STDDEV()
Steven Staples
-Original Message-
From: Steven Staples
, before
adding to it.
Steven Staples
-Original Message-
From: Nunzio Daveri [mailto:nunziodav...@yahoo.com]
Sent: August 4, 2010 2:40 PM
To: mysql@lists.mysql.com
Subject: Moving from one MySQL server to three MySQL servers?
Hello Gurus :-) I was running a simple load generator
FLOOR() CEIL() or ROUND()
SELECT ROUND(1+1.6, 0);
= 3
SELECT FLOOR(1+1.6);
= 2
SELECT CEIL(1+1.6);
= 3
Steven Staples
-Original Message-
From: Ashley M. Kirchner [mailto:ash...@pcraft.com]
Sent: July 20, 2010 1:52 PM
To: mysql@lists.mysql.com
Subject: Re: [MySQL] Re: Decimal points
care of the mysql as well?
Steven Staples
-Original Message-
From: alba.albetti [mailto:alba.albe...@libero.it]
Sent: July 15, 2010 10:00 AM
To: mysql
Subject: Why is MySQL always linked to Php?
Browsing the Web I've seen that usually companies look for developers
working
incase you're
locked out of it somehow, or if you need to repair, backup or create users.
But if you're a windoze user, 99% of them don't know what a command line is
:)
Steven Staples
-Original Message-
From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
Sent: July 1, 2010
on, where I've done this, but done it in
code, rather than in mysql.
Steven Staples
-Original Message-
From: Dušan Pavlica [mailto:pavl...@unidataz.cz]
Sent: June 29, 2010 11:26 AM
To: Victor Subervi
Cc: mysql@lists.mysql.com
Subject: Re: Two Primary Keys
Hi,
try
)?granted, this is not the debian mailing list, just
thought I would ask that last part ;)
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
.
Thanks in advance,
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
long...
Can I just kill it, or will it corrupt the table it is currently on?
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Nevermind, it just finished... holy uggh!
Steven Staples
-Original Message-
From: Steven Staples [mailto:sstap...@mnsi.net]
Sent: June 18, 2010 2:31 PM
To: mysql@lists.mysql.com
Subject: analyze table issue
Ok, I know I am an idiot sometimes, and I think this falls
, and
is replicating 3 other servers). So, all the sql databases will have to
be updated/upgraded, but is there anything I/we should be made aware of
before we go ahead? (there is a lot of release notes to sift through)
Steven Staples
-Original Message-
From: baron.schwa...@gmail.com
Putting the 'HAVING' in there, works perfectly :)
THANKS!
Steven Staples
-Original Message-
From: SHAWN L.GREEN [mailto:shawn.l.gr...@oracle.com]
Sent: June 10, 2010 8:03 PM
To: Steven Staples
Cc: 'MySql'
Subject: Re: WHERE clause from AS result
On 6/10/2010 4:38 PM, Steven
%';
It gives me this error:
Error Code : 1054
Unknown column 'pnum' in 'where clause'
Any ideas?
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
`.`progress` 0;
Granted, you have not provided structure or names of the tables so this is
just my interpretation, but maybe something like this could give you a
starting point?
Steven Staples
-Original Message-
From: Michael Stroh [mailto:st...@astroh.org]
Sent: June 3, 2010 11:24 AM
I am glad that I was able to help someone finally :)
There may be other ways to do this, but that was what first came to mind.
I would maybe run an explain on that query to ensure that it is using
indexes.
Steven Staples
-Original Message-
From: Michael Stroh [mailto:st
anything wrong.
Also, upgrading from 5.0.32 would require upgrading both the master and
slave, and right now, that is not a good idea (we are discussing it though)
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
If you wanted to use/go that route, then why not select a random limit 1
from that table, and then delete that row?
SELECT `column` FROM `table` ORDER BY RAND() LIMIT 1;
On a side note, I would use the auto-inc field still, and store this number
in another field.
Steven Staples
taken off the top of my head, but it should give something
that you're looking for... hopefully ;) )
Steven Staples
-Original Message-
From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
Behalf Of Baron Schwartz
Sent: April 29, 2010 8:34 AM
To: MySql
Subject: Re
ON
(table1.field=jointable.field) rather than just ON (field).
And on a final thought, the where cause, seems to be the join clause as
well, so isn't that redundant? (or is would that only be in the way that i
said i do my joins?)
++
| Steven Staples
://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_grou
p-concat
SET [GLOBAL | SESSION] group_concat_max_len = val;
Steven Staples
-Original Message-
From: kalin m [mailto:ka...@el.net]
Sent: April 7, 2010 12:59 PM
To: Nathan Sullivan
Cc: mysql@lists.mysql.com
Subject: Re
details?
Also, when i would do a select, if i wanted say d02f1, would it load the
entire row first, and then just give me that field?
-Select `d02f01` from `mytable` where [where clause]
Or would it jsut load that field...
Does these questions make sense? (they do in my head)
Steven Staples
issue.
Please help! :)
Thanks in advance
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
on the master, where ID
.
Steven Staples
-Original Message-
From: Johnny Withers [mailto:joh...@pixelated.net]
Sent: March 5, 2010 1:11 PM
To: Steven Staples
Cc: mysql@lists.mysql.com
Subject: Re: Master/Slave - trucate master table
Does START SLAVE fail?
If so, what is the output
the ID and then reset the ID to 0 or 1... and then delete
everything from and beyond
I was just wondering if this was a bug, or if there was something wrong with
what I did?
Steven Staples
-Original Message-
From: Ananda Kumar [mailto:anan...@gmail.com]
Sent: March 8, 2010 11
getting an error now. Apparently one of
the tables is out of sync now? What appears to have happened, is that when
the slave was down, i truncated a table on the master.
I've read that this sometimes causes errors, is this a bug? Or a is there
something I should do differently?
Steven Staples
Good morning!
I have been struggleing with creating a store procedure, that will allow 2
users
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
`) PROCEDURE
`sstest`()
.
CREATE definer=`use...@`%` OR definer=`sstapl...@`localhost` PROCEDURE
`sstest`()
.
CREATE definer=`use...@`%` definer=`sstapl...@`localhost` PROCEDURE
`sstest`()
I can't think how it would be possible? Or is it?
Steve
-Original Message-
From: Steven
performance if this
was a large database? If so, could I just
symlink the test/ directory to another raid array to increase performance?
Or would the increase be negligible?
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
didn't run this, or try to replicate it, it was just my observation on the
query.
Steven Staples
-Original Message-
From: Victor Subervi [mailto:victorsube...@gmail.com]
Sent: December 14, 2009 11:26 AM
To: mysql@lists.mysql.com
Subject: Join Statement
Hi;
I have the following:
mysql
needing now)
Steven Staples
-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: December 11, 2009 9:50 AM
To: mysql@lists.mysql.com
Subject: Re: Stored Proc's
of course. you can have entries
u...@domain1.me.com
u...@xxx.foo.com
the only caveat is to make sure
created, my php app adds the username/customerid to that
server, then makes a connection to the logging server and creates the same
record, same with deleting and updating... but there just has to be a
simpler way :)
Thanks in advance.
Steven Staples
--
MySQL General Mailing List
For list
, but I guess my searching keywords were
insufficient ;)
Steven Staples
-Original Message-
From: harrison.f...@sun.com [mailto:harrison.f...@sun.com]
Sent: December 9, 2009 2:07 PM
To: Johan De Meersman
Cc: Neil Aggarwal; Steven Staples; mysql@lists.mysql.com
Subject: Re: Select from
44 matches
Mail list logo