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 3  1444 
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)
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)
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) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Rasmus |
last post by:
Hi.
As partly novice in python I would like a piece of advise of how to
implement (binary) trees the best way?
Thanks in advance,
Rasmus
PS: Due to heavy spam reception (20.000+/week), I...
|
by: Newbie |
last post by:
Dear friends,
I am having a hard time understanding how to use a SELECT CASE in ASP. I
have used it in VB but never in ASP scripting.
Scenerio:
I have 2 textboxes on a form that I have to...
|
by: David |
last post by:
Does anyone know where I can find example code for VB.NET that I can use
to create an application that attaches and detaches databases to MSDE using
osql scipts.
(I think SQL-DMO is typically...
|
by: rong.guo |
last post by:
Hello,
The population of my analysis is customers that have product1. And I am
trying to get the % of them that also have product2, the % of them that
also have product3, etc. Now I am doing it...
|
by: Arsene Lupin |
last post by:
Is there a way to have Microsoft Access XP automatically display all
table views, etc., in a maximized screen when Access is started? It is
extremely time consuming to have to maximize the viewing...
|
by: J Bunton |
last post by:
My Access 97 applictions seem to have recently become very Cpu useage
hungry.
When opened they go to almost 100% useage on the peformance monitor.
After several seconds this returns to near...
|
by: Shapper |
last post by:
Hello,
I have a label as follows:
<label id="lName" for="name">Name:<input type="text"
id="name"></input></label>
I need to declare the label in my page.aspx.vb so I can access it on
page...
|
by: davidw |
last post by:
For example, I have a virtual directory - "wfile", I would like user access
http://mysite/wfile, but I want to handle it with my own code instead of
turn on "Directory Browsing", how can I capture...
|
by: eBob.com |
last post by:
I am trying to change some Structures to Classes. The Classes now
look like this ...
Public Class OneAttr
Public AttrName As String
Public Column As String
Public Caption As String
End Class...
|
by: Charles Sullivan |
last post by:
I define and initialize an array of structures like the following,
(where the <verbiage within angle bracketsis just meant to be
explanatory):
int func1(<argument prototypes>);
int...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
