how much more efficient would it be to write the same statements
to a text file, and then fork a child thread to connect to the
database, and read the entire infile at once?
If I understand you correctly, this is addressed in the section of the manual to
which I previously referred you. From
sql,query,queries,smallint
On Thu, 2 Jan 2003, Peter Lovatt wrote:
I was looking for a reasonably heavyweight php application, there are some
lightweight ones and some half finished ones and some perl ones, but none
that were what I was looking for.
Any suggestions would be appreciated, no
(was Re: An Idea)
Hi
Is '111' the IP it is trying to connect on?
If so it is an invalid IP.
If the IP is valid how are you trying to connect?
Peter
---
Excellence in internet and open source software
(Berlin) [EMAIL PROTECTED]; David T-G
[EMAIL PROTECTED]; mysql users [EMAIL PROTECTED]
Sent: Wednesday, January 01, 2003 6:36 PM
Subject: Re: FAQ hosting site (was Re: An Idea)
On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote:
I am not sure if there is existing faq software (I've
R. Hannes Niedner wrote:
Isn't that funny: if I have a mysql related question and search google I end
up in the mysql online documentation in 90% of cases.
I find if I just use the word 'mysql' in my query on Google, I get
fairly appropriate results too.
Not using the word mysql often
-
From: David T-G [EMAIL PROTECTED]
To: mysql users [EMAIL PROTECTED]
Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]
Sent: Wednesday, January 01, 2003 1:35 AM
Subject: Re: An Idea
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan --
...and then Stefan Hinz, iConnect (Berlin) said
-
From: JamesD [EMAIL PROTECTED]
To: David T-G [EMAIL PROTECTED]; mysql users
[EMAIL PROTECTED]
Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]
Sent: Wednesday, January 01, 2003 5:11 AM
Subject: RE: An Idea
we find people just like to ask questions,
and no matter how good our FAQ's
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan, et al --
...and then Stefan Hinz, iConnect (Berlin) said...
%
% David,
%
% see it dropped if they don't jump on it at the start.
%
% I agree. Will you set it up at http://justpickone.org/? (BTW, I like
Sure; it's the least I can do.
-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 01, 2003 5:31 AM
To: JamesD; David T-G; mysql users
Subject: Re: An Idea
James,
something that can be based upon pages of htm and
emails that exists, and that can sit under a few
: David T-G [EMAIL PROTECTED]
To: mysql users [EMAIL PROTECTED]
Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]
Sent: Wednesday, January 01, 2003 4:12 PM
Subject: Re: FAQ hosting site (was Re: An Idea)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan, et al --
...and then Stefan Hinz
bericht-
Van: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Verzonden: woensdag 1 januari 2003 22:26
Aan: David T-G; mysql users
Onderwerp: Re: FAQ hosting site (was Re: An Idea)
David,
Sure; it's the least I can do. Look for mysql.justpickone.org to be
in
the DNS tables
(Berlin) [mailto:[EMAIL PROTECTED]]
Sent: 01 January 2003 21:26
To: David T-G; mysql users
Subject: Re: FAQ hosting site (was Re: An Idea)
David,
Sure; it's the least I can do. Look for mysql.justpickone.org to be
in
the DNS tables by tomorrow. By then the
[EMAIL PROTECTED]
mailing list
---
-Original Message-
From: Stefan Hinz, iConnect (Berlin)
[mailto:[EMAIL PROTECTED]]
Sent: 01 January 2003 21:26
To: David T-G; mysql users
Subject: Re: FAQ hosting site (was Re: An Idea)
David,
Sure; it's the least I can do
hosting site (was Re: An Idea)
I really need your help, I installed MySQL and I can
connect to it through localhost but when trying to
access it from outside I get:
ERROR 2003: Can't connect to MySQL server on 'IP'
(111)
Any suggestions?
Someone suggested that the problem is because the
server
On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote:
I am not sure if there is existing faq software (I've checked
sourceforge and freshmeat without much luck)
Really?
That's a wheel I've seen re-invented many times. I know there's stuff
out there.
--
Jeremy D. Zawodny |
[mailto:[EMAIL PROTECTED]]
Sent: 02 January 2003 00:37
To: Peter Lovatt
Cc: Stefan Hinz, iConnect (Berlin); David T-G; mysql users
Subject: Re: FAQ hosting site (was Re: An Idea)
On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote:
I am not sure if there is existing faq software (I've
---
-Original Message-
From: mnbv [mailto:[EMAIL PROTECTED]]
Sent: 02 January 2003 00:23
To: Peter Lovatt; Stefan Hinz, iConnect (Berlin); David T-G; mysql users
Subject: RE: FAQ hosting site (was Re: An Idea)
I really need your help, I installed MySQL and I can
connect
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan, et al --
...and then Stefan Hinz, iConnect (Berlin) said...
%
% So (taking a deep breath !) I would be prepared to lay the foundations
...
%
% Thanks, I appreciate that. I've been waiting a moment before answering,
% waiting for others to
-
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent: 31 December 2002 11:13
To: mysql users
Cc: Stefan Hinz, iConnect (Berlin)
Subject: Re: An Idea
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan, et al --
...and then Stefan Hinz, iConnect (Berlin) said...
%
% So (taking a deep breath
David,
regarding the MySQL FAQ:
Why should it have to be there? Let anyone with a site set it up and
get
it going and see if readers will even care about it, and *then*
perhaps
have it move to mysql.com later...
MySQL.com would be the natural place for the FAQ. Any other place
wouldn't be
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan --
...and then Stefan Hinz, iConnect (Berlin) said...
%
% David,
%
% regarding the MySQL FAQ:
%
% Why should it have to be there? Let anyone with a site set it up and
...
%
% MySQL.com would be the natural place for the FAQ. Any other
-Original Message-
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 4:36 PM
To: mysql users
Cc: Stefan Hinz, iConnect (Berlin)
Subject: Re: An Idea
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan --
...and then Stefan Hinz, iConnect (Berlin) said...
%
% David
On 12/31/02 8:11 PM, JamesD [EMAIL PROTECTED] wrote:
lists work, and faq's work, some like to call...etc.
personally, I'd prefer a search engine style...
like google, but only for mySQL topics, and with
a visible list of most popular search terms.
something that can be based upon pages of
PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, December 30, 2002 1:18 AM
Subject: RE: An Idea
Hi
My first thought was that the docs on mysql.com should do the job,
but,
although they answer most technical questions, often more down to
earth
stuff like 'How do I store images' or 'how do I get
Hello.
On Sun 2002-12-29 at 11:26:01 +0100, [EMAIL PROTECTED] wrote:
Hello,
I had a problem few days ago. I'm doing my questbook, and I were thinking
what would hapen if I delete some row. Now I know, nothing. I had one column
ID (auto_increment) in my table. I wanted it to be one by one even
On Sunday 29 December 2002 12:26, Adam Wiêckowski wrote:
I had a problem few days ago. I'm doing my questbook, and I were thinking
what would hapen if I delete some row. Now I know, nothing. I had one
column ID (auto_increment) in my table. I wanted it to be one by one even
after deleting, so
At 11:26 +0100 12/29/02, Adam Wi´ckowski wrote:
Hello,
I had a problem few days ago. I'm doing my questbook, and I were thinking
what would hapen if I delete some row. Now I know, nothing. I had one column
ID (auto_increment) in my table. I wanted it to be one by one
Why?
even after
At 11:26 AM 12/29/2002 +0100, =?iso-8859-2?Q?Adam_Wi=EAckowski?= wrote:
Hello,
I had a problem few days ago. I'm doing my questbook, and I were thinking
what would hapen if I delete some row. Now I know, nothing. I had one column
ID (auto_increment) in my table. I wanted it to be one by one even
To: Adam Wi´ckowski; [EMAIL PROTECTED]
Subject: Re: An Idea
Why?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
On Sun, Dec 29, 2002 at 11:43:35AM -0500, Michael She wrote:
BTW, does MySQL have a RowNumber function?
You can use variables:
select @a := 0; select id, more, fields, @a:= @a + 1 as rownumber from whatever;
But you cannot use that number in the where part.
Good luck.
(sql, etc)
--
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Cal Evans [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 6:00 PM
Subject: RE: An Idea
Because
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: Cal Evans [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]; Adam Wi´ckowski
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 6:00 PM
Subject: RE: An Idea
, iConnect (Berlin); Cal Evans; Paul DuBois; Adam
Wi´ckowski; [EMAIL PROTECTED]
Subject: RE: An Idea
Hi
My first thought was that the docs on mysql.com should do the job, but,
although they answer most technical questions, often more down to earth
stuff like 'How do I store images' or 'how do I get
tel. 0121-242-1473
International +44-121-242-1473
---
-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: 30 December 2002 01:35
To: Peter Lovatt; [EMAIL PROTECTED]
Subject: RE: An Idea
while Paul probably wouldnt say it, I would
* http://www.calevans.com
*
-Original Message-
From: JamesD [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 7:35 PM
To: Peter Lovatt; [EMAIL PROTECTED]
Subject: RE: An Idea
while Paul probably wouldnt say it, I would:
his book: MySql and Perl for the Web ISBN 0-7357-1054-6 New
we are all in sales, 24/7. :-)
Jim
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 9:24 PM
To: JamesD; Peter Lovatt; [EMAIL PROTECTED]
Subject: RE: An Idea (really: MySQL and Perl for the Web)
At 17:35 -0800 12/29/02, JamesD wrote:
while
:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 4:18 PM
To: Stefan Hinz, iConnect (Berlin); Cal Evans; Paul DuBois; Adam
Wi´ckowski; [EMAIL PROTECTED]
Subject: RE: An Idea
Hi
My first thought was that the docs on mysql.com should do the job, but,
although they answer most technical questions, often
Hi!
Ken == Ken Menzel [EMAIL PROTECTED] writes:
Ken Hi Monty and Sasha,
Ken Just a quick not to say that's such a great idea that Monty even
Ken thought of it before! Monty and I discussed this last September, I
Ken hope we could get something like this in 4.1
Ken Just a vote!
I have
]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, March 06, 2002 8:42 PM
Subject: Re: Feature idea inspired by bug report
On Wednesday 06 March 2002 04:35 am, Michael Widenius wrote:
Instead of disabling disk based temp tables, we could instead
restrict the
size
On Wednesday 06 March 2002 04:35 am, Michael Widenius wrote:
Instead of disabling disk based temp tables, we could instead restrict the
size of them which should be equally good. ?(By setting the disk size
to 0 you would be able to disable them, but we should not recommend
this setting).
On Mon, Mar 04, 2002 at 07:12:32PM -0700, Sasha Pachev wrote:
On Monday 04 March 2002 02:41 pm, Vladimir V. Kolpakov wrote:
--
P.S. so far, it's helpful bug: I use it as catch
for poor queries!:)
This actually gives me an idea for a
feature. --disable-disk-temp-tables - fail all
41 matches
Mail list logo