why not answer the question another user made hours ago?
under which account do you try to start mysqld?
Agreed. Chances are good that if he goes into the Windows Services control
panel and gets the properties of the mysql service, he will find that it is
configured to start under a Windows
1. MyISAM locks _tables_. That can cause other connections
to be blocked. Solution: switch to InnoDB. Caution: There
are a few caveats when switching; see
https://kb.askmonty.org/en/converting-tables-from-myisam-to-innodb/
2. As mentioned by Shawn, the Query Cache can be more
-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
Several MySQL fora, including all the Usage fora, have been overrun by
spam to the point of unusability, with no sign of effective remediation.
This gives the impression that a process of letting MySQL die of
neglect has begun.
PB
--
MySQL General Mailing List
For list archives: http
this (i think spanish) autoreply-spammer
from the list nbecause the only thing i understand is some
price in € and that our spm-firewall is tagging it
Original-Nachricht
Betreff:[SPAM] Re: Re: Can't connect to MySQL server on '127.0.0.1'
(111)
Datum: 2 Apr 2011 17:17
Can anybody remove this (i think spanish) autoreply-spammer
from the list nbecause the only thing i understand is some
price in € and that our spm-firewall is tagging it
Original-Nachricht
Betreff:[SPAM] Re: Re: Can't connect to MySQL server on '127.0.0.1'
(111)
Datum
/ - everything you could possibly want (to buy)
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Monday, October 25, 2010 3:53 PM
To: Patrick Thompson; gto...@ffn.com; mysql@lists.mysql.com
Subject: [SPAM] RE: mySql versus Sql Server performance
Importance: Low
Patrick-
you'll want to determine
From: Joerg Bruehe joerg.bru...@sun.com
Hi!
Octavian Rasnita wrote:
I have tried, but with no difference.
I have changed some indexes and made the queries run faster, but I still
found a problem:
I use a module that does paging and it makes a select(*) and this query
takes a very long
So it seems this account was cracked/hacked. Some of you may have
received some bullshit email about buying a TV. Please ignore that
message as it was sent from whoever hacked this account. It's already
been rectified.
I apologize for the inconvenience.. damn hackers.
for those that care the
It´s working.
The problem was related to grant permission.
Thank you.
Cheers,
Hugo
-Mensagem original-
De: Gavin Towey [mailto:gto...@ffn.com]
Enviada em: terça-feira, 4 de agosto de 2009 19:46
Para: Hugo Leonardo Ferrer Rebello; mysql@lists.mysql.com
Assunto: [SPAM] RE: Remote
grant all on *.* to root@'%.def.com'; /* The percent sign is your
wildcard character. */
flush privileges;
I don't think you need to flush privileges as of 5.0. I still do just
to be sure.
Curtis
[EMAIL PROTECTED] wrote:
Hi Parikh,
Yes.. It worked with IP i.e when I granted privileges
, Raymond A Jr [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 13, 2008 7:22 PM
To: mysql@lists.mysql.com
Subject: [SPAM] - MS SQL emulator for MySQL in order to support MS
Project Server, Sharepoint... - Email found in subject
I apologize for asking this question
-Original Message-
From: Olaf Stein [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 17, 2008 12:13 PM
To: Peter (MySQL List); MySql
Subject: [SPAM] - Re: Sun and mysql - Email found in subject
You have a point.
But, facebook makes NO money
Big fish eats the small fish.. :)
Will this bring good things to MySQL?
-Original Message-
From: John Meyer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 16, 2008 8:58 AM
To: Brett Harvey; mysql@lists.mysql.com
Subject: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject
Will this bring good things to MySQL?
$800,000,000 tends to bring good things. Hopefully. :-)
--
Richard Heyes
http://www.websupportsolutions.co.uk
Mailing list management service allowing you to reach your Customers
and increase your sales.
** NOW OFFERING FREE ACCOUNTS TO CHARITIES AND
Richard Heyes schrieb:
Will this bring good things to MySQL?
$800,000,000 tends to bring good things. Hopefully. :-)
??? why, this payment goes to current owners and investors, not to MySQL
itself ...
but anyway, using Suns structures and power will help of course ...
--
Sebastian
--
Oracle and Sun has a tight relationship right? Wouldn't there be a
conflict of interest?
-Original Message-
From: Sebastian Mendel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 16, 2008 10:03 AM
To: [EMAIL PROTECTED]
Cc: Jerome O. Macaranas; mysql@lists.mysql.com
Subject: [SPAM
Subject: RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email
found in subject - Email found in subject
Oracle and Sun has a tight relationship right? Wouldn't there be a
conflict of interest?
-Original Message-
From: Sebastian Mendel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January
-Original Message-
From: Dušan Pavlica [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 19, 2007 5:08 AM
To: Hartleigh Burton
Cc: MySql
Subject: {Spam?} Re: mysqldump problem with large innodb tables...
Try to look for Lost connection error in MySQL manual and it can give your some
hints
http://lists.mysql.com/[EMAIL PROTECTED]
that link ought to help you.
Jacques Brignon wrote:
Hi,
I keep receiving this message by several dozens each day, how can this
be stopped?
Regards
Jacques
-Message d'origine-
De : Jerry Schwartz [mailto:[EMAIL PROTECTED]
Envoyé : jeudi
What's kind of the message you guys mentioned?
- Original Message -
From: LP [EMAIL PROTECTED]
To: 'MySQL List' mysql@lists.mysql.com
Sent: Saturday, March 24, 2007 10:13 PM
Subject: Re: SPAM ?
Hi,
I also get the problem of keep receiving the email from the email list
Regards
Hi,
What's kind of the message you guys mentioned?
Its always the same message from the same author with the same content,
same date same hour, its the one below:
-Message d'origine-
De : Jerry Schwartz [mailto:[EMAIL PROTECTED]
Envoyé : jeudi 22 mars 2007 17:53
À : [EMAIL
: Sunday, March 25, 2007 6:07 PM
Subject: RE : SPAM ?
Hi,
What's kind of the message you guys mentioned?
Its always the same message from the same author with the same content,
same date same hour, it's the one below:
-Message d'origine-
De : Jerry Schwartz [mailto:[EMAIL PROTECTED
Hi,
http://lists.mysql.com/[EMAIL PROTECTED]
that link ought to help you
Looks a bit extreme, as long as I feel there is some value to be part of
this list :-).
I suspect all members of the list experience the same problem; I feel it
would be more valuable to solve the problem than to
Schwartz'; 'MySQL List'
Objet : RE : SPAM ?
Hi,
http://lists.mysql.com/[EMAIL PROTECTED]
that link ought to help you
Looks a bit extreme, as long as I feel there is some value to be part
of
this list :-).
I suspect all members of the list experience the same problem; I feel
Hi,
I keep receiving this message by several dozens each day, how can this
be stopped?
Regards
Jacques
-Message d'origine-
De : Jerry Schwartz [mailto:[EMAIL PROTECTED]
Envoyé : jeudi 22 mars 2007 17:53
À : [EMAIL PROTECTED]; 'James Tu'
Cc : 'MySQL List'
Objet : RE: Finding a
Hi,
I also get the problem of keep receiving the email from the email list
Yeah, same here. I keep getting e-mail from a list that I subscribed
to and confirmed my subscription for ...
Dang, how do I solve that.
;)
--
Martijn
--
MySQL General Mailing List
For list archives:
Dear MySQL general list members,
I have a guest book on a small club web page that has been getting
regular spam in with
the legitimate replies.
I use MySQL and (I think) Apache-style PHP to run the database. I know
it is PHP and
am certain when I started these survey and guest book
On 3/9/07, Gloria McMillan [EMAIL PROTECTED] wrote:
Dear MySQL general list members,
I have a guest book on a small club web page that has been getting
regular spam in with
the legitimate replies.
I use MySQL and (I think) Apache-style PHP to run the database. I know
it is PHP and
am certain
I would like to create a MySQL to protect my subscribers and clients from
receiving a spam emails.
I can create a new table for MySQL and write new script for PHP
MySQL:
mysql_query(CREATE TABLE members(
members_id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
email_address VARCHAR(50
--On September 9, 2006 12:11:15 AM -0700 deafmickey [EMAIL PROTECTED]
wrote:
I would like to create a MySQL to protect my subscribers and clients from
receiving a spam emails.
I can create a new table for MySQL and write new script for PHP
MySQL:
mysql_query(CREATE TABLE members
receiving a spam emails.
I can create a new table for MySQL and write new script for PHP
MySQL:
mysql_query(CREATE TABLE members(
members_id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
email_address VARCHAR(50))
or die(mysql_error());
mysql_query(CREATE TABLE spam_free(
id INT NOT NULL
deafmickey [EMAIL PROTECTED]
wrote:
I would like to create a MySQL to protect my subscribers and clients
from receiving a spam emails.
I can create a new table for MySQL and write new script for PHP
MySQL:
mysql_query(CREATE TABLE members(
members_id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id
Spam detection software, running on the system marmalade.snp.org, has
identified this incoming email as possible spam. The original message
has been attached to this so you can view it (if it isn't spam) or label
similar future email. If you have any questions, see
[EMAIL PROTECTED] for details
Since a couple of recent stable versions back (and more recently, MySQL
5.0.22), MySQL has been returning the column length (C API) of the 'Type'
column of a show columns from.. statement as being 196605 (almost 192KB),
when this column only really contains data in the region of 10 bytes, if
Thanks Brent.
I increased my wait_timeout.But now also my aborted clients seems
increasing than connections.As u said most of my front end code use
mysql persistent connect only.Can u clarify my one more doubt that when
to use persistent connect and when to use mysql_connect and their
]
To
mysql@lists.mysql.com
cc
Subject
{Spam?} Limiting results from joins
Hey list;
Consider this statement:
SELECT * FROM products p, manufactors m, items i WHERE p.manufactor_id
= m.manufactor_id p.product_id = i.product_id;
Now, each unique product_id from products can have more than one
2006-04-22 (토), 00:49 +0100, Philippe Poelvoorde 쓰시길:
Hi,
mysql select * from user_todo_german_english where wordid = '86851' and
posn = '1' and pos = 'm' AND mb_id='curious';
+-++--+--+-+
| mb_id | wordid | posn | pos | date_col
Thankyou Gabriel.
So how does one set a column comment then?
Regards
Keith
In theory, theory and practice are the same;
in practice they are not.
On Thu, 20 Apr 2006, Gabriel PREDA wrote:
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
From: Gabriel PREDA [EMAIL PROTECTED]
Subject: [SPAM] Re
: Monday, February 27, 2006 6:06 PM
To: Philip Hallstrom
Cc: mysql@lists.mysql.com
Subject: [SPAM] - Re: MYSQL: Unlimited Forums, Scalablity Issues, advice
please? - Bayesian Filter detected spam
Hi Philip, thanks for the reply.
Single master + many read only slaves would only solve the problem
ORDER by qty ASC
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 22, 2006 2:58 PM
To: MySql
Subject: [SPAM] - Re: Inner join with left join - Bayesian Filter
detected spam
Is this what you mean?
SELECT
p.prod_name,
count(oi.product_id
I keep forgeting to reply all. Sorry
- Message transféré de Jacques Brignon [EMAIL PROTECTED] -
Date : Tue, 31 Jan 2006 13:33:22 +0100
De : Jacques Brignon [EMAIL PROTECTED]
Adresse de retour :Jacques Brignon [EMAIL PROTECTED]
Sujet : RE: [SPAM] - Trans.: Re: Finding the row
@lists.mysql.com
Subject: [SPAM] - Trans.: Re: Finding the row number satisfying a conditon in a
result set - Bayesian Filter detected spam
Oops! forgoten to include the list in the relply
--
Jacques Brignon
- Message transféré de Jacques Brignon [EMAIL PROTECTED] -
Date : Mon, 30 Jan 2006 16:16
@lists.mysql.com
Subject: [SPAM] - convert help - Bayesian Filter detected spam
I am trying to convert binary data to a bigint so I can do bitwise
operations on the data, and I'm having trouble doing it.
I noticed that if I have binary data and I:
select data1; I get 0 (not what I'm expecting).
Here is a test
)
-
- ;
++-+
| @fdata | hex(@fdata) |
++-+
| ═∩☺#E | CDEF012345 |
++-+
1 row in set (0.00 sec)
-Original Message-
From: David Godsey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 19, 2006 3:33 PM
To: mysql@lists.mysql.com
Subject: [SPAM
| hex(@fdata) |
++-+
| ââ©âº#E | CDEF012345 |
++-+
1 row in set (0.00 sec)
-Original Message-
From: David Godsey [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 19, 2006 3:33 PM
To: mysql@lists.mysql.com
Subject: [SPAM] - convert help
PROTECTED]
Sent: Wednesday, January 11, 2006 9:47 AM
To: MySQL General
Subject: [SPAM] - Re: mysql 5 - disk bound - fixed - Email found in
subject
2006/1/11, George Law [EMAIL PROTECTED]:
Hi All,
[snip]
I have to work on an automatic way to rotate these tables every week.
Is there an easy way
the FROM section of your SELECT
statement and paste it in the UPDATE section and move the WHERE section
of the SELECT to the UPDATE.
-Original Message-
From: 2wsxdr5 [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 11, 2006 11:30 AM
To: mysql@lists.mysql.com
Subject: [SPAM] - Adding data
@lists.mysql.com
Subject: [SPAM] - Re: Converting decimal to binary - Bayesian Filter
detected spam
If you really do mean decimal (base 10) you could use Gordon's solution
like this:
SELECT
MID(CONV(HEX(245),16,2),1,1) AS `7`,
MID(CONV(HEX(245),16,2),2,1) AS `6`,
MID(CONV(HEX(245),16,2),3,1) AS `5`,
MID
to any base so if it is base 10
then just replace the 16's with 10's.
Too much time looking at dump's.
-Original Message-
From: Bill Dodson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 3:09 PM
To: Gordon Bruce
Cc: Ed Reed; mysql@lists.mysql.com
Subject: [SPAM] - Re
Message-
From: Bill Dodson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 3:09 PM
To: Gordon Bruce
Cc: Ed Reed; mysql@lists.mysql.com
Subject: [SPAM] - Re: Converting decimal to binary - Bayesian Filter
detected spam
If you really do mean decimal (base 10) you could use Gordon's
: Bill Dodson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 3:09 PM
To: Gordon Bruce
Cc: Ed Reed; mysql@lists.mysql.com
Subject: [SPAM] - Re: Converting decimal to binary - Bayesian Filter
detected spam
If you really do mean decimal (base 10) you could use Gordon's solution
Francesco Riosa wrote:
And another one is (in inverse order for laziness):
select
(8 1) AS `0`
, (8 2 1) AS `1`
, (8 4 1) AS `2`
, (8 8 1) AS `3`
, (8 16 1) AS `4`
, (8 32 1) AS `5`
, (8 64 1) AS `6`
, (8 128 1) AS `7`
;
but this one looks better:
select
(8 1)
.
-Original Message-
From: 2wsxdr5 [mailto:[EMAIL PROTECTED]
Sent: Friday, January 06, 2006 8:09 PM
To: mysql@lists.mysql.com
Subject: [SPAM] - concat string and update question - Found word(s)
remove list in the Text body
I have a table of people and their phone numbers, some have the area
.
mysql SELECT ABS(2);
- 2
mysql SELECT ABS(-32);
- 32
This function is safe to use with BIGINT values.
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Friday, January 06, 2006 12:19 PM
To: Mester József; mysql
Subject: [SPAM] - Re: SQL Question - Bayesian
To: mysql@lists.mysql.com
Subject: [SPAM] - Re: locating ibdata1 and *.ibd files in different
directories. - Bayesian Filter detected spam
Hello.
symbolic links! Thats a neat solution. Question: when you say
symbolic links for databases do you mean links to ibd files, ibdata1
file, either
I got one from mysql@lists.mysql.com, and one from [EMAIL PROTECTED]
And my filters remove anything that isn't from one of the mailing lists
I subscribe to.
Daniel Kasak wrote:
Stephen Cook wrote:
What's the deal with SPAM on the list?
I don't see any. Maybe my spam filter is better
Subject: Re: [OT] SPAM
I got one from mysql@lists.mysql.com, and one from
[EMAIL PROTECTED]
And my filters remove anything that isn't from one of the mailing lists
I subscribe to.
Daniel Kasak wrote:
Stephen Cook wrote:
What's the deal with SPAM on the list?
I don't see any. Maybe my
On Friday 16 December 2005 00:34, Stephen Cook wrote:
I got one from mysql@lists.mysql.com, and one from [EMAIL PROTECTED]
And my filters remove anything that isn't from one of the mailing lists
I subscribe to.
Did the spam actually come through the list, or did it just fake the From to
make
What's the deal with SPAM on the list?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
@lists.mysql.com
cc
Subject
{Spam?} MySQL and dates puzzle
Hello all,
I have a TA table to record TA UNAVAILABLE times.
This table is quite simple. It has a TAID number, a start date and an
end date.
tbl_schedule {
TAID integer,
starts datetime,
ends datetime }
A valid entry would be a TA
You might try UNION with the 1st statement pulling all products with
groupid = 0 and the 2nd pulling 1 product with groupid 1.
-Original Message-
From: John Nichel [mailto:[EMAIL PROTECTED]
Sent: Monday, October 10, 2005 3:31 PM
To: MySQL List
Subject: [SPAM] - Query help - Bayesian
Leith
Cool-Tools UK Limited
http://www.cool-tools.co.uk
http://leithal.cool-tools.co.uk
-Original Message-
From: Karam Chand [mailto:[EMAIL PROTECTED]
Sent: 10 August 2005 15:26
To: mysql@lists.mysql.com
Subject: [SPAM?]: Case issue in Information_schema
Hello,
I
: [EMAIL PROTECTED]; mysql@lists.mysql.com;
[EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Since you can connect as yannick without password, just set it after login :
mysql SET PASSWORD FOR 'yannick'@'localhost' = PASSWORD('newpass');
see http
@lists.mysql.com;
[EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Hi,
you should have a list in the user table of mysql database :
mysql use mysql
Database changed
mysql show tables;
+---+
| Tables_in_mysql
' to database 'mysql'
mysql
-Message d'origine-
De : Mathias [mailto:[EMAIL PROTECTED]
Envoyé : Sunday, June 26, 2005 8:35 AM
À : [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com;
[EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
: [EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Hi,
Sorry but you are not the administrator else you have the root password.
So why search midday at 14 ?
Just connect with root pass and see if mysql is here.
Else mysql is like the other databases
issue.
Yannick
-Message d'origine-
De : Mathias [mailto:[EMAIL PROTECTED]
Envoyé : Sunday, June 26, 2005 4:03 PM
À : [EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Hi,
Sorry but you are not the administrator else you have
;
[EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
hi Yannick,
This is my ultimate help.
See this url, you have all in it :
http://dev.mysql.com/doc/mysql/en/unix-post-installation.html
And all you want is here :
http://www.mysql.com/search/?q
account.
Best regards.
Yannick
-Message d'origine-
De : Mathias [mailto:[EMAIL PROTECTED]
Envoyé : Sunday, June 26, 2005 6:25 PM
À : [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com;
[EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter
]
Envoyé : Saturday, June 18, 2005 2:57 PM
À : mysql@lists.mysql.com; [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]
Objet : Re: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Hi yannick,
Not sure if you have found the problem yet, any way there are many tutorials
online which explain
, I can not create any new database
That is the problem.
-Message d'origine-
De : Nils Valentin [mailto:[EMAIL PROTECTED]
Envoyé : Saturday, June 18, 2005 2:57 PM
À : mysql@lists.mysql.com; [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]
Objet : Re: [SPAM] - Unable to install mysql
, I can not create any new database
That is the problem.
-Message d'origine-
De : Nils Valentin [mailto:[EMAIL PROTECTED]
Envoyé : Saturday, June 18, 2005 2:57 PM
À : mysql@lists.mysql.com; [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]
Objet : Re: [SPAM] - Unable to install
?
Thanks
Yannick
-Message d'origine-
De : Mathias [mailto:[EMAIL PROTECTED]
Envoyé : Sunday, June 26, 2005 12:01 AM
À : Mathias
Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED];
mysql@lists.mysql.com; [EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
the root password ? How can I flush the privilidges ?
Thanks
Yannick
-Message d'origine-
De : Mathias [mailto:[EMAIL PROTECTED]
Envoyé : Sunday, June 26, 2005 12:01 AM
À : Mathias
Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED];
mysql@lists.mysql.com; [EMAIL PROTECTED]
Objet : RE: [SPAM
]
Envoyé : Sunday, June 26, 2005 12:36 AM
À : [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]; mysql@lists.mysql.com;
[EMAIL PROTECTED]
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Since you can connect as yannick without password, just set it after login :
mysql SET
-
De : Yannick [mailto:[EMAIL PROTECTED]
Envoy : Monday, June 13, 2005 11:54 PM
: [EMAIL PROTECTED]
Cc : mysql@lists.mysql.com
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Kevin,
Thanks for your answer. See below the results :
* I' really wondering
Struckhoff
Customer Analytics Mgr.
NewRoads West
Office 818.253.3819 Fax 818.834.8843
[EMAIL PROTECTED]
-Original Message-
From: Danny Stolle [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 10:08 AM
To: mysql@lists.mysql.com
Subject: [SPAM] - discuss: user management - Bayesian
@lists.mysql.com
Objet : RE: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Yannick,
MySQL is very picky in how it handles security, or at least different.
It has an extra layer of complexity, compared to say, the Informix
RDBMS, which uses the OS user/password and grant statements
having it working ut I still have this
priviledge issue.
BEst regards
Yannick
-Message d'origine-
De : Yannick [mailto:[EMAIL PROTECTED]
Envoyé : Monday, June 13, 2005 11:54 PM
À : [EMAIL PROTECTED]
Cc : mysql@lists.mysql.com
Objet : RE: [SPAM] - Unable to install mysql - Bayesian
]
Sent: Monday, June 13, 2005 11:42 AM
To: mysql@lists.mysql.com
Subject: [SPAM] - Unable to install mysql - Bayesian Filter detected
spam
Hey guys,
I am not able to install properly mysql. Please see below the technical
details or the bug report.
The installation goes well until I try to add
This is what I call WAY OVER
REACTING.
This member turned
my email into the spam report immediately without thinking. Now I am
recieving these.
ThanksDonny LairsonPresident29
GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228 2183
-Original Message-From
[EMAIL PROTECTED] wrote:
This is what I call WAY OVER REACTING.
*This member turned my email into the spam report immediately without
thinking. Now I am recieving these.*
I doubt that there's any connection. It's impossible to tell
for sure, but the message was probably rejected because
.
*This member turned my email into the spam report immediately without
thinking. Now I am recieving these.*
I doubt that there's any connection. It's impossible to tell for sure,
but the message was probably rejected because of the capital letters and
multiple exclamation points in the subject line
I have two servers, server5.mydomain.com and server8.mydomain.com. I want to
replicate one database on server5 to server 8.
I did the whole proceedure as recommended in
http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set
Up Replication
I setup the GRANT statement on server5
Chris Mason wrote:
I have two servers, server5.mydomain.com and server8.mydomain.com. I want to
replicate one database on server5 to server 8.
I did the whole proceedure as recommended in
http://dev.mysql.com/doc/mysql/en/replication-howto.html - 6.4. How to Set
Up Replication
I setup the GRANT
[snip]
From: Jay Blanchard [EMAIL PROTECTED]
So if I index a date field (given -mm-dd) and then
SELECT `userNames`
FROM `userTable`
WHERE SUBSTRING(`userBirthDate`, 6, 5) = SUBSTRING(NOW(), 6, 5)
it is still very fast. I have a table with several thousand records in
it and I get back
[snip]
I'm trying to write a conditional statement in my query. Is the
following possible in MySQL?
IF(@SomeValue = 1)
THEN
SELECT The value is 1;
ELSE
SELECT The value is not 1;
END IF
I've tried different variations and nothing seems to be working (I'm
getting syntax errors). I'm using MySQL
Hi,
Apologies, yes I have RTFM, and should've clarified my question. I
actually need to do something more like this:
IF(@SomeValue = 1)
BEGIN
THEN
SELECT Data as Column1,
MoreData as Column2
ELSE
SELECT SomeValue is not = 1 as Error
END IF
Thanks,
Luke Venediger.
On Fri,
T-SQL style procedural scripting will not be initially available outside
of stored procedures. Stored procedures are new to 5.0 (still under
development) so what you want to code is not available, yet. You will
have to make program branch choices in a programming language as the SQL
engine
[snip]
How do I create table that uses timestamp in -dd-mm format as
primary id
(no duplicates)?
[/snip]
CREATE TABLE `tblFoo` (
`timeID` timestamp(14) NOT NULL,
PRIMARY KEY (`timeID`),
) TYPE=MyISAM;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
[snip]
What's the deal w/ backslash?
[/snip]
It is an escape character. In order to get things with backslashes, as
you have deduced, you
SELECT \\
Do you have a column '\'? If so, why?
Backslashes are often used in this way...
SELECT businessName FROM table WHERE businessName = 'Doc\'s';
I'm populating a new table from excel sheets and for some silly reason
several column values are populated with \ (not my doing!).
I can easily fix the problem but I was just wondering.
Thanks Everyone.
Jay Blanchard [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
[snip]
What's the
[snip]
I'm pretty sure this is a good starting point, but that's just matching
resource
to resource without excluding Lincoln from building an Ark (no canvas).
mysql SELECT project.proj,project.rsrc,people.name FROM project LEFT
JOIN
people ON project.rsrc=people.rsrc;
[snip]
You haven't stated the resources required for the project in the query.
Try this ...
SELECT project.proj, project.rsrc, people.name
FROM project LEFT JOIN
people ON project.rsrc=people.rsrc
WHERE project.rsrc = 'wood'
AND project.rsrc = 'canvas'
Not tested, but limits people to thos who
[snip]
$dbhost = 'localhost';
[/snip]
Try changing this to 127.0.0.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Which flag did you use to define the datadir for configure? --datadir
doesn't do the trick. --localstatedir does. Also, you might want to
consider setting --prefix as well.
--V
sean c peters wrote:
The problem is that i did build 4.1.3 florm a source distribution, and set the
datadir via
Hi all.
Over the last 2 days, both my home and work email addresses have been
hit with a sudden surge in spam, and the content in both cases is the
same. Another strange thing is that my home address got basically none -
until now.
I'm assuming my addresses have been harvested from this list
I know my emial; accounts been getting quite alot of spam, though it's been like that
for a while now for my self. All I know my email was harvested from other lists too;
which may have been the case for myself.
Chris
From: Daniel Kasak [EMAIL PROTECTED]
Date: 2004/05/20 Thu AM 08:14:03
From: Paul DuBois
At 17:50 -0500 5/16/04, Paul DuBois wrote:
Not a huge difference, I guess. But I suppose if a query that
uses one or the other of these expressions processes a large number
of rows, it might pay to run some comparative testing.
Another interesting point is whether one
1 - 100 of 177 matches
Mail list logo