By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,052 Members | 1,303 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,052 IT Pros & Developers. It's quick & easy.

DB question ... thanks

P: n/a
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


Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

Nov 12 '05 #2

P: n/a
sorry for your trouble. perhaps you can tell me where should I post for this
type of question.

thanks

"Daniel Morgan" <da******@x.washington.edu> wrote in message
news:1066675699.814023@yasure...
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 theK-, 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/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

Nov 12 '05 #3

P: n/a
Useko Netsumi wrote:
sorry for your trouble. perhaps you can tell me where should I post for this
type of question.

thanks

"Daniel Morgan" <da******@x.washington.edu> wrote in message
news:1066675699.814023@yasure...

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/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

You could start by going to http://www.google.com and looking up the
product you are working with.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.