> -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
> -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 Sto
> -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:
> 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
> -Original Message-
> From: Mihail Manolov [mailto:mihail.mano...@liquidation.com]
> Sent: March 19, 2012 12:44 PM
> To: Steven Staples
> Cc:
> Subject: Re: Group_Concat help...
>
> Try this
>
> SELECT `user_id`, `login_ip`,
> COUNT(`id`) AS 'co
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'
GROUP
> -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:
> > Go
ll() 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
you
-
> memory tables as example are making much more troubles as myisam
>
> Am 10.11.2011 14:26, schrieb Steven Staples:
> > Good morning list,
> >
> > I am having issues with my replication setup. it seems that every few
> > weeks/months something happens, and
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 new
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: mysq
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 S
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 Mess
cause of the problem, 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?
>
> Hel
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: [MyS
take 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 usuall
mmand line, just 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:prajap
y projects I am working 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
>
and the 5.1.47)?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
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
s to run all weekend 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
that would be ideal.
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
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...@gma
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 fr
RE pnum LIKE
'555-12%';
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
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 [mai
irst_table`.`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]
> Se
I am doing wrong? I can't seem to see 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/my
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
(`datefield`);
(this was just 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: A
, when I do my "JOIN"s, I tend to write "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
ysql site:
http://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: m
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
shoulnd't even be an i/o or cpu 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
i will just delete from the table
where 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 [mail
te on the master, where ID <
XXXX.
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 th
ql. We're 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 different
lhost`) 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-----
Fr
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
t increase 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 unsubscrib
t.ProdID = p.ID
;
<-- end -->
I 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: Joi
what I am 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 t
it before, 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: S
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
44 matches
Mail list logo
