Re: An Idea

[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 gives me generic SQL responses regarding 
many products (often MS SQL Server, since they decided to use the lone 
word 'sql' in its name).

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

[Bruce Lewis]

Why not try Tek-Tips?  Maybe they will sponsor something for free.  They may
have everything you need.

Just a thought.

[EMAIL PROTECTED] <[EMAIL PROTECTED]>

Bruce


- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Peter Lovatt" <[EMAIL PROTECTED]>
Cc: "Stefan Hinz, iConnect (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 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 |  Perl, Web, MySQL, Linux Magazine, Yahoo!
> <[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/
>
> MySQL 3.23.51: up 17 days, processed 617,666,871 queries (401/sec. avg)
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

[Bruce Lewis]

Yes, you need to specify the IP address that you plan on using for this
process instead of the computer name.

If you use Windows, chances are your using MYODBC or some other similar
driver.

Case #1: You setup a DSN in the ODBC area of the OS
Case #2" You setup a DSN-less connection to your db.

Case #2 has actually worked much faster for me.  You can just put the IP in
your connection code and off you go.

Either way, you need to do this because the OS cannot resolve how you want
it done.  Just to make sure it is two NIC's that is causing your problem,
disable one in the IP configuration area and give it a try.  If you still
cannot connect to your db, then something else may also be wrong.


Bruce




- Original Message -
From: "Peter Lovatt" <[EMAIL PROTECTED]>
To: "mnbv" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 01, 2003 6:25 PM
Subject: RE: FAQ hosting site (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
> ---
> Sunmaia
> Birmingham
> UK
> www.sunmaia.net
> tel. 0121-242-1473
> International +44-121-242-1473
> ---
>
> -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 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 has 2 nics (2 ips set up).
>
> Does anyone know a solution for this?
>
>
> --- Peter Lovatt <[EMAIL PROTECTED]> wrote:
> > Hi
> >
> > Like the look of the way its taking shape.
> >
> > I am not sure if there is existing faq software
> > (I've checked sourceforge
> > and freshmeat without much luck) we could use, or if
> > someone can do a better
> > job :) but I have a content management system
> > written, together with a lot
> > of the search functionality needed for the faq. It
> > can mix database stored
> > content with static content, so it would probably do
> > the job with a little
> > work. It also does the membership
> > authorisation/management.
> >
> > I'd be happy to build the software, if that helps.
> >
> > Let me know
> >
> > Peter
> >
> > ---
> > Excellence in internet and open source software
> > -----------
> > Sunmaia
> > Birmingham
> > UK
> > www.sunmaia.net
> > tel. 0121-242-1473
> > International +44-121-242-1473
> > ---
> >
> > -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.  Look for
> > mysql.justpickone.org to be
> > in
> > > the DNS tables by tomorrow.  By then the
> > [EMAIL PROTECTED]
> > > mailing list will be ready for subscriptions, too.
> >
> > Fine. http://mysql.justpickone.org/ works :)
> >
> > > Now, what do we need to do to be able to update
> > this FAQ?  I can't
> > create
> > > ssh accounts for everyone, but we might arrange
> > ftp
> >
> > Let's set up a PHP thing with MySQL. That's quite
> > fast and easy to do. I
> > could contribute some code.
> >
> > My suggestions (database design):
> >
> > 1. We need an authors table, and everyone who wants
> > to be an author
> > (contributor) can mail you, and you will set up
> > accounts for these
> > persons. The authors table will, of course, be used
> > for database
> > authentification / to update the admin pages.
> >
> > 2. For the actual content, we will need only one
> > table, with question
> > (varchar), answer (text), timestamp and a couple of
> > id's that refer to

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

[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 point in reinventing the wheel.

I prefer FAQ-O-Matic.

http://faqomatic.sourceforge.net/faq.pl

Good Luck,

--
Boyd Gerber <[EMAIL PROTECTED]>
ZENEZ1042 East Fort Union #135, Midvale Utah  84047




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

[Dan Goodes]

The "111" is the error code that MySQL generates.

Check if your computer has a firewall, and make sure to enable port 3306 
from external IPs

e.g. on redhat using ipchains-based firewall, add:

-A input -s 0/0 -d 0/0 3306 -p tcp -y -j ACCEPT

to your /etc/sysconfig/ipchains file (or however the box is configured for 
the firewall). You'll also want to replace "-s 0/0" with something a 
little more restrictive.

cheers.. Dan

On Thu, 2 Jan 2003, Peter Lovatt wrote:

> 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
> ---
> Sunmaia
> Birmingham
> UK
> www.sunmaia.net
> tel. 0121-242-1473
> International +44-121-242-1473
> ---
> 
> -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 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 has 2 nics (2 ips set up).
> 
> Does anyone know a solution for this?
> 
> 
> --- Peter Lovatt <[EMAIL PROTECTED]> wrote:
> > Hi
> >
> > Like the look of the way its taking shape.
> >
> > I am not sure if there is existing faq software
> > (I've checked sourceforge
> > and freshmeat without much luck) we could use, or if
> > someone can do a better
> > job :) but I have a content management system
> > written, together with a lot
> > of the search functionality needed for the faq. It
> > can mix database stored
> > content with static content, so it would probably do
> > the job with a little
> > work. It also does the membership
> > authorisation/management.
> >
> > I'd be happy to build the software, if that helps.
> >
> > Let me know
> >
> > Peter
> >
> > ---
> > Excellence in internet and open source software
> > ---
> > Sunmaia
> > Birmingham
> > UK
> > www.sunmaia.net
> > tel. 0121-242-1473
> > International +44-121-242-1473
> > ---
> >
> > -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.  Look for
> > mysql.justpickone.org to be
> > in
> > > the DNS tables by tomorrow.  By then the
> > [EMAIL PROTECTED]
> > > mailing list will be ready for subscriptions, too.
> >
> > Fine. http://mysql.justpickone.org/ works :)
> >
> > > Now, what do we need to do to be able to update
> > this FAQ?  I can't
> > create
> > > ssh accounts for everyone, but we might arrange
> > ftp
> >
> > Let's set up a PHP thing with MySQL. That's quite
> > fast and easy to do. I
> > could contribute some code.
> >
> > My suggestions (database design):
> >
> > 1. We need an authors table, and everyone who wants
> > to be an author
> > (contributor) can mail you, and you will set up
> > accounts for these
> > persons. The authors table will, of course, be used
> > for database
> > authentification / to update the admin pages.
> >
> > 2. For the actual content, we will need only one
> > table, with question
> > (varchar), answer (text), timestamp and a couple of
> > id's that refer to
> > other tables.
> >
> > 3. For the beginning, I would suggest we only have
> > two more tables:
> > category (installation, privilege system, ...,
> > generally speaking, the
> > main chapters of the manual) and difficulty
> > (beginner, advanced,
> > expert). _Not_ to be edited by the authors, to keep
> > the FAQ smooth and
> > simple.
> >
> > - We can make this more complex when necessity
>

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

[Peter Lovatt]

Hi

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 point in reinventing the wheel.

Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---

-Original Message-
From: Jeremy 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 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 |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 17 days, processed 617,666,871 queries (401/sec. avg)



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

[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 |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 17 days, processed 617,666,871 queries (401/sec. avg)

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

[Peter Lovatt]

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
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---

-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 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 has 2 nics (2 ips set up).

Does anyone know a solution for this?


--- Peter Lovatt <[EMAIL PROTECTED]> wrote:
> Hi
>
> Like the look of the way its taking shape.
>
> I am not sure if there is existing faq software
> (I've checked sourceforge
> and freshmeat without much luck) we could use, or if
> someone can do a better
> job :) but I have a content management system
> written, together with a lot
> of the search functionality needed for the faq. It
> can mix database stored
> content with static content, so it would probably do
> the job with a little
> work. It also does the membership
> authorisation/management.
>
> I'd be happy to build the software, if that helps.
>
> Let me know
>
> Peter
>
> ---
> Excellence in internet and open source software
> ---
> Sunmaia
> Birmingham
> UK
> www.sunmaia.net
> tel. 0121-242-1473
> International +44-121-242-1473
> ---
>
> -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.  Look for
> mysql.justpickone.org to be
> in
> > the DNS tables by tomorrow.  By then the
> [EMAIL PROTECTED]
> > mailing list will be ready for subscriptions, too.
>
> Fine. http://mysql.justpickone.org/ works :)
>
> > Now, what do we need to do to be able to update
> this FAQ?  I can't
> create
> > ssh accounts for everyone, but we might arrange
> ftp
>
> Let's set up a PHP thing with MySQL. That's quite
> fast and easy to do. I
> could contribute some code.
>
> My suggestions (database design):
>
> 1. We need an authors table, and everyone who wants
> to be an author
> (contributor) can mail you, and you will set up
> accounts for these
> persons. The authors table will, of course, be used
> for database
> authentification / to update the admin pages.
>
> 2. For the actual content, we will need only one
> table, with question
> (varchar), answer (text), timestamp and a couple of
> id's that refer to
> other tables.
>
> 3. For the beginning, I would suggest we only have
> two more tables:
> category (installation, privilege system, ...,
> generally speaking, the
> main chapters of the manual) and difficulty
> (beginner, advanced,
> expert). _Not_ to be edited by the authors, to keep
> the FAQ smooth and
> simple.
>
> - We can make this more complex when necessity
> comes, with ratings,
> automated checks for double entries etc.
>
> My suggestions (frontend):
>
> 1. For end users, a very simple search. As Jim
> (JamesD) pointed out,
> Alkaline could do the job. Then again, Alkaline will
> search (and before,
> index) documents, and not databases. For the
> beginning, I would prefer
> just a simple input box for the search.
>
> 2. Output preferably as html files, i.e. nothing
> like
>
"index.php?cat=installation&difficulty=beginner&searchterm=windows",
> but
> rather something like
> "/installation/beginner/windows/1.html". IMHO,
> this is easier to refer to in a mailing list, and
> easier to click. Maybe
> we can set up Alkaline on those html files, as an
> alternative search for
> the database search.
>
> 3. Authors should be instructed to first search via
> the end user
> interface before inserting a new entry. If they do
> want to insert
> something new, they should simply select category,
> difficulty, paste the
> question, type (or paste) the answer.
>
> 4. The author login shoul

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

[mnbv]

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 has 2 nics (2 ips set up).

Does anyone know a solution for this? 


--- Peter Lovatt <[EMAIL PROTECTED]> wrote:
> Hi
> 
> Like the look of the way its taking shape.
> 
> I am not sure if there is existing faq software
> (I've checked sourceforge
> and freshmeat without much luck) we could use, or if
> someone can do a better
> job :) but I have a content management system
> written, together with a lot
> of the search functionality needed for the faq. It
> can mix database stored
> content with static content, so it would probably do
> the job with a little
> work. It also does the membership
> authorisation/management.
> 
> I'd be happy to build the software, if that helps.
> 
> Let me know
> 
> Peter
> 
> ---
> Excellence in internet and open source software
> ---
> Sunmaia
> Birmingham
> UK
> www.sunmaia.net
> tel. 0121-242-1473
> International +44-121-242-1473
> ---
> 
> -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.  Look for
> mysql.justpickone.org to be
> in
> > the DNS tables by tomorrow.  By then the
> [EMAIL PROTECTED]
> > mailing list will be ready for subscriptions, too.
> 
> Fine. http://mysql.justpickone.org/ works :)
> 
> > Now, what do we need to do to be able to update
> this FAQ?  I can't
> create
> > ssh accounts for everyone, but we might arrange
> ftp
> 
> Let's set up a PHP thing with MySQL. That's quite
> fast and easy to do. I
> could contribute some code.
> 
> My suggestions (database design):
> 
> 1. We need an authors table, and everyone who wants
> to be an author
> (contributor) can mail you, and you will set up
> accounts for these
> persons. The authors table will, of course, be used
> for database
> authentification / to update the admin pages.
> 
> 2. For the actual content, we will need only one
> table, with question
> (varchar), answer (text), timestamp and a couple of
> id's that refer to
> other tables.
> 
> 3. For the beginning, I would suggest we only have
> two more tables:
> category (installation, privilege system, ...,
> generally speaking, the
> main chapters of the manual) and difficulty
> (beginner, advanced,
> expert). _Not_ to be edited by the authors, to keep
> the FAQ smooth and
> simple.
> 
> - We can make this more complex when necessity
> comes, with ratings,
> automated checks for double entries etc.
> 
> My suggestions (frontend):
> 
> 1. For end users, a very simple search. As Jim
> (JamesD) pointed out,
> Alkaline could do the job. Then again, Alkaline will
> search (and before,
> index) documents, and not databases. For the
> beginning, I would prefer
> just a simple input box for the search.
> 
> 2. Output preferably as html files, i.e. nothing
> like
>
"index.php?cat=installation&difficulty=beginner&searchterm=windows",
> but
> rather something like
> "/installation/beginner/windows/1.html". IMHO,
> this is easier to refer to in a mailing list, and
> easier to click. Maybe
> we can set up Alkaline on those html files, as an
> alternative search for
> the database search.
> 
> 3. Authors should be instructed to first search via
> the end user
> interface before inserting a new entry. If they do
> want to insert
> something new, they should simply select category,
> difficulty, paste the
> question, type (or paste) the answer.
> 
> 4. The author login should be extremely convenient,
> with a persistent
> cookie, so an author will not actually have to login
> more than once
> (from the same browser/machine).
> 
> 5. An author should be able to insert new content
> and to update his /
> her own content, nothing else.
> 
> - What I said about database design applies to the
> frontend, too. We can
> make it more complex later on, when the need arises.
> We can have user
> contributed notes, fine grained search criteria,
> etc. In the beginning,
> I would suggest to follow the KISS principle (keep
> it simple & stupid).
> 

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

[Peter Lovatt]

Hi

Like the look of the way its taking shape.

I am not sure if there is existing faq software (I've checked sourceforge
and freshmeat without much luck) we could use, or if someone can do a better
job :) but I have a content management system written, together with a lot
of the search functionality needed for the faq. It can mix database stored
content with static content, so it would probably do the job with a little
work. It also does the membership authorisation/management.

I'd be happy to build the software, if that helps.

Let me know

Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---

-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.  Look for mysql.justpickone.org to be
in
> the DNS tables by tomorrow.  By then the
[EMAIL PROTECTED]
> mailing list will be ready for subscriptions, too.

Fine. http://mysql.justpickone.org/ works :)

> Now, what do we need to do to be able to update this FAQ?  I can't
create
> ssh accounts for everyone, but we might arrange ftp

Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I
could contribute some code.

My suggestions (database design):

1. We need an authors table, and everyone who wants to be an author
(contributor) can mail you, and you will set up accounts for these
persons. The authors table will, of course, be used for database
authentification / to update the admin pages.

2. For the actual content, we will need only one table, with question
(varchar), answer (text), timestamp and a couple of id's that refer to
other tables.

3. For the beginning, I would suggest we only have two more tables:
category (installation, privilege system, ..., generally speaking, the
main chapters of the manual) and difficulty (beginner, advanced,
expert). _Not_ to be edited by the authors, to keep the FAQ smooth and
simple.

- We can make this more complex when necessity comes, with ratings,
automated checks for double entries etc.

My suggestions (frontend):

1. For end users, a very simple search. As Jim (JamesD) pointed out,
Alkaline could do the job. Then again, Alkaline will search (and before,
index) documents, and not databases. For the beginning, I would prefer
just a simple input box for the search.

2. Output preferably as html files, i.e. nothing like
"index.php?cat=installation&difficulty=beginner&searchterm=windows", but
rather something like "/installation/beginner/windows/1.html". IMHO,
this is easier to refer to in a mailing list, and easier to click. Maybe
we can set up Alkaline on those html files, as an alternative search for
the database search.

3. Authors should be instructed to first search via the end user
interface before inserting a new entry. If they do want to insert
something new, they should simply select category, difficulty, paste the
question, type (or paste) the answer.

4. The author login should be extremely convenient, with a persistent
cookie, so an author will not actually have to login more than once
(from the same browser/machine).

5. An author should be able to insert new content and to update his /
her own content, nothing else.

- What I said about database design applies to the frontend, too. We can
make it more complex later on, when the need arises. We can have user
contributed notes, fine grained search criteria, etc. In the beginning,
I would suggest to follow the KISS principle (keep it simple & stupid).

I send this to the list, because

a) maybe someone has written exactly what we want, or can give a URL to
where to find it,

b) maybe someone has better ideas or comments on this.

> By then the [EMAIL PROTECTED]
> mailing list will be ready for subscriptions, too.

Great. We should discuss everything else via this list, then.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: "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, iConnect (Berlin) said...
> %
> % David,
> %
> % > see it dropped if they don't jump on it at the start.
> %

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

[B. van Ouwerkerk]

I'm not following this threath.. but..

Use PHP to fetch mail from a mailbox, insert all questions into a database.

Create a searchtool to search the database.

No need to have way to many ppl as author. If you want you could have some
ppl maintaining a list of keywords per question or remove a question from
the database..

If you really persist to create something of your own you shouldn't create
catagories. Most ppl don't really understand under which catagory their
question could be found. Those who do will probably find an answer much
quicker using google.



--B.

-Oorspronkelijk 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 by tomorrow.  By then the
[EMAIL PROTECTED]
> mailing list will be ready for subscriptions, too.

Fine. http://mysql.justpickone.org/ works :)

> Now, what do we need to do to be able to update this FAQ?  I can't
create
> ssh accounts for everyone, but we might arrange ftp

Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I
could contribute some code.

My suggestions (database design):

1. We need an authors table, and everyone who wants to be an author
(contributor) can mail you, and you will set up accounts for these
persons. The authors table will, of course, be used for database
authentification / to update the admin pages.

2. For the actual content, we will need only one table, with question
(varchar), answer (text), timestamp and a couple of id's that refer to
other tables.

3. For the beginning, I would suggest we only have two more tables:
category (installation, privilege system, ..., generally speaking, the
main chapters of the manual) and difficulty (beginner, advanced,
expert). _Not_ to be edited by the authors, to keep the FAQ smooth and
simple.

- We can make this more complex when necessity comes, with ratings,
automated checks for double entries etc.

My suggestions (frontend):

1. For end users, a very simple search. As Jim (JamesD) pointed out,
Alkaline could do the job. Then again, Alkaline will search (and before,
index) documents, and not databases. For the beginning, I would prefer
just a simple input box for the search.

2. Output preferably as html files, i.e. nothing like
"index.php?cat=installation&difficulty=beginner&searchterm=windows", but
rather something like "/installation/beginner/windows/1.html". IMHO,
this is easier to refer to in a mailing list, and easier to click. Maybe
we can set up Alkaline on those html files, as an alternative search for
the database search.

3. Authors should be instructed to first search via the end user
interface before inserting a new entry. If they do want to insert
something new, they should simply select category, difficulty, paste the
question, type (or paste) the answer.

4. The author login should be extremely convenient, with a persistent
cookie, so an author will not actually have to login more than once
(from the same browser/machine).

5. An author should be able to insert new content and to update his /
her own content, nothing else.

- What I said about database design applies to the frontend, too. We can
make it more complex later on, when the need arises. We can have user
contributed notes, fine grained search criteria, etc. In the beginning,
I would suggest to follow the KISS principle (keep it simple & stupid).

I send this to the list, because

a) maybe someone has written exactly what we want, or can give a URL to
where to find it,

b) maybe someone has better ideas or comments on this.

> By then the [EMAIL PROTECTED]
> mailing list will be ready for subscriptions, too.

Great. We should discuss everything else via this list, then.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: "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, 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.  Look for mysql.justpickone.org to be
in
> the DNS tables by tomorrow.  By then the
[EMAIL PROTECTED]
> mailing

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

[Stefan Hinz, iConnect \(Berlin\)]

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 will be ready for subscriptions, too.

Fine. http://mysql.justpickone.org/ works :)

> Now, what do we need to do to be able to update this FAQ?  I can't
create
> ssh accounts for everyone, but we might arrange ftp

Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I
could contribute some code.

My suggestions (database design):

1. We need an authors table, and everyone who wants to be an author
(contributor) can mail you, and you will set up accounts for these
persons. The authors table will, of course, be used for database
authentification / to update the admin pages.

2. For the actual content, we will need only one table, with question
(varchar), answer (text), timestamp and a couple of id's that refer to
other tables.

3. For the beginning, I would suggest we only have two more tables:
category (installation, privilege system, ..., generally speaking, the
main chapters of the manual) and difficulty (beginner, advanced,
expert). _Not_ to be edited by the authors, to keep the FAQ smooth and
simple.

- We can make this more complex when necessity comes, with ratings,
automated checks for double entries etc.

My suggestions (frontend):

1. For end users, a very simple search. As Jim (JamesD) pointed out,
Alkaline could do the job. Then again, Alkaline will search (and before,
index) documents, and not databases. For the beginning, I would prefer
just a simple input box for the search.

2. Output preferably as html files, i.e. nothing like
"index.php?cat=installation&difficulty=beginner&searchterm=windows", but
rather something like "/installation/beginner/windows/1.html". IMHO,
this is easier to refer to in a mailing list, and easier to click. Maybe
we can set up Alkaline on those html files, as an alternative search for
the database search.

3. Authors should be instructed to first search via the end user
interface before inserting a new entry. If they do want to insert
something new, they should simply select category, difficulty, paste the
question, type (or paste) the answer.

4. The author login should be extremely convenient, with a persistent
cookie, so an author will not actually have to login more than once
(from the same browser/machine).

5. An author should be able to insert new content and to update his /
her own content, nothing else.

- What I said about database design applies to the frontend, too. We can
make it more complex later on, when the need arises. We can have user
contributed notes, fine grained search criteria, etc. In the beginning,
I would suggest to follow the KISS principle (keep it simple & stupid).

I send this to the list, because

a) maybe someone has written exactly what we want, or can give a URL to
where to find it,

b) maybe someone has better ideas or comments on this.

> By then the [EMAIL PROTECTED]
> mailing list will be ready for subscriptions, too.

Great. We should discuss everything else via this list, then.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: "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, 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.  Look for mysql.justpickone.org to be
in
> the DNS tables by tomorrow.  By then the
[EMAIL PROTECTED]
> mailing list will be ready for subscriptions, too.
>
> Now, what do we need to do to be able to update this FAQ?  I can't
create
> ssh accounts for everyone, but we might arrange ftp (I wish we could
sftp
> without then also having ssh; darn) and, meanwhile, it seems like this
> should be the sort of thing where we could either use CVS or a web
update
> form or the like...  Maybe a wiki will do for now, but I don't like
only
> being able to get at it from the web :-)  Anyone have any thoughts?
>
>
> % your website, especially the PIX :-)
>
> Thanks! :-)  It needs an overhaul, but it gets the job done.
>
>
> %
> % Regards,
> % --
> %   Stefan Hinz <[EMAIL PROTECTED]>
> %   Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
> %   H

RE: An Idea

[JamesD]

alkaline has been around awhile. the model is similiar
to mysql in that they have a commercial version that sustains them,
and a free version that sustains the rest of us.

there is not a doubt that its better than the php script you refer to
below...

http://alkaline.vestris.com/docs/alkaline-faq/af-general.html#AF-GEN-WHY

its claim is very high speed searching, partial word searching,
multiple remote site indexing and spidering etc.
good for high speed results on a document set of 500,000 pages or so.

with a list of mysql urls to spider and index, it can be setup and live,
fast.

Jim

-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 web pages
> using Htdig or alkaline or something...

Do these tools work better that the search tool (Mnogo search) at
http://lists.mysql.com/php/search.php? This thing sucks - I was looking
for "mysql_fix_privilege_tables", and it found nothing!

> Guten Rutsch

Danke, Dir auch!

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
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 and help are,
> many people have circumstances that make it more
> efficient to push the question into the queue, and wait
> for an answer to pop back later.
>
> 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 htm and
> emails that exists, and that can sit under a few web pages
> using Htdig or alkaline or something...
>
> Guten Rutsch
>
> Jim
>
> -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,
> %
> % 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 place
> % wouldn't be half as good.
>
> Oh, to be sure.  And maybe we could even get the mysql.com folks to
> prominently list a pointer to the off-site FAQ if they don't want to
> maintain it or give out accounts to maintain it.  I just wouldn't want
to
> see it dropped if they don't jump on it at the start.
>
>
> HAND & Happy New Year
>
> mysql query,
> :-D
> - --
> David T-G  * There is too much animal courage in
> (play) [EMAIL PROTECTED] * society and not sufficient moral
courage.
> (work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and
Health"
> http://justpickone.org/davidtg/  Shpx gur Pbzzhavpngvbaf Qrprapl
Npg!
>
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.0.7 (FreeBSD)
>
> iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV
> tC44gsIMkjgUkNtZlkpZ+Y0=
> =XS30
> -END PGP SIGNATURE-
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the m

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

[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.  Look for mysql.justpickone.org to be in
the DNS tables by tomorrow.  By then the [EMAIL PROTECTED]
mailing list will be ready for subscriptions, too.

Now, what do we need to do to be able to update this FAQ?  I can't create
ssh accounts for everyone, but we might arrange ftp (I wish we could sftp
without then also having ssh; darn) and, meanwhile, it seems like this
should be the sort of thing where we could either use CVS or a web update
form or the like...  Maybe a wiki will do for now, but I don't like only
being able to get at it from the web :-)  Anyone have any thoughts?


% your website, especially the PIX :-)

Thanks! :-)  It needs an overhaul, but it gets the job done.


% 
% Regards,
% --
%   Stefan Hinz <[EMAIL PROTECTED]>
%   Geschäftsführer / CEO iConnect GmbH 
%   Heesestr. 6, 12169 Berlin (Germany)
%   Tel: +49 30 7970948-0  Fax: +49 30 7970948-3


HTH & HAND & HNY

:-D
- -- 
David T-G  * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/  Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+EwVbGb7uCXufRwARAmHWAJ9j2Zd/syBro07AQ5hj0n7lAeeFMACfYch+
QFYwxXNLMvUSbTYxxp2JQOE=
=g9Q2
-END PGP SIGNATURE-

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

[Stefan Hinz, iConnect \(Berlin\)]

James,

> something that can be based upon pages of htm and
> emails that exists, and that can sit under a few web pages
> using Htdig or alkaline or something...

Do these tools work better that the search tool (Mnogo search) at
http://lists.mysql.com/php/search.php? This thing sucks - I was looking
for "mysql_fix_privilege_tables", and it found nothing!

> Guten Rutsch

Danke, Dir auch!

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
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 and help are,
> many people have circumstances that make it more
> efficient to push the question into the queue, and wait
> for an answer to pop back later.
>
> 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 htm and
> emails that exists, and that can sit under a few web pages
> using Htdig or alkaline or something...
>
> Guten Rutsch
>
> Jim
>
> -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,
> %
> % 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 place
> % wouldn't be half as good.
>
> Oh, to be sure.  And maybe we could even get the mysql.com folks to
> prominently list a pointer to the off-site FAQ if they don't want to
> maintain it or give out accounts to maintain it.  I just wouldn't want
to
> see it dropped if they don't jump on it at the start.
>
>
> HAND & Happy New Year
>
> mysql query,
> :-D
> - --
> David T-G  * There is too much animal courage in
> (play) [EMAIL PROTECTED] * society and not sufficient moral
courage.
> (work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and
Health"
> http://justpickone.org/davidtg/  Shpx gur Pbzzhavpngvbaf Qrprapl
Npg!
>
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.0.7 (FreeBSD)
>
> iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV
> tC44gsIMkjgUkNtZlkpZ+Y0=
> =XS30
> -END PGP SIGNATURE-
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

[Stefan Hinz, iConnect \(Berlin\)]

David,

> Oh, to be sure.  And maybe we could even get the mysql.com folks to
> prominently list a pointer to the off-site FAQ if they don't want to
> maintain it or give out accounts to maintain it.  I just wouldn't want
to
> 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
your website, especially the PIX :-)

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
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...
> %
> % 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 place
> % wouldn't be half as good.
>
> Oh, to be sure.  And maybe we could even get the mysql.com folks to
> prominently list a pointer to the off-site FAQ if they don't want to
> maintain it or give out accounts to maintain it.  I just wouldn't want
to
> see it dropped if they don't jump on it at the start.
>
>
> HAND & Happy New Year
>
> mysql query,
> :-D
> - --
> David T-G  * There is too much animal courage in
> (play) [EMAIL PROTECTED] * society and not sufficient moral
courage.
> (work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and
Health"
> http://justpickone.org/davidtg/  Shpx gur Pbzzhavpngvbaf Qrprapl
Npg!
>
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.0.7 (FreeBSD)
>
> iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV
> tC44gsIMkjgUkNtZlkpZ+Y0=
> =XS30
> -END PGP SIGNATURE-


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

[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 htm and
> emails that exists, and that can sit under a few web pages
> using Htdig or alkaline or something...
> 
> Guten Rutsch
> 
> Jim

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.

JM2Cs
/h


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: An Idea

[JamesD]

we find people just like to ask questions,
and no matter how good our FAQ's and help are,
many people have circumstances that make it more
efficient to push the question into the queue, and wait
for an answer to pop back later.

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 htm and
emails that exists, and that can sit under a few web pages
using Htdig or alkaline or something...

Guten Rutsch

Jim

-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,
%
% 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 place
% wouldn't be half as good.

Oh, to be sure.  And maybe we could even get the mysql.com folks to
prominently list a pointer to the off-site FAQ if they don't want to
maintain it or give out accounts to maintain it.  I just wouldn't want to
see it dropped if they don't jump on it at the start.


HAND & Happy New Year

mysql query,
:-D
- --
David T-G  * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/  Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV
tC44gsIMkjgUkNtZlkpZ+Y0=
=XS30
-END PGP SIGNATURE-

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

[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 place
% wouldn't be half as good.

Oh, to be sure.  And maybe we could even get the mysql.com folks to
prominently list a pointer to the off-site FAQ if they don't want to
maintain it or give out accounts to maintain it.  I just wouldn't want to
see it dropped if they don't jump on it at the start.


HAND & Happy New Year

mysql query,
:-D
- -- 
David T-G  * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/  Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV
tC44gsIMkjgUkNtZlkpZ+Y0=
=XS30
-END PGP SIGNATURE-

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

[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 half as good.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH 
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: An Idea

[Peter Lovatt]

Hi

A faq without questions would be  pretty empty!

While you have the questions why not keep a note (or send them to me) Once
we have some momentum we can put some answers and tutorials together.

I thought I would email MySql to see if they like the idea, if not then I
will build it.

Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---

-Original Message-
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 !) I would be prepared to lay the foundations
...
%
% Thanks, I appreciate that. I've been waiting a moment before answering,
% waiting for others to take a deep breath and say "yes", too, but it
% seems you are the only one.

I'd love to contribute, but not only am I very busy but also very new.  I
could probably contribute a lot of *questions*, but this FAQ is probably
meant to also have *answers* :-)


%
% > [James: ] $44.99 SRP  - a low cost compared to the 'deep breath" below
% :-)
%
% I know there are good books, and I especially like Paul's books on
% MySQL. There are good books by German authors on MySQL, too.

I'm happy to hear of it; I may have to go out and pick it up!


%
% But, then again, refering to books will bring up the same sort of
% answers people on this list are complaing about ("hey, stupid, go buy
% book xyz and read it before asking silly questions"). With a FAQ, this

Well, it would be nice to have a listing of readers' favorite and most
helpful books so that newbies know *what* to go and pick out, for one
thing; I don't think that book references are all bad!


% could be "You will find the answer for your question at
% www.mysql.com/faq/answer_xyz.html".

Yes; that's very good.


%
% > So, any thoughts? Where do we go from here?
%
% Nowhere, I suppose :(

Wait; quite on the contrary!  I think that good work can start (granted,
it would probably start faster if I jumped in to contribute more, but...)
right now!


%
% Maybe some of the folks at MySQL AB will read this and come up with a
% database structure for the FAQ on MySQL.com and user accounts for you
% and me (and maybe others, once this thing has started).

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...


%
% Regards,
% --
%   Stefan Hinz <[EMAIL PROTECTED]>
%   Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
%   Heesestr. 6, 12169 Berlin (Germany)
%   Tel: +49 30 7970948-0  Fax: +49 30 7970948-3


HTH & HAND & Happy Holidays

mysql query,
:-D
- --
David T-G  * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and Health"
http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+EXu2Gb7uCXufRwARAq2QAJ49JlM22lxrMndZLWf9BFzRvlrWQgCfU/LP
M/PviclU9pDOmcKXOgmSPp8=
=1os1
-END PGP SIGNATURE-

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

[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 take a deep breath and say "yes", too, but it
% seems you are the only one.

I'd love to contribute, but not only am I very busy but also very new.  I
could probably contribute a lot of *questions*, but this FAQ is probably
meant to also have *answers* :-)


% 
% > [James: ] $44.99 SRP  - a low cost compared to the 'deep breath" below
% :-)
% 
% I know there are good books, and I especially like Paul's books on
% MySQL. There are good books by German authors on MySQL, too.

I'm happy to hear of it; I may have to go out and pick it up!


% 
% But, then again, refering to books will bring up the same sort of
% answers people on this list are complaing about ("hey, stupid, go buy
% book xyz and read it before asking silly questions"). With a FAQ, this

Well, it would be nice to have a listing of readers' favorite and most
helpful books so that newbies know *what* to go and pick out, for one
thing; I don't think that book references are all bad!


% could be "You will find the answer for your question at
% www.mysql.com/faq/answer_xyz.html".

Yes; that's very good.


% 
% > So, any thoughts? Where do we go from here?
% 
% Nowhere, I suppose :(

Wait; quite on the contrary!  I think that good work can start (granted,
it would probably start faster if I jumped in to contribute more, but...)
right now!


% 
% Maybe some of the folks at MySQL AB will read this and come up with a
% database structure for the FAQ on MySQL.com and user accounts for you
% and me (and maybe others, once this thing has started).

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...


% 
% Regards,
% --
%   Stefan Hinz <[EMAIL PROTECTED]>
%   Geschäftsführer / CEO iConnect GmbH 
%   Heesestr. 6, 12169 Berlin (Germany)
%   Tel: +49 30 7970948-0  Fax: +49 30 7970948-3


HTH & HAND & Happy Holidays

mysql query,
:-D
- -- 
David T-G  * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, "Science and Health"
http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+EXu2Gb7uCXufRwARAq2QAJ49JlM22lxrMndZLWf9BFzRvlrWQgCfU/LP
M/PviclU9pDOmcKXOgmSPp8=
=1os1
-END PGP SIGNATURE-

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

[Stefan Hinz, iConnect \(Berlin\)]

Peter,

> So (taking a deep breath !) I would be prepared to lay the foundations
for a
> faq / knowledge base aimed specifically at this type of questions and
to
> manage it.

Thanks, I appreciate that. I've been waiting a moment before answering,
waiting for others to take a deep breath and say "yes", too, but it
seems you are the only one.

> [James: ] $44.99 SRP  - a low cost compared to the 'deep breath" below
:-)

I know there are good books, and I especially like Paul's books on
MySQL. There are good books by German authors on MySQL, too.

But, then again, refering to books will bring up the same sort of
answers people on this list are complaing about ("hey, stupid, go buy
book xyz and read it before asking silly questions"). With a FAQ, this
could be "You will find the answer for your question at
www.mysql.com/faq/answer_xyz.html".

> So, any thoughts? Where do we go from here?

Nowhere, I suppose :(

Maybe some of the folks at MySQL AB will read this and come up with a
database structure for the FAQ on MySQL.com and user accounts for you
and me (and maybe others, once this thing has started).

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

- Original Message -
From: "Peter Lovatt" <[EMAIL PROTECTED]>
To: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>; "Cal
Evans" <[EMAIL PROTECTED]>; "Paul DuBois" <[EMAIL PROTECTED]>; "Adam
Wi´ckowski" <[EMAIL 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 started with SQL'
isn't
> there, or it is difficult to find.
>
> The other problem is that the documentation is often technical to
point that
> it is difficult to understand, even as a reasonably competent database
> programmer. I think newbies (and not so newbies) could feel totally
> overwhelmed by much of it.
>
> So (taking a deep breath !) I would be prepared to lay the foundations
for a
> faq / knowledge base aimed specifically at this type of questions and
to
> manage it.
>
> So, any thoughts? Where do we go from here?
>
> Peter
>
> ---
> Excellence in internet and open source software
> ---
> Sunmaia
> Birmingham
> UK
> www.sunmaia.net
> tel. 0121-242-1473
> International +44-121-242-1473
> ---
>
> -Original Message-
> From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
> Sent: 29 December 2002 22:01
> To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED]
> Subject: Re: An Idea
>
>
> Cal, Paul, dear list,
>
> thank you, Cal, for your wise words ...
>
> > "Here's the FAQ we developed so you don't have to waste our time
> asking
> > questions that have already been answered."
>
> Go to MySQL.com and type "FAQ" in the search box. This will provide 71
> results, some of them with valuable FAQ-like information, but no real
> FAQ.
>
> Instead, we have this in every list mail:
>
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
>
> I would keep this shorter, saying "Believe in God and do not sin" ;-)
>
> But seriously: Anybody here interested in setting up a FAQ on
MySQL.com
> / MySQL.de,
> - with "silly" common questions from this list,
> - and with answers in "small tutorial" format (something like
> http://www.mysql.com/articles/dotnet/index.html),
> - well organized (one person to collect / insert the "silly"
questions),
> - easy to search (only search term + search by category),
> - easy to maintain (e. g. with user comments, like the English
manual),
> - even easier to use as a referer than the MySQL manual when answering
> questions?
>
> Flame me if there _is_ a FAQ like this. At least I didn't find it at
> MySQL.com, which is most probably the first place a new MySQL user
would
> look for it.
>
> I am the German translator of the official MySQL manual, so I could
> offer to translate as much as I can from the FAQ into German.
>
> Regards,
> --
>   Stefan Hinz <[EMAIL PROTECTED]>
>   Geschäftsführer / CEO iConnect GmbH <

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

[Paul DuBois]

At 17:35 -0800 12/29/02, JamesD wrote:

while Paul probably wouldnt say it, I would:


Well, I *have* been known to make shameless plugs from time to time, but
of course it's better if readers make them for me. :-)  So, thanks, I
appreciate it.



his book: "MySql and Perl for the Web" ISBN 0-7357-1054-6 "New Riders
Publishing"
answers the questions you are getting at below, and
IMHO the book is excellent as a "how do i get started..." and more...

$44.99 SRP  - a low cost compared to the 'deep breath" below :-)


I of course appreciate it when people purchase a copy of the book,
but for those who prefer to take a look at part of it first,
I will point out that there is a sample chapter available online
at:

http://www.kitebird.com/mysql-perl/

It's a 78-page PDF, and it deals with a number of questions that probably
would come up in a FAQ, but in more detail.  For example, it answers the
oft-posed questions: how do I store images in MySQL? and how do I retrieve
images from MySQL for display in a Web page?  The sample code that implements
the answers to these questions is also available at the URL above, as are
some sample applications. (One of which is an e-card thing that demonstrates
image retrieval and display.)

I guess that's enough shameless plugging for now. :-)



like any book, to drive through it all the way, inch
by inch, and learn, takes some time and focus.

James Danforth,COO
Neovi Data Corp
www.qchex.com


-Original Message-
From: Peter Lovatt [mailto:[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 more down to earth
stuff like 'How do I store images' or 'how do I get started with SQL' isn't
there, or it is difficult to find.

The other problem is that the documentation is often technical to point that
it is difficult to understand, even as a reasonably competent database
programmer. I think newbies (and not so newbies) could feel totally
overwhelmed by much of it.

So (taking a deep breath !) I would be prepared to lay the foundations for a
faq / knowledge base aimed specifically at this type of questions and to
manage it.

So, any thoughts? Where do we go from here?

Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---




-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

[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 Paul probably wouldnt say it, I would:

Well, I *have* been known to make shameless plugs from time to time, but
of course it's better if readers make them for me. :-)  So, thanks, I
appreciate it.

>
>his book: "MySql and Perl for the Web" ISBN 0-7357-1054-6 "New Riders
>Publishing"
>answers the questions you are getting at below, and
>IMHO the book is excellent as a "how do i get started..." and more...
>
>$44.99 SRP  - a low cost compared to the 'deep breath" below :-)

I of course appreciate it when people purchase a copy of the book,
but for those who prefer to take a look at part of it first,
I will point out that there is a sample chapter available online
at:

http://www.kitebird.com/mysql-perl/

It's a 78-page PDF, and it deals with a number of questions that probably
would come up in a FAQ, but in more detail.  For example, it answers the
oft-posed questions: how do I store images in MySQL? and how do I retrieve
images from MySQL for display in a Web page?  The sample code that
implements
the answers to these questions is also available at the URL above, as are
some sample applications. (One of which is an e-card thing that demonstrates
image retrieval and display.)

I guess that's enough shameless plugging for now. :-)

>
>like any book, to drive through it all the way, inch
>by inch, and learn, takes some time and focus.
>
>James Danforth,COO
>Neovi Data Corp
>www.qchex.com
>
>
>-Original Message-
>From: Peter Lovatt [mailto:[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 more down to earth
>stuff like 'How do I store images' or 'how do I get started with SQL' isn't
>there, or it is difficult to find.
>
>The other problem is that the documentation is often technical to point
that
>it is difficult to understand, even as a reasonably competent database
>programmer. I think newbies (and not so newbies) could feel totally
>overwhelmed by much of it.
>
>So (taking a deep breath !) I would be prepared to lay the foundations for
a
>faq / knowledge base aimed specifically at this type of questions and to
>manage it.
>
>So, any thoughts? Where do we go from here?
>
>Peter
>
>---
>Excellence in internet and open source software
>---
>Sunmaia
>Birmingham
>UK
>www.sunmaia.net
>tel. 0121-242-1473
>International +44-121-242-1473
>---
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: An Idea

[Cal Evans]

Paul's book is an excellent one.

I also recommend (to anyone who asks):
http://froogle.google.com/froogle?q=%22SQL+For+Dummies%22&btnG=Froogle+Searc
h
and
http://froogle.google.com/froogle?q=%22SQL+For+Smarties%22&btnG=Froogle+Sear
ch


2 more excellent resources.

*
* Cal Evans
* The Virtual CIO
* 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 Riders
Publishing"
answers the questions you are getting at below, and
IMHO the book is excellent as a "how do i get started..." and more...

$44.99 SRP  - a low cost compared to the 'deep breath" below :-)

like any book, to drive through it all the way, inch
by inch, and learn, takes some time and focus.

James Danforth,COO
Neovi Data Corp
www.qchex.com


-Original Message-
From: Peter Lovatt [mailto:[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 more down to earth
stuff like 'How do I store images' or 'how do I get started with SQL' isn't
there, or it is difficult to find.

The other problem is that the documentation is often technical to point that
it is difficult to understand, even as a reasonably competent database
programmer. I think newbies (and not so newbies) could feel totally
overwhelmed by much of it.

So (taking a deep breath !) I would be prepared to lay the foundations for a
faq / knowledge base aimed specifically at this type of questions and to
manage it.

So, any thoughts? Where do we go from here?

Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---

-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: 29 December 2002 22:01
To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED]
Subject: Re: An Idea


Cal, Paul, dear list,

thank you, Cal, for your wise words ...

> "Here's the FAQ we developed so you don't have to waste our time
asking
> questions that have already been answered."

Go to MySQL.com and type "FAQ" in the search box. This will provide 71
results, some of them with valuable FAQ-like information, but no real
FAQ.

Instead, we have this in every list mail:

> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)

I would keep this shorter, saying "Believe in God and do not sin" ;-)

But seriously: Anybody here interested in setting up a FAQ on MySQL.com
/ MySQL.de,
- with "silly" common questions from this list,
- and with answers in "small tutorial" format (something like
http://www.mysql.com/articles/dotnet/index.html),
- well organized (one person to collect / insert the "silly" questions),
- easy to search (only search term + search by category),
- easy to maintain (e. g. with user comments, like the English manual),
- even easier to use as a referer than the MySQL manual when answering
questions?

Flame me if there _is_ a FAQ like this. At least I didn't find it at
MySQL.com, which is most probably the first place a new MySQL user would
look for it.

I am the German translator of the official MySQL manual, so I could
offer to translate as much as I can from the FAQ into German.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  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 that's the way that (FoxPro, Access, Paradox, insert name of
> favorite desktop RDBMS here) did it and I can't make the jump to a
real
> server based RDBMS!
>
> Why do you ask?  :)
>
> Seriously, I find this type of issue (not your question Paul, the
original
> question) one of the most troubling things about this list. We as a
> community of SQL developers (regardless of dialect) need to make a
more
> concentrated effort to explain the differences between desktop
databases and
> 

RE: An Idea

[Peter Lovatt]

Hi

I think the two would serve different purposes. Paul's book is a best friend
but.

It may take 2-3 days to get a copy (unless you live in a good technical
bookshop) and often people want an answer now.

Although it's good value, not everyone (casual users, students, newbies
making their first steps) will be able or want to pay over $40 for a
book (though I agree it is good value if you do)

Peter



---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
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:

his book: "MySql and Perl for the Web" ISBN 0-7357-1054-6 "New Riders
Publishing"
answers the questions you are getting at below, and
IMHO the book is excellent as a "how do i get started..." and more...

$44.99 SRP  - a low cost compared to the 'deep breath" below :-)

like any book, to drive through it all the way, inch
by inch, and learn, takes some time and focus.

James Danforth,COO
Neovi Data Corp
www.qchex.com


-Original Message-
From: Peter Lovatt [mailto:[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 more down to earth
stuff like 'How do I store images' or 'how do I get started with SQL' isn't
there, or it is difficult to find.

The other problem is that the documentation is often technical to point that
it is difficult to understand, even as a reasonably competent database
programmer. I think newbies (and not so newbies) could feel totally
overwhelmed by much of it.

So (taking a deep breath !) I would be prepared to lay the foundations for a
faq / knowledge base aimed specifically at this type of questions and to
manage it.

So, any thoughts? Where do we go from here?

Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---

-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: 29 December 2002 22:01
To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED]
Subject: Re: An Idea


Cal, Paul, dear list,

thank you, Cal, for your wise words ...

> "Here's the FAQ we developed so you don't have to waste our time
asking
> questions that have already been answered."

Go to MySQL.com and type "FAQ" in the search box. This will provide 71
results, some of them with valuable FAQ-like information, but no real
FAQ.

Instead, we have this in every list mail:

> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)

I would keep this shorter, saying "Believe in God and do not sin" ;-)

But seriously: Anybody here interested in setting up a FAQ on MySQL.com
/ MySQL.de,
- with "silly" common questions from this list,
- and with answers in "small tutorial" format (something like
http://www.mysql.com/articles/dotnet/index.html),
- well organized (one person to collect / insert the "silly" questions),
- easy to search (only search term + search by category),
- easy to maintain (e. g. with user comments, like the English manual),
- even easier to use as a referer than the MySQL manual when answering
questions?

Flame me if there _is_ a FAQ like this. At least I didn't find it at
MySQL.com, which is most probably the first place a new MySQL user would
look for it.

I am the German translator of the official MySQL manual, so I could
offer to translate as much as I can from the FAQ into German.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  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 that's the way that (FoxPro, Access, Paradox, insert name of
> favorite desktop RDBMS here) did it and I can't make the jump to a
real
> server based RDB

RE: An Idea

[JamesD]

while Paul probably wouldnt say it, I would:

his book: "MySql and Perl for the Web" ISBN 0-7357-1054-6 "New Riders
Publishing"
answers the questions you are getting at below, and
IMHO the book is excellent as a "how do i get started..." and more...

$44.99 SRP  - a low cost compared to the 'deep breath" below :-)

like any book, to drive through it all the way, inch
by inch, and learn, takes some time and focus.

James Danforth,COO
Neovi Data Corp
www.qchex.com


-Original Message-
From: Peter Lovatt [mailto:[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 more down to earth
stuff like 'How do I store images' or 'how do I get started with SQL' isn't
there, or it is difficult to find.

The other problem is that the documentation is often technical to point that
it is difficult to understand, even as a reasonably competent database
programmer. I think newbies (and not so newbies) could feel totally
overwhelmed by much of it.

So (taking a deep breath !) I would be prepared to lay the foundations for a
faq / knowledge base aimed specifically at this type of questions and to
manage it.

So, any thoughts? Where do we go from here?

Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---

-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: 29 December 2002 22:01
To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED]
Subject: Re: An Idea


Cal, Paul, dear list,

thank you, Cal, for your wise words ...

> "Here's the FAQ we developed so you don't have to waste our time
asking
> questions that have already been answered."

Go to MySQL.com and type "FAQ" in the search box. This will provide 71
results, some of them with valuable FAQ-like information, but no real
FAQ.

Instead, we have this in every list mail:

> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)

I would keep this shorter, saying "Believe in God and do not sin" ;-)

But seriously: Anybody here interested in setting up a FAQ on MySQL.com
/ MySQL.de,
- with "silly" common questions from this list,
- and with answers in "small tutorial" format (something like
http://www.mysql.com/articles/dotnet/index.html),
- well organized (one person to collect / insert the "silly" questions),
- easy to search (only search term + search by category),
- easy to maintain (e. g. with user comments, like the English manual),
- even easier to use as a referer than the MySQL manual when answering
questions?

Flame me if there _is_ a FAQ like this. At least I didn't find it at
MySQL.com, which is most probably the first place a new MySQL user would
look for it.

I am the German translator of the official MySQL manual, so I could
offer to translate as much as I can from the FAQ into German.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  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 that's the way that (FoxPro, Access, Paradox, insert name of
> favorite desktop RDBMS here) did it and I can't make the jump to a
real
> server based RDBMS!
>
> Why do you ask?  :)
>
> Seriously, I find this type of issue (not your question Paul, the
original
> question) one of the most troubling things about this list. We as a
> community of SQL developers (regardless of dialect) need to make a
more
> concentrated effort to explain the differences between desktop
databases and
> real database engines. We need to educate people making the changeover
> before releasing them into the wild. (Maybe the link to download MySql
could
> ask a few basic questions to prove you know what you are doing before
being
> allowed to download!)  :)
>
> I cut my teeth on FoxPro.  The first SQL I wrote was in the FoxPro
(2.5/6?)
> dialect. I know from whence I speak because I asked these same
questions
> many years ago.  Luckily, I found people who kindly but firmly pointed

RE: An Idea

[Peter Lovatt]

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 started with SQL' isn't
there, or it is difficult to find.

The other problem is that the documentation is often technical to point that
it is difficult to understand, even as a reasonably competent database
programmer. I think newbies (and not so newbies) could feel totally
overwhelmed by much of it.

So (taking a deep breath !) I would be prepared to lay the foundations for a
faq / knowledge base aimed specifically at this type of questions and to
manage it.

So, any thoughts? Where do we go from here?

Peter

---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-1473
International +44-121-242-1473
---

-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: 29 December 2002 22:01
To: Cal Evans; Paul DuBois; Adam Wi´ckowski; [EMAIL PROTECTED]
Subject: Re: An Idea


Cal, Paul, dear list,

thank you, Cal, for your wise words ...

> "Here's the FAQ we developed so you don't have to waste our time
asking
> questions that have already been answered."

Go to MySQL.com and type "FAQ" in the search box. This will provide 71
results, some of them with valuable FAQ-like information, but no real
FAQ.

Instead, we have this in every list mail:

> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)

I would keep this shorter, saying "Believe in God and do not sin" ;-)

But seriously: Anybody here interested in setting up a FAQ on MySQL.com
/ MySQL.de,
- with "silly" common questions from this list,
- and with answers in "small tutorial" format (something like
http://www.mysql.com/articles/dotnet/index.html),
- well organized (one person to collect / insert the "silly" questions),
- easy to search (only search term + search by category),
- easy to maintain (e. g. with user comments, like the English manual),
- even easier to use as a referer than the MySQL manual when answering
questions?

Flame me if there _is_ a FAQ like this. At least I didn't find it at
MySQL.com, which is most probably the first place a new MySQL user would
look for it.

I am the German translator of the official MySQL manual, so I could
offer to translate as much as I can from the FAQ into German.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  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 that's the way that (FoxPro, Access, Paradox, insert name of
> favorite desktop RDBMS here) did it and I can't make the jump to a
real
> server based RDBMS!
>
> Why do you ask?  :)
>
> Seriously, I find this type of issue (not your question Paul, the
original
> question) one of the most troubling things about this list. We as a
> community of SQL developers (regardless of dialect) need to make a
more
> concentrated effort to explain the differences between desktop
databases and
> real database engines. We need to educate people making the changeover
> before releasing them into the wild. (Maybe the link to download MySql
could
> ask a few basic questions to prove you know what you are doing before
being
> allowed to download!)  :)
>
> I cut my teeth on FoxPro.  The first SQL I wrote was in the FoxPro
(2.5/6?)
> dialect. I know from whence I speak because I asked these same
questions
> many years ago.  Luckily, I found people who kindly but firmly pointed
me in
> the right direction. ("You DON'T need gapless sequences for PK's."
"You
> DON'T store images in the actual database without permission from
God."
> "Here's the FAQ we developed so you don't have to waste our time
asking
> questions that have already been answered." "Thank you, come again.")
They
> showed me the light and occasionally I try to share what little I know
with
> others.
>
> I guess what I'm trying to say is to those who know something (even if
you
> are like me and are constantly amazed at what you DON'T know) share
kindly
> and willingly. To those seeking enlightenment...RTFM you mook! Check
the
&g

Re: An Idea

[Stefan Hinz, iConnect \(Berlin\)]

Cal, Paul, dear list,

thank you, Cal, for your wise words ...

> "Here's the FAQ we developed so you don't have to waste our time
asking
> questions that have already been answered."

Go to MySQL.com and type "FAQ" in the search box. This will provide 71
results, some of them with valuable FAQ-like information, but no real
FAQ.

Instead, we have this in every list mail:

> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)

I would keep this shorter, saying "Believe in God and do not sin" ;-)

But seriously: Anybody here interested in setting up a FAQ on MySQL.com
/ MySQL.de,
- with "silly" common questions from this list,
- and with answers in "small tutorial" format (something like
http://www.mysql.com/articles/dotnet/index.html),
- well organized (one person to collect / insert the "silly" questions),
- easy to search (only search term + search by category),
- easy to maintain (e. g. with user comments, like the English manual),
- even easier to use as a referer than the MySQL manual when answering
questions?

Flame me if there _is_ a FAQ like this. At least I didn't find it at
MySQL.com, which is most probably the first place a new MySQL user would
look for it.

I am the German translator of the official MySQL manual, so I could
offer to translate as much as I can from the FAQ into German.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  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 that's the way that (FoxPro, Access, Paradox, insert name of
> favorite desktop RDBMS here) did it and I can't make the jump to a
real
> server based RDBMS!
>
> Why do you ask?  :)
>
> Seriously, I find this type of issue (not your question Paul, the
original
> question) one of the most troubling things about this list. We as a
> community of SQL developers (regardless of dialect) need to make a
more
> concentrated effort to explain the differences between desktop
databases and
> real database engines. We need to educate people making the changeover
> before releasing them into the wild. (Maybe the link to download MySql
could
> ask a few basic questions to prove you know what you are doing before
being
> allowed to download!)  :)
>
> I cut my teeth on FoxPro.  The first SQL I wrote was in the FoxPro
(2.5/6?)
> dialect. I know from whence I speak because I asked these same
questions
> many years ago.  Luckily, I found people who kindly but firmly pointed
me in
> the right direction. ("You DON'T need gapless sequences for PK's."
"You
> DON'T store images in the actual database without permission from
God."
> "Here's the FAQ we developed so you don't have to waste our time
asking
> questions that have already been answered." "Thank you, come again.")
They
> showed me the light and occasionally I try to share what little I know
with
> others.
>
> I guess what I'm trying to say is to those who know something (even if
you
> are like me and are constantly amazed at what you DON'T know) share
kindly
> and willingly. To those seeking enlightenment...RTFM you mook! Check
the
> !*#&^ archives and use Google, this issue has been beat to death!
>
> Humbly,
> =C=
> *
> * Cal Evans
> * The Virtual CIO
> * http://www.calevans.com
> *
>
>
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, December 29, 2002 10:02 AM
> 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-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

[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)

-- 
   The Moon is Waning Crescent (21% of Full)
   nieuw.nl - 2dehands.nl: 58038

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: An Idea

[Cal Evans]

Because that's the way that (FoxPro, Access, Paradox, insert name of
favorite desktop RDBMS here) did it and I can't make the jump to a real
server based RDBMS!

Why do you ask?  :)

Seriously, I find this type of issue (not your question Paul, the original
question) one of the most troubling things about this list. We as a
community of SQL developers (regardless of dialect) need to make a more
concentrated effort to explain the differences between desktop databases and
real database engines. We need to educate people making the changeover
before releasing them into the wild. (Maybe the link to download MySql could
ask a few basic questions to prove you know what you are doing before being
allowed to download!)  :)

I cut my teeth on FoxPro.  The first SQL I wrote was in the FoxPro (2.5/6?)
dialect. I know from whence I speak because I asked these same questions
many years ago.  Luckily, I found people who kindly but firmly pointed me in
the right direction. ("You DON'T need gapless sequences for PK's." "You
DON'T store images in the actual database without permission from God."
"Here's the FAQ we developed so you don't have to waste our time asking
questions that have already been answered." "Thank you, come again.") They
showed me the light and occasionally I try to share what little I know with
others.

I guess what I'm trying to say is to those who know something (even if you
are like me and are constantly amazed at what you DON'T know) share kindly
and willingly. To those seeking enlightenment...RTFM you mook! Check the
!*#&^ archives and use Google, this issue has been beat to death!

Humbly,
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*


-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 10:02 AM
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-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

[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 after
deleting, so I changed it by myself.




Don't use the PK for numbering.  Instead, in PHP, ASP, etc, just use a 
counter when looping through your guestbook entries and label them 1, 2, 3, 
etc.


BTW, does MySQL have a RowNumber function?

--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.com/



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

[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
deleting, so I changed it by myself. But then (after deleting the last ID
was 17, and before 32), next ID was 33, not 18. Is there any function, which
can change it? If not, mayby you'll try to do something like that. It's
right, I can do it by myself not using auto_increment, and giving the ID
number MAX(ID)+1, but if there is such function it would be realy fine.
Greatings,
MySQL user

Adam Wi´ckowski
GG# :1257924



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: An Idea

[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 I changed it by myself. But then (after deleting the
> last ID was 17, and before 32), next ID was 33, not 18. Is there any
> function, which can change it?

Nope. It's expected behaviour for MyISAM and InnoDB tables.

>If not, mayby you'll try to do something
> like that. It's right, I can do it by myself not using auto_increment, and
> giving the ID number MAX(ID)+1, but if there is such function it would be
> realy fine. 

Sure, you can do it, but you should lock table, retrieve max id value, insert 
max+1 value, unlock table.






-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: An Idea

[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 after
> deleting, so I changed it by myself. But then (after deleting the last ID
> was 17, and before 32), next ID was 33, not 18. Is there any function, which
> can change it? If not, mayby you'll try to do something like that. It's
> right, I can do it by myself not using auto_increment, and giving the ID
> number MAX(ID)+1, but if there is such function it would be realy fine.

What you describe was the behaviour in older MySQL versions and it has
been changed because primary keys should never be reused. Never.

If you need it to have no holes, you are abusing the primary key for
something which it is not intended for (visible entry numbering?).

So, yes, you have to either implement it yourself, or, what I would
recommend, have a seperate column for it or calculate it in your
application, whatever makes most sense for your use.

HTH,

Benjamin.


PS: AFAIK, InnoDB still has the "old" behaviour. Anyhow, it will
change soon enough.


-- 
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php