Re: DB question ... thanks

Useko Netsumi wrote:

>Suppose that I have the basic db structure as follow:
>
>imgnum varchar(16)
>description text
>imagecode varchar(16)
>note text
>photographer varchar(16)
>date date
>location varchar(50)
>
>The <imgnum> format is as follows(and its unique):
> J-1 ... J-200
> K-1 ... K-250
> V-1 ... V-128
>
>But some they have a few sub-images e.g: J-1 has say, J-J-1a, J-1b, J-1c
>which represent the same pic but more details views; and the same with the
>K-, and V- as well.
>
>How do I structure the following in MySQL?
>
>Thanks in advance
>
>
>

Suppose you explain why you posted this in just about every usenet group you could spell.
You posted in groups for Sybase, SQL Server, Access, Dreamweaver, Oracle, etc.
when your question has absolutely nothing to do with any of them.

Please do not post in usenet groups unless you are on-topic. And please read the FAQ for a
group in the future before wasting everyone's time.

Thank you.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)