Re: mysql claims table does not exist. but it does

2007-11-03 Thread Kim Briggs
On Oct 31, 2007 3:22 AM, robert rottermann <[EMAIL PROTECTED]> wrote: > Hi there, > I have a strange problem. > > I am using Server version: 5.0.45 SUSE MySQL RPM > > I made a backup of a database by copying its directory like so: > mv urulu urulu_X > then I recreateded the database, played a littl

Re: many to many

2005-04-20 Thread Kim Briggs
An answer won't make much sense if you truly don't have a clue. W3schools has a good intro on joins. http://www.google.com/search?hl=en&q=sql+join+syntax&btnG=Google+Search cheers, KB On 4/20/05, Perry Merritt <[EMAIL PROTECTED]> wrote: > Hi, I'm a novice. > > I've designed a database that sup

Re: Relative Numeric Values

2005-04-16 Thread Kim Briggs
David, In reading through miscellaneous database design text on the web, I read just the other day that you should not try to include meaningful data in your key values. I assume there will be some kind of "lookup" tables for species, phylum, whatever. Trying to make your key field "smart" seems