Hello,
>Many thanks for your response. Can yo u offer any advice with regards
usage
>of country_codes eg gb and regions, cities etc ? I've been reading up on
>http://en.wikipedia.org/wiki/ISO_3166 etc. Should I be looking to use a
>Surrogate key for countries ? Or the country code like fr for
Many thanks for your response. Can yo u offer any advice with regards
usage of country_codes eg gb and regions, cities etc ? I've been reading
up on http://en.wikipedia.org/wiki/ISO_3166 etc. Should I be looking to
use a Surrogate key for countries ? Or the country code like fr for France
?
Sa
Neil,
Am 21.04.2013 08:47, schrieb Neil Tompkins:
Using joins I can obtain which country each city belongs too. However,
should I consider putting a foreign key in the CITIES table referencing the
countries_id ? Or is it sufficient to access using a join ?
It depends. Adding a reference to
Hi
I'm creating the following basic tables
COUNTRIES
countries_id
name
REGIONS
region_id
countries_id
name
CITIES
cities_id
region_id
Using joins I can obtain which country each city belongs too. However,
should I consider putting a foreign key in the CITIES table referencing the
countries_i
At 04:23 PM 9/9/2010, Tompkins Neil wrote:
Hi all,
Needing some advice on my tables design.
Basically I am designing a soccer application, and have a table which
contains player_bids (the values of which a player costs to be transferred
between clubs). Can someone please offer some input on th
Hi all,
Needing some advice on my tables design.
Basically I am designing a soccer application, and have a table which
contains player_bids (the values of which a player costs to be transferred
between clubs). Can someone please offer some input on the best way in
which I should design the finan
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
: 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 points to
> CATEGORY.CATEGORY_ID)> SUBCATEGORY_ID> PK: (
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-
ington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original Message-
> From: Sudheer Satyanarayana [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 14, 2007 1:50 AM
> To: mysql@lists.mysql.com
> Su
f security information to follow
You can grow the database as you add module, but as much as you can
foresee and design ahead it would be better
Mikhail Berman
-Original Message-
From: Sudheer Satyanarayana [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 14, 2007 1:50 AM
To: mysql@lists.mysql.
HI Sudheer,
THIS DESIGN IS BASED ON MY MANY->TO->ONE DIRECTION PATTERN
OF DATABASE NORMALIZATION DESIGN... PLEASE MODIFY/CORRECT IT ACCORDING TO YOUR
TASTE. AS A JAVA DEVELOPER I'M USING HIBERNATE FOR MY CREATE-UPDATE-DELETE(CUD)
AND DIRECT JDBC FOR MY QUERIES(R).
YOU MAY VARY.
HERE, HOPE TH
Hi,
I'm creating an application for my web site. I want help in designing
database tables. Currently I'm starting with user management system.
The web site would have these types of users
1. Customer account
1a. Individual account. This user would be an individual with username,
password, bi
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
Casey,
I would consider, on the most basic level, a method like this:
Contacts (all the company contact info, etc) using primary key contact_id ->
IndustrialRelationships table
<- industry_id primary key on Industries table (all the different type of
industries)
So, in the IndustrialRelationship
y, Casey [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 29, 2003 1:09 PM
> To: '[EMAIL PROTECTED]'
> Subject: Table design help
>
>
> I have a small table that contains company contact information:
>
> Table: Contacts
> Key
> Name
> Address
>
I have a small table that contains company contact information:
Table: Contacts
Key
Name
Address
Phone
Email
Website
etc..
What I need to do is associate the type of industry the business servers
from a list of about 40 industries... My initial thinking was to create
another table that contains
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
I am creating site for greeting cards and need help desiging tables for DB
Currently I have three tables..
1) maincat which has following fields:
maincatid (autoincrement)
main_name (name of category)
2) subcat which has following fields:
subcatid (autoincrement)
maincatid
sub_name (name of sub ca
Hello MySQL users
I was wondering if one of you could advise me on the best solution to a
problem I'm having - I'm sure this has been done before but haven't found
anything in the archives.
Basically the problem I am having is how best to handle multiple values for
a specific column, in this cas
Hi dn, thanks for replying.
I suspect you're right about my 'problem' - I'm probably misunderstanding
some simple SQL construct :-)
Let's say I have the following tables:
parts (partid int, partname varchar(255))
cats(catid int, catname varchar(255))
parts_cats (id i
I've asked this before, but let me describe it another way, and see if
anyone has any bright ideas:
My client has 3 offices.
Each office needs to use same app (over MySQL).
Each office needs (effectively) same database.
Updates done at each office need to be used at other offices.
Updates v
>Date: Sun, 10 Feb 2002 16:06:55 -0800
>To: [EMAIL PROTECTED]
>From: tj marlin <[EMAIL PROTECTED]>
>Subject: Re: Quick SQL design help
>
>the SET data type comes to mind. there is a limitation of 64 for the set
>size.
>
>ciao
>
>At 05:23 AM 2/10/02 +
Hello James,
> Basically the problem I am having is how best to handle multiple values for
> a specific column, in this case the values in question are coming from an
> HTML SELECT MULTI box processed by PHP.
>
> The way I have been doing this so far is to have a delimited value stored
> in a var
> Hello MySQL users
>
> I was wondering if one of you could advise me on the best solution to a
> problem I'm having - I'm sure this has been done before but haven't found
> anything in the archives.
>
> Basically the problem I am having is how best to handle multiple values for
> a specific col
Hi Amer
Thanks for replying - I wonder if you could clear up a point for me.
I'm going to have many, many possible multi values - too many for a SET or
ENUM column as some other people have suggested.
I'm happy using the following tables:
parts (partid int, partname varchar(255))
cat
James Carrier wrote:
>
> Hi Amer
>
> Thanks for replying - I wonder if you could clear up a point for me.
> I'm going to have many, many possible multi values - too many for a SET or
> ENUM column as some other people have suggested.
> I'm happy using the following tables:
>
> parts (
> Hello MySQL users
>
> I was wondering if one of you could advise me on the best solution to a
> problem I'm having - I'm sure this has been done before but haven't found
> anything in the archives.
>
> Basically the problem I am having is how best to handle multiple values for
> a specific col
>Date: Sun, 10 Feb 2002 16:06:55 -0800
>To: [EMAIL PROTECTED]
>From: tj marlin <[EMAIL PROTECTED]>
>Subject: Re: Quick SQL design help
>
>the SET data type comes to mind. there is a limitation of 64 for the set
>size.
>
>ciao
>
>At 05:23 AM 2/10/02 +
Hello James,
> Basically the problem I am having is how best to handle multiple values for
> a specific column, in this case the values in question are coming from an
> HTML SELECT MULTI box processed by PHP.
>
> The way I have been doing this so far is to have a delimited value stored
> in a var
Hello MySQL users
I was wondering if one of you could advise me on the best solution to a
problem I'm having - I'm sure this has been done before but haven't found
anything in the archives.
Basically the problem I am having is how best to handle multiple values for
a specific column, in this cas
61 matches
Mail list logo
