RE: how to design book db

2009-01-06 Thread ceo
Just theories here: The same book re-issued by another publisher might have a different ISBN. A book with an insert (e.g., CDROM) may have a different ISBN, but be the same for some purposes. And mistakes can be made... Ultimately, I suspect that the uniqueness of ISBN to what normal

RE: how to design book db

2009-01-06 Thread Jerry Schwartz
-Original Message- From: c...@l-i-e.com [mailto:c...@l-i-e.com] Sent: Tuesday, January 06, 2009 9:47 AM To: mysql@lists.mysql.com Subject: RE: how to design book db Just theories here: The same book re-issued by another publisher might have a different ISBN. A book with an insert

RE: how to design book db

2009-01-06 Thread Wm Mussatto
On Tue, January 6, 2009 07:55, Jerry Schwartz wrote: -Original Message- From: c...@l-i-e.com [mailto:c...@l-i-e.com] Sent: Tuesday, January 06, 2009 9:47 AM To: mysql@lists.mysql.com Subject: RE: how to design book db Just theories here: The same book re-issued by another publisher

RE: how to design book db

2009-01-06 Thread mos
At 09:55 AM 1/6/2009, you wrote: -Original Message- From: c...@l-i-e.com [mailto:c...@l-i-e.com] Sent: Tuesday, January 06, 2009 9:47 AM To: mysql@lists.mysql.com Subject: RE: how to design book db Just theories here: The same book re-issued by another publisher might have

Re: how to design book db

2009-01-06 Thread PJ
My comments, questions explanations inserted below mos wrote: At 09:55 AM 1/6/2009, you wrote: -Original Message- From: c...@l-i-e.com [mailto:c...@l-i-e.com] Sent: Tuesday, January 06, 2009 9:47 AM To: mysql@lists.mysql.com Subject: RE: how to design book db Just theories

Re: how to design book db

2009-01-06 Thread Wm Mussatto
: how to design book db Just theories here: The same book re-issued by another publisher might have a different ISBN. A book with an insert (e.g., CDROM) may have a different ISBN, but be the same for some purposes. And mistakes can be made... Ultimately, I suspect

RE: how to design book db

2009-01-06 Thread bruce
to have a sample book database to test your db schema/app on have fun!! -Original Message- From: Wm Mussatto [mailto:mussa...@csz.com] Sent: Tuesday, January 06, 2009 1:38 PM To: mysql@lists.mysql.com Subject: Re: how to design book db On Tue, January 6, 2009 13:30, PJ wrote: My

Re: how to design book db

2009-01-05 Thread PJ
mos wrote: At 08:17 AM 12/29/2008, you wrote: I am rather fresh to MySQL and am trying to fix and update a website - modifying from just plain html to css, php and MySQL. I'm working on FreeBSD 7.0, MySQL 5.1,30, PHP5.28 Apache 2.2.11. I need figure out how to set up (design) a database of

RE: how to design book db

2009-01-05 Thread bruce
/publishers... thanks -Original Message- From: PJ [mailto:af.gour...@videotron.ca] Sent: Monday, January 05, 2009 3:06 PM To: mos Cc: mysql@lists.mysql.com Subject: Re: how to design book db mos wrote: At 08:17 AM 12/29/2008, you wrote: I am rather fresh to MySQL and am trying to fix and update

RE: how to design book db

2009-01-05 Thread Paul Wilson
should be orgasmic! -Original Message- From: bruce [mailto:bedoug...@earthlink.net] Sent: Tuesday, January 06, 2009 8:52 AM To: 'PJ'; 'mos' Cc: mysql@lists.mysql.com Subject: RE: how to design book db hey phil... are you sure that a book can have multiple ISBN numbers. I was under

RE: how to design book db

2009-01-05 Thread bruce
right... forgot about that! -Original Message- From: Paul Wilson [mailto:hoo...@staff.iinet.net.au] Sent: Monday, January 05, 2009 5:59 PM To: 'bruce'; 'PJ'; 'mos' Cc: mysql@lists.mysql.com Subject: RE: how to design book db Recent books that I've looked at have 2 ISBN's - one

Re: how to design book db

2009-01-05 Thread mos
At 05:05 PM 1/5/2009, you wrote: mos wrote: At 08:17 AM 12/29/2008, you wrote: I am rather fresh to MySQL and am trying to fix and update a website - modifying from just plain html to css, php and MySQL. I'm working on FreeBSD 7.0, MySQL 5.1,30, PHP5.28 Apache 2.2.11. I need figure out how

how to design book db

2008-12-29 Thread PJ
I am rather fresh to MySQL and am trying to fix and update a website - modifying from just plain html to css, php and MySQL. I'm working on FreeBSD 7.0, MySQL 5.1,30, PHP5.28 Apache 2.2.11. I need figure out how to set up (design) a database of books which gets rather complicated since I must

Re: how to design book db

2008-12-29 Thread mos
At 08:17 AM 12/29/2008, you wrote: I am rather fresh to MySQL and am trying to fix and update a website - modifying from just plain html to css, php and MySQL. I'm working on FreeBSD 7.0, MySQL 5.1,30, PHP5.28 Apache 2.2.11. I need figure out how to set up (design) a database of books which