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
Hello,
Currently, I have four tables (Items, UpdatePrice, UpdateStatus and
UpdateRelease). All the Update tables are linked to Items.ItemID via
Update(Price|Status|Release)ItemKey. Personally, I don't feel that
this is the best database design I could have, but I can't seem to
come u
donné que les email
> peuvent facilement être sujets à la manipulation, nous ne pouvons accepter
> aucune responsabilité pour le contenu fourni.
>
>
>
>
>
>
> > Date: Sat, 3 Oct 2009 18:11:59 -0600
> > From: john.l.me...@gmail.com
> > To: m...@phillipsmarketi
Mark Phillips wrote:
On Sat, Oct 3, 2009 at 3:06 PM, Martin Gainty wrote:
depends on the relationship of the Data Tables and the Users that use them
for instance if I was to setup a table of outgoing calls from 2 distinct
individuals :
Me> calls to HarvardMedicalSchoo
On Sat, Oct 3, 2009 at 4:02 PM, John Meyer wrote:
>
> John,
>> Thanks. The data is private to each user; there is no sharing of data. I
>> am not sure what you mean by "are the actions related" Each user is
>> reading/writing independently of each other. Would that argue for separate
>> database
t that user a cannot get to user b's
data.
Can't I achieve the same level of security if each row has a userID, and all
queries use a "where userID=xxx" clause?
Mark
>
>
> > Date: Sat, 3 Oct 2009 14:38:25 -0700
> > Subject: Questions on Database Design
&g
John,
Thanks. The data is private to each user; there is no sharing of data.
I am not sure what you mean by "are the actions related" Each user is
reading/writing independently of each other. Would that argue for
separate databases?
Mark
Are the actions of a similar nature (i.e. they're
On Sat, Oct 3, 2009 at 2:47 PM, John Meyer wrote:
> Mark Phillips wrote:
>
>> I am new at database design, and my question relates to the trade-offs
>> between putting all data in one database or several for mysql. For
>> example,
>> say I have an application
Mark Phillips wrote:
I am new at database design, and my question relates to the trade-offs
between putting all data in one database or several for mysql. For example,
say I have an application where a users login from their mobile phones and
read/write data to a database. Say there are roughly
I am new at database design, and my question relates to the trade-offs
between putting all data in one database or several for mysql. For example,
say I have an application where a users login from their mobile phones and
read/write data to a database. Say there are roughly 10-15 tables in the
>-Original Message-
>From: AndrewJames [mailto:andrewhu...@gmail.com]
>Sent: Saturday, September 12, 2009 1:20 AM
>To: Kyong Kim; Arthur Fuller
>Cc: Claudio Nanni; mysql
>Subject: Re: database design
>
>thank you all, i think
>
>"You probably wouldn&
directly."
>
> is my answer.
>
>
> --
> From: "Kyong Kim"
> Sent: Saturday, September 12, 2009 8:22 AM
> To: "Arthur Fuller"
> Cc: "Claudio Nanni" ; "AndrewJames"
> ; "mysql"
> Subject: Re:
Storing it directly will cause problems when you want to add a new Article
Type. IMO it's better to have an ArticleTypes table (AutoIncrement) and
store its values in the ArticleTypeID column in the Articles table.
A.
On Sat, Sep 12, 2009 at 1:19 AM, AndrewJames wrote:
> thank you all, i think
>
epter aucune responsabilité pour
le contenu fourni.
> Date: Fri, 11 Sep 2009 15:22:57 -0700
> Subject: Re: database design
> From: kykim...@gmail.com
> To: fuller.art...@gmail.com
> CC: claudio.na...@gmail.com; andrewhu...@gmail.com; mysql@lists.mysql.com
> > A) You
;Arthur Fuller"
Cc: "Claudio Nanni" ; "AndrewJames"
; "mysql"
Subject: Re: database design
A) You would probably want to populate the Article.Article_Type column
with Article_Type.ID. You probably wouldn't need Article_Type table if
you're going
A) You would probably want to populate the Article.Article_Type column
with Article_Type.ID. You probably wouldn't need Article_Type table if
you're going to store Article_Type value directly.
I would also consider the use of natural primary key vs surrogate
primary key. We've seen good results wi
I agree with Claudio. You have your design correct. The only other thing you
need is the uid qualifier. Presumably you are using PHP or some other front
end to present your data. Your front end would request the user's name and
password, saving the uid in a variable and then issuing the select with
A.J., It sounds good to me!
You can be a little confused but you did it well,
It seems you have all you need there.
A) Yes
B) select * from articles A left join article_types AT on A.article_type =
AT.article_types_id
Claudio
2009/9/11 AndrewJames
> This is a bit of a long shot, but i real
This is a bit of a long shot, but i really need some help and or directed to
the best reading resources.
as i begun building my database (as i went along), i now realise i have to
stop coding and sit back and design the database properly before i can go
on.
However i am still unable to wrap
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-
hi all,
after a little 'research' and consultation with friends, i come up with
these tables for my database project.
table Item(ItemID,warehouse,ShapeID,weight,category,description)
table Shape(ShapeID,physical shape)
table Dimension(DimensionID,dimension)
table ShapeDimension(ShapeDimensionI
gned NOT NULL auto_increment,
`title` varchar(60) NOT NULL,
PRIMARY KEY (`title_id`),
UNIQUE KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Thanks for any continued support.
> From: John Meyer <[EMAIL PROTECTED]>
> Date: Wed, 23 May 2007 07:28:23
y an ID, you can search on any of the sizes the ID represents.
- Original Message -
From: "Officelink" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, May 23, 2007 8:29 AM
Subject: Database design
Hi everyone,
I¹m trying to set up a database with information that will be used i
Officelink wrote:
> Hi everyone,
>
> I¹m trying to set up a database with information that will be used in a
> garment slideshow in flash.
>
> The information to be included as part of the slideshow would be:
> code, optional title, description, colours, sizes, garment image, fabric
> swatch image
Hi everyone,
I¹m trying to set up a database with information that will be used in a
garment slideshow in flash.
The information to be included as part of the slideshow would be:
code, optional title, description, colours, sizes, garment image, fabric
swatch image
Each clothing item to be includ
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
Hello,
I'm not very experienced with MySql and I'm building a website that deal with
user profiles. User profiles involves lists of preferences to choose from (for
example, your contry, your profession, etc.), so the user chooses from a
drop-down lists. The most natural solution for this is to
time window?) and be sure that these queries are approximately O(log
N) rather than O(N) or worse. You will need to change your database design
to fit the queries that you'll be doing. O(log N) queries would generally
be characterized by the fields you're searching or sorting on being k
;James Tu" <[EMAIL PROTECTED]>
To:
Sent: Monday, August 07, 2006 4:11 PM
Subject: Re: Database design question
Thanks everyone.
Now I feel confident that one table will be fine (Tripp's stat of
30 million records put me at ease :) ).
Cheers,
-James
On Aug 7, 2006, at 4:08
n key referencing the destinating user as well.
-Original Message-
From: James Tu [mailto:[EMAIL PROTECTED]
Sent: Monday, August 07, 2006 1:56 PM
To: mysql@lists.mysql.com
Subject: Database design question
I want to design a database for lots of users. Each user will be
managing
thei
: Database design question
I want to design a database for lots of users. Each user will be managing
their own messages. Does it make sense to create a table for each user
after they've registered?
Or should I just create one MESSAGES table and store messages there keyed
off of their user_id?
I want to design a database for lots of users. Each user will be managing
their own messages. Does it make sense to create a table for each user after
they've registered?
Or should I just create one MESSAGES table and store messages there keyed off
of their user_id?
If I create a table for e
I want to design a database for lots of users. Each user will be
managing their own messages. Does it make sense to create a table
for each user after they've registered?
Or should I just create one MESSAGES table and store messages there
keyed off of their user_id?
If I create a table fo
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
At 10:52 AM -0500 2/3/06, Adi wrote:
I am looking for a tool to integrate with mysql...I have tried DBDesigner
and would like to get my hands on software that is equivalent or better than
DBDesigner...any suggestions? FYI: I have had some problems with importing,
printing etc with DBDesigner...
Original Message-
> From: Adi [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 03, 2006 9:53 AM
> To: mysql@lists.mysql.com
> Subject: Visual database design system
>
>
> I am looking for a tool to integrate with mysql...I have tried DBDesigner
> and would like to get
Looked good, but does not suport MySQL 5 :( - cost is not really an
issue
On 2/3/06, Peter Brawley <[EMAIL PROTECTED]> wrote:
>
> Adi,
>
> We use Dezign from Datanamic. Not free, not expensive either.
>
> PB
>
> -
>
> Adi wrote:
>
> I am looking for a tool to integrate with mysql...I have
Adi,
We use Dezign from Datanamic. Not free, not expensive either.
PB
-
Adi wrote:
I am looking for a tool to integrate with mysql...I have tried DBDesigner
and would like to get my hands on software that is equivalent or better than
DBDesigner...any suggestions? FYI: I have had some
, 2006 9:53 AM
To: mysql@lists.mysql.com
Subject: Visual database design system
I am looking for a tool to integrate with mysql...I have tried DBDesigner
and would like to get my hands on software that is equivalent or better than
DBDesigner...any suggestions? FYI: I have had some problems with
I am looking for a tool to integrate with mysql...I have tried DBDesigner
and would like to get my hands on software that is equivalent or better than
DBDesigner...any suggestions? FYI: I have had some problems with importing,
printing etc with DBDesigner...
Thanks in advance...
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
ransaction, but not to the
product.
sales rep comission is relevante to the sales rep, but
not to the
transaction nor the product.
My point is, a database design can be a complex task, and the
hability an
application will have to provide solutions to the real world depends, bef
My point is, a database design can be a complex task, and the hability
an
application will have to provide solutions to the real world depends, before
anyother thing in that database design.
The is the point where almost all analisys most be done, and almost no
programming (i
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|..|..|..|
_id;
B) rejoin to your original table to get the quantity
SELECT ti.product_id, ti.date_of_inventory, i.quantity
FROM tmpInv ti
INNER JOIN inventory i
ON ti.product_ID = i.product_id
AND ti.date_of_inventory = i.date_of_inventory;
DROP TABLE tmpInv;
With this design, you won't have an inventory
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
To: mysql@lists.mysql.com
Subject: MySQL database design documentation
Hi,
I'm sure this is a stupid question, but I haven't been able to find
it myself. Surely there must be a free PHP utility to
web-administrate a MySQL database? I use CocoaMySQL
(http://cocoamysql.sourceforge.net/) o
Hi,
I'm sure this is a stupid question, but I haven't been able to find
it myself. Surely there must be a free PHP utility to
web-administrate a MySQL database? I use CocoaMySQL
(http://cocoamysql.sourceforge.net/) on my own Mac, but it isn't
suitable for online databases. Can anyone lead me
I'm trying to think of the ways I can accomplish having a master
database of countries and states/provinces that I can reference in
several other databases.
I'd like to have a table of countries available for selection by the
users in a web app, but I'm not sure of the best way to then allow t
Relational Database Design Clearly Explained, Second Edition
ISBN: 1558608206
The original edition was my first primer on relational databases. It was
an excellent read.
Ben
Maurice van Peursem wrote:
Hi,
I'm relatively new to the database-scene. I've installed MySQL on Mac
A couple of good links for databases.
Database Design (quick and dirty, but gets the points across):
http://www.geekgirls.com/menu_databases.htm - the from scratch side
SQL:
Basics: http://www.sqlcourse.com (you probably already know this stuff -
but just in case.
semi-Advanced: http
- Original Message -
From: "Maurice van Peursem" <[EMAIL PROTECTED]>
To:
Sent: Sunday, November 27, 2005 6:33 PM
Subject: MySQL database design documentation
Hi,
I'm relatively new to the database-scene. I've installed MySQL on Mac OSX
10.3, which was
Hi,
I'm relatively new to the database-scene. I've installed MySQL on Mac
OSX 10.3, which was easy. I've installed Perl support for MySQL,
which was suprisingly difficult. I've installed CocoaMySQL
(http://cocoamysql.sourceforge.net/) to create, inspect and backup
databases. And now I'm build
Matthew Lenz wrote:
anyone using openoffice:base to design mysql db's? back when I tried it
earlier this year it wasn't able to define relationships which made it
pretty much useless as a time saving tool.
Hi Matt,
Although it's slightly OT here, there is still a lot of development
going on
anyone using openoffice:base to design mysql db's? back when I tried it
earlier this year it wasn't able to define relationships which made it
pretty much useless as a time saving tool.
-Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
rsday, September 22, 2005 2:17 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: good database design
Tim Hayes wrote:
I disagree completely.
I prefer to have regard to the statement of requirement, which in this
case is a concern over performance. If following conventional design
t: Re: good database design
> This is an interesting subject area.
>
> In a data warehousing environment, one tends to adopt table structures
such
> as snowflake layouts which lead to improved performance.
>
> Createing a perfect normalised database design may well lead to
perform
> This is an interesting subject area.
>
> In a data warehousing environment, one tends to adopt table structures
such
> as snowflake layouts which lead to improved performance.
>
> Createing a perfect normalised database design may well lead to
performance
> issues.
If thi
Hi,
> > Given that the OP did not state that there were any issues with an
> > existing website, logical requirements come first. Period. No discussion
;)
>
> Logical requirements may come first, but may be overruled later by
> requirements caused by performance issues or system limitations.
Whic
Martijn Tonies wrote:
Given that the OP did not state that there were any issues with an
existing website, logical requirements come first. Period. No discussion ;)
Logical requirements may come first, but may be overruled later by
requirements caused by performance issues or system limitation
This is an interesting subject area.
In a data warehousing environment, one tends to adopt table structures such
as snowflake layouts which lead to improved performance.
Createing a perfect normalised database design may well lead to performance
issues. The more joins you have, by far the worse
d now actually you should start worrying abt the DB Tuning and harware
requirements.
sujay
-Original Message-
From: Ian Sales (DBA) [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22, 2005 2:17 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: good database design
Tim
Tim Hayes wrote:
I disagree completely.
I prefer to have regard to the statement of requirement, which in this case
is a concern over performance. If following conventional design rules
creates performance issues, then performance related issues come first when
considering design.
- persona
, any link, any info, any word is important
forme. I can't find the right start point.
Thanks
OKAN
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To:
Sent: Thursday, September 22, 2005 11:25 AM
Subject: Re: good database design
Hi,
Please re
Hello Tim,
> I disagree completely.
>
> I prefer to have regard to the statement of requirement, which in this
case
> is a concern over performance. If following conventional design rules
> creates performance issues, then performance related issues come first
when
> considering design.
Given tha
Hi,
Please reply to the list and not to me personally only.
> I want to explain my condition. I have a web site that habe 110onlne users
> at same time. But cpu usage is 2.00/2.00 (p4 3.0ghzHT)
> I think my database design is horrible because of this high cpu load.
Did you do an an
customers happy.
Tim Hayes
MYdbPAL - www.it-map.com
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: 22 September 2005 09:02
To: mysql@lists.mysql.com
Subject: Re: good database design
> I need links about good database design information for high loaded
> I need links about good database design information for high loaded web
> sites...
A database design should start with the logical data-related requirements,
not with performance related issues.
IMO, of course.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Fi
I need links about good database design information for high loaded web
sites...
regards, okan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lied,
Reema
-Original Message-
From: Gordon [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 01, 2005 8:39 AM
To: 'rtroiana'
Subject: RE: Database design query
I know what you are trying to do and I can see the logic advantage of having
a single table that defines the the gr
different foreign key definitions on one field. If not
I think you are stuck with 3 tables instead of trying to do it in one.
-Original Message-
From: rtroiana [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 31, 2005 12:23 PM
To: mysql@lists.mysql.com
Subject: Database design query
Hi All,
Hi,
i think you must normalize your table to more than one table.
Users/Groups : N:1
Groups/Groups : N:1
Table Users :
User_id
Host
Group_id
Table Groups :
Group_id
Group_parent_id<- is a another group_id
No data redondancy and robust implementation.
see for example /etc/passwd and
Hi All,
I'm trying to get data from Active Directory and storing in database. So I
have the following tables with their corresponding primary keys:
Group (GroupID)
Host (HostID)
User (UserID)
GroupMember(GroupID, MemberID)
The relatio
I haven't created real project tables yet.
But here are the test ones that I'm experimenting with.
CREATE TABLE east (
id int(11) NOT NULL auto_increment,
keywords varchar(255) default NULL,
east_1 varchar(255) default NULL,
PRIMARY KEY (id)
) ;
CREATE TABLE north (
north_id int(11) NOT
If you posted your actual table structures (SHOW CREATE TABLE xx\G) I
think I could be more helpful. Right now I am just "shooting in the dark".
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
James <[EMAIL PROTECTED]> wrote on 04/26/2005 02:15:49 PM:
> I tried that and
I tried that and maybe I'm doing something wrong but...
-I have to select the same number of columns...for each UNION
-And each of the records from the union fall under the same column
headings as the first SELECT...
I even tried to define column aliases..
SELECT `running` as `running_blah`...
-J
james tu <[EMAIL PROTECTED]> wrote on 04/26/2005 12:06:34 PM:
> I have four different activities. Each has its own set of data that
> I want to save. So, I made four different tables to hold the saved
> data. Each record also has 'keywords' field (essentially this is the
> only field that all
I have four different activities. Each has its own set of data that
I want to save. So, I made four different tables to hold the saved
data. Each record also has 'keywords' field (essentially this is the
only field that all tables have in common.)
Later on, I want to search all the keywords i
1 - 100 of 239 matches
Mail list logo