On Fri, Jun 18, 2010 at 16:30, Dave wrote:
> SELECT * FROM contacts WHERE state = 'CA' and name = 'bob' or
> name = 'sam' or name = 'sara'
We begin by asking on the right list (mysql@lists.mysql.com, CC'd
by courtesy).
You're on the right track though. Try a WHERE...IN statem
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 into
Ok, I know I am an idiot sometimes, and I think this falls into that
category.
I use SQLYog as my MySQL front end editor. I was looking to do some
things, and was going to run a check table command, and clicked the
"analyze" button, and didn't realize that all the tables in the database
were sel
We're excited to announce Surge, the Scalability and Performance
Conference, to be held in Baltimore on Sept 30 and Oct 1, 2010. The
event focuses on case studies that demonstrate successes (and failures)
in Web applications and Internet architectures.
Our Keynote speakers include John Allspaw an
Raj Shekhar writes:
> One option here might be to use "mysql proxy" as a man-in-the-middle and
> filter out unwanted queries...
This seems more or less the same as what I'm doing now with php.
The same question applies there - what would you look for in your
filter?
--
MySQL General Mailing Li
As far as I know, you can´t change data on the same table in triggers.
"Kevin Labecot" escreveu na mensagem
news:4d2ce38b-d169-478b-aebf-c19f20dce...@labecot.fr...
Hi,
Is there a way to update the same table on a delete trigger ?
I need to call an UPDATE statement when a delete occurs.
Hi,Is there a way to update the same table on a delete trigger ?I need to call an UPDATE statement when a delete occurs.Best regards
-- Kevin Labecot, Innovanticwww.innovantic.frTél. : 05.56.45.60.54
might be this will help you.
http://adminlinux.blogspot.com/2010/05/mysql-checking-and-reparing-tables.html
On Fri, Jun 18, 2010 at 6:59 PM, wrote:
> this built in command is probably a good start:
>
> http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
>
>
>
>
>
> --
> MySQL General Mailing
this built in command is probably a good start:
http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hello,
I had an issue yesterday, where one of my tables ended up being closed
improperly, and needed to be repaired. This isn't really an issue in
itself, but I didn't know about it until 2 hours after it happened, and a
script was trying to write to that table, and it failed, which caused a
bac
Hello,everyone,here is my question:
Q1--- in this function (mysql_options() ),the desc of MYSQL_OPT_READ_TIMEOUT in
the Reference Manual 5.0 is as follows:"The timeout in seconds for attempts to
read from the server...".My question is how should I understand this word
"read",does it means access
11 matches
Mail list logo
