Re: New Idea

2003-06-16 Thread Becoming Digital
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

Re: RE: FAQ hosting site (was Re: An Idea) (fwd)

2003-01-02 Thread Boyd Lynn Gerber
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

Re: FAQ hosting site (was Re: An Idea)

2003-01-02 Thread Bruce Lewis
(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

Re: FAQ hosting site (was Re: An Idea)

2003-01-02 Thread Bruce Lewis
(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

Re: An Idea

2003-01-02 Thread Michael T. Babcock
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

Re: An Idea

2003-01-01 Thread Stefan Hinz, iConnect \(Berlin\)
- 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

Re: An Idea

2003-01-01 Thread Stefan Hinz, iConnect \(Berlin\)
- 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

Re: FAQ hosting site (was Re: An Idea)

2003-01-01 Thread David T-G
-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.

RE: An Idea

2003-01-01 Thread JamesD
-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

Re: FAQ hosting site (was Re: An Idea)

2003-01-01 Thread Stefan Hinz, iConnect \(Berlin\)
: 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

RE: FAQ hosting site (was Re: An Idea)

2003-01-01 Thread B. van Ouwerkerk
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

RE: FAQ hosting site (was Re: An Idea)

2003-01-01 Thread Peter Lovatt
(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

RE: FAQ hosting site (was Re: An Idea)

2003-01-01 Thread mnbv
--- -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

RE: FAQ hosting site (was Re: An Idea)

2003-01-01 Thread Peter Lovatt
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

Re: FAQ hosting site (was Re: An Idea)

2003-01-01 Thread Jeremy Zawodny
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 |

RE: FAQ hosting site (was Re: An Idea)

2003-01-01 Thread Peter Lovatt
[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

RE: FAQ hosting site (was Re: An Idea)

2003-01-01 Thread Dan Goodes
--- -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

Re: An Idea

2002-12-31 Thread David T-G
-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

RE: An Idea

2002-12-31 Thread Peter Lovatt
- 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

Re: An Idea

2002-12-31 Thread Stefan Hinz, iConnect \(Berlin\)
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

Re: An Idea

2002-12-31 Thread David T-G
-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

RE: An Idea

2002-12-31 Thread JamesD
-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

Re: An Idea

2002-12-31 Thread R. Hannes Niedner
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

Re: An Idea

2002-12-30 Thread Stefan Hinz, iConnect \(Berlin\)
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

Re: An Idea

2002-12-29 Thread Benjamin Pflugmann
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

re: An Idea

2002-12-29 Thread Egor Egorov
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

Re: An Idea

2002-12-29 Thread Paul DuBois
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

Re: An Idea

2002-12-29 Thread Michael She
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

RE: An Idea

2002-12-29 Thread Cal Evans
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

Re: An Idea

2002-12-29 Thread harm
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) --

Re: An Idea

2002-12-29 Thread Stefan Hinz, iConnect \(Berlin\)
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

RE: An Idea

2002-12-29 Thread Peter Lovatt
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

RE: An Idea

2002-12-29 Thread JamesD
, 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

RE: An Idea

2002-12-29 Thread Peter Lovatt
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

RE: An Idea

2002-12-29 Thread Cal Evans
* 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

RE: An Idea (really: MySQL and Perl for the Web)

2002-12-29 Thread JamesD
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

RE: An Idea (really: MySQL and Perl for the Web)

2002-12-29 Thread Paul DuBois
:[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

Re: Re: Feature idea inspired by bug report

2002-03-12 Thread Michael Widenius
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

Re: Feature idea inspired by bug report

2002-03-07 Thread Ken Menzel
] 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

Re: Feature idea inspired by bug report

2002-03-06 Thread Sasha Pachev
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).

Re: Feature idea inspired by bug report

2002-03-04 Thread Jeremy Zawodny
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