Connecting Tech Pros Worldwide Help | Site Map

DB question ... thanks

 
LinkBack Thread Tools Search this Thread
  #1  
Old November 12th, 2005, 02:31 PM
Useko Netsumi
Guest
 
Posts: n/a
Default DB question ... thanks

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





  #2  
Old November 12th, 2005, 02:32 PM
Daniel Morgan
Guest
 
Posts: n/a
Default Re: DB question ... thanks

Useko Netsumi wrote:
[color=blue]
>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
>
>
>[/color]
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
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

  #3  
Old November 12th, 2005, 02:32 PM
Useko Netsumi
Guest
 
Posts: n/a
Default Re: DB question ... thanks

sorry for your trouble. perhaps you can tell me where should I post for this
type of question.

thanks

"Daniel Morgan" <damorgan@x.washington.edu> wrote in message
news:1066675699.814023@yasure...[color=blue]
> Useko Netsumi wrote:
>[color=green]
> >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[/color][/color]
the[color=blue][color=green]
> >K-, and V- as well.
> >
> >How do I structure the following in MySQL?
> >
> >Thanks in advance
> >
> >
> >[/color]
> 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
> damorgan@x.washington.edu
> (replace 'x' with a 'u' to reply)
>[/color]


  #4  
Old November 12th, 2005, 02:32 PM
Daniel Morgan
Guest
 
Posts: n/a
Default Re: DB question ... thanks

Useko Netsumi wrote:
[color=blue]
>sorry for your trouble. perhaps you can tell me where should I post for this
>type of question.
>
>thanks
>
>"Daniel Morgan" <damorgan@x.washington.edu> wrote in message
>news:1066675699.814023@yasure...
>
>[color=green]
>>Useko Netsumi wrote:
>>
>>
>>[color=darkred]
>>>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
>>>
>>>[/color][/color]
>the
>
>[color=green][color=darkred]
>>>K-, and V- as well.
>>>
>>>How do I structure the following in MySQL?
>>>
>>>Thanks in advance
>>>
>>>
>>>
>>>
>>>[/color]
>>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
>>damorgan@x.washington.edu
>>(replace 'x' with a 'u' to reply)
>>
>>
>>[/color][/color]
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
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)


 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,840 network members.