il: je...@gii.co.jp
Web site: www.the-infoshop.com
-Original Message-
From: Neil Tompkins [mailto:neil.tompk...@googlemail.com]
Sent: Tuesday, August 31, 2010 3:48 PM
To: mysql@lists.mysql.com
Subject: Database design help
Hi
I've a soccer application consisting of managers, teams
60.674.8796 / FAX: 860.674.8341
> E-mail: je...@gii.co.jp
> Web site: www.the-infoshop.com
>
> >-Original Message-
> >From: Neil Tompkins [mailto:neil.tompk...@googlemail.com]
> >Sent: Tuesday, August 31, 2010 3:48 PM
> >To: mysql@lists.mysql.com
> >Subjec
t;From: Neil Tompkins [mailto:neil.tompk...@googlemail.com]
>Sent: Tuesday, August 31, 2010 3:48 PM
>To: mysql@lists.mysql.com
>Subject: Database design help
>
>Hi
>
>I've a soccer application consisting of managers, teams players and
>fixtures/results. Basically each man
ssage-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: 01 September 2010 12:52
To: [MySQL]
Subject: Fwd: Database design help
Looking for some help / comments if possible ?
Cheers
Neil
-- Forwarded message --
From: Neil Tompkins
Date: Tue, Aug 31, 2010 at 8:48 PM
Su
think this
few lines can trigger the best idea in you.
Claudio
2010/9/1 Tompkins Neil
> Looking for some help / comments if possible ?
>
> Cheers
> Neil
>
> -- Forwarded message --
> From: Neil Tompkins
> Date: Tue, Aug 31, 2010 at 8:48 PM
> Subject
Looking for some help / comments if possible ?
Cheers
Neil
-- Forwarded message --
From: Neil Tompkins
Date: Tue, Aug 31, 2010 at 8:48 PM
Subject: Database design help
To: mysql@lists.mysql.com
Hi
I've a soccer application consisting of managers, teams players and
fix
Hi
I've a soccer application consisting of managers, teams players and
fixtures/results. Basically each manager will get points for each game
which will depend on the result.
What would be the best table design bearing in mind that a manager can
move to a different club.
My thought was
john.l.me...@gmail.com
Sent: Friday, September 04, 2009 6:09 PM
Subject: RE: Database design - help
> given the following table layouts
URLs:> URL_ID (primary key for URL)> URL_TEXT>> URL_CATEGORY> URL_ID
(key which points to URL.URL_ID)> CATEGORY_ID (key which
lworld.com ; mysql@lists.mysql.com
Cc: john.l.me...@gmail.com
Sent: Friday, September 04, 2009 6:09 PM
Subject: RE: Database design - help
> given the following table layouts
> URLs:> URL_ID (primary key for URL)> URL_TEXT>> URL_CATEGORY> URL_ID
> (key which
e ou la copie de ceci est
interdite. Ce message sert à l'information seulement et n'aura pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
n seulement et n'aura pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> From: bobsh...@ntlworld.com
> To: mysql@lists.mysql.com
&
helpful to me.
cheers
- Original Message -
From: "John Meyer"
To: "BobSharp"
Cc:
Sent: Monday, August 31, 2009 4:56 PM
Subject: Re: Database design - help
BobSharp wrote:
As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling
BobSharp wrote:
As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling.
There are several Categories ... Equipment Manufacturers,
Organistations, (UK) ProShops, (UK) Bowling Centres, Personal
Websites, Misc., Coaching & Instructional websites, etc.
There
As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling.
There are several Categories ... Equipment Manufacturers, Organistations,
(UK) ProShops, (UK) Bowling Centres, Personal Websites, Misc., Coaching &
Instructional websites, etc.
There will be some sub-
rd
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: ppywriw [mailto:[EMAIL PROTECTED]
> Sent: Saturday, December 16, 2006 11:54 AM
> To: mysql@lists.mysql.com
> Subje
password field on
it so only the user that created it could access it?
A very newbie question i know, but i am one, i'll admit it.
Any help would be apprectiated.
Thanks
John
--
View this message in context:
http://www.nabble.com/database-design-help-tf2832533.html#a7908028
Sent from the
created it could access it?
A very newbie question i know, but i am one, i'll admit it.
Any help would be apprectiated.
Thanks
John
--
View this message in context:
http://www.nabble.com/database-design-help-tf2832533.html#a7908028
Sent from the MySQL - General mailing list archi
OK, I think I got it now. Thanks for the additional info, that helps alot.
Rhino wrote:
- Original Message - From: "Mike Blezien" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Friday, February 17, 2006 7:49 AM
Subject: Database design help
Hello,
we curre
- Original Message -
From: "Mike Blezien" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Friday, February 17, 2006 7:49 AM
Subject: Database design help
Hello,
we currently have a small database setup for affilates and visitor/leads.
I believe we have a &quo
Hello,
we currently have a small database setup for affilates and visitor/leads. I
believe we have a "one to many" application, one affiliate can have several
visitor/leads but each visitor can only be assigned to one affiliate.
What I need to know if this the best design for this setup. Basi
If you give this due consideration, you may find that a lot of your
problem evaporates and the rest gets simpler to handle.
Just a general observation made by a disinterested third party; ignore it
if you like :-)
Rhino
- Original Message - From: "Ian Klassen" <[EMAIL PROTECTED]
at important and could be omitted with
no important loss of functionality?
If you give this due consideration, you may find
that a lot of your problem evaporates and the
rest gets simpler to handle.
Just a general observation made by a
disinterested third party; ignore it if you like
:-)
:-)
Rhino
- Original Message - From: "Ian Klassen" <[EMAIL PROTECTED]>
To: "Marco Neves" <[EMAIL PROTECTED]>;
Sent: Friday, January 20, 2006 3:49 PM
Subject: Re: Database design help
Marco,
Thanks for your help. I created this example to try to simplify
you like :-)
Rhino
- Original Message -
From: "Ian Klassen" <[EMAIL PROTECTED]>
To: "Marco Neves" <[EMAIL PROTECTED]>;
Sent: Friday, January 20, 2006 3:49 PM
Subject: Re: Database design help
Marco,
Thanks for your help. I created this exa
Marco,
Thanks for your help. I created this example to try to simplify my real
world problem. Clearly I didn't provide enough detail. Keeping with my
example, essentially I'm looking at product details that change over
time. Let's say I'm keeping track of boxes. Over time, the color or si
Ian,
I'ld like to help you, but a more specific db design would depend on
more
specific description on your application needs.
What I can say is that you need to adapt your database to your reality.
What I got til now is that you need a product table, where you can
sto
Thanks Ed. That's another good idea. The consensus I'm getting is to
create one table that stores unchanging data about the product and another
that stores transaction details. The
problem I'm still having is how to efficiently handle more than one
changing value.
As an example, let's say I
I built my inventory system like this,
I have a products table that contains all the information specific to each
part, less the quantity, i.e. Part Number, Description, Vendor, Color, Weight,
SKU number, etc...
Then I have another table that is my Inventory Tranactions Log that is just the
At 06:27 PM 1/18/2006 +, Marco Neves wrote:
Hi,
Why don't you create two table:
* a product table, with the product discriptions, and other
product related
info (call it prod):
|ID|NAME|SOME|OTHER|FIELDS|
|1|ProdA|..|..|..|
|2|ProdB|..|..|..|
Ian Klassen <[EMAIL PROTECTED]> wrote on 01/18/2006 01:09:55 PM:
> Hi all,
>
> I'm trying to figure out a solution to the following problem.
>
> Let's say I have a store with various products. I take inventory of
these
> products on different days. At any given time I want to view what the
Hi,
Why don't you create two table:
* a product table, with the product discriptions, and other product
related
info (call it prod):
|ID|NAME|SOME|OTHER|FIELDS|
|1|ProdA|..|..|..|
|2|ProdB|..|..|..|
* a stock movements table, with moviments by p
Hi all,
I'm trying to figure out a solution to the following problem.
Let's say I have a store with various products. I take inventory of these
products on different days. At any given time I want to view what the
inventory is for the entire store. I also want to know whether the
inventory
I would take a look at the already available solutions
at http://www.hotscripts.com
http://php.resourceindex.com
(many open source/free)
It may be easier to use (and manipulate) one of these
to what you need.
I am working on a similar project, since I fond many
project management solutions to b
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and include the entire text of it in
> the
> reply, yo
I'm new and I'm TOTALLY lost! Why am I here? To BEG for help! My
office currently keeps track of our projects via an excel spreadsheet. We
keep such info as project costing, status, points oif contact, name,
description, number, last updated, etc... What I want to do is merge all
that info
35 matches
Mail list logo
