Hi,
> This is a fundamental concept in RDBMS: the use of foreign keys in
> database design.
>
> I'd just like to poll the community here, on whether it is a best
> practice, or practically essential to 'link' related tables by use of
> foreign keys.
>
> For myself, I usually do all the validi
Hello Keith,
Thanks for responding. I was actually referring to the subject of using
foreign keys, as opposed to leaving it to the calling application to do
the necessary checks. In particular issues of performance, efficiency
etc. IMHO, foreign keys add 'strictness' to the consistency of rela
IMHO I think you will find that there is a balance between
the speed of opening and reading/writing several related
smaller tables connected by FK's, rather than one mega-sized
gigantic table.
How do you normalise a table without using FK's.
Your right, MySQL does not currently do any checking
Thanks for the further input, It works perfectly ...
If you wouldn't mind please explain, the use of the b1 and b2 are they
intended as varaibles ..
On 3/17/06, Michael Stassen <[EMAIL PROTECTED]> wrote:
>
> Gregory Machin wrote:
> > Ok I tried the following
> > SELECT dealer_id, auto_id, bid_am
Maurice van Peursem wrote:
Hello,
I like to have a full outer join. if you have the following tables:
t1:
id | val
1 | A
2 | B
t2:
id | val
1 | B
2 | C
SELECT t1.id, t2.id, t1.val FROM t1 FULL OUTER JOIN t2 ON t1.val=t2.val
ORDER BY t1.id,t2.id
I want to get the following result (and
tony vong wrote:
What is the sql command to export the whole database ?
I use:
mysqldump -u [username] -p[password] [database name] > [filename]
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.ya
tony vong wrote:
What is the sql command to export the whole database ?
I use:
mysqldump -u [username] -p[password] [database name] > [filename]
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.ya
mysqldump -A -u {username} -p > {thefilenameyouwanttoputitin}
On Mar 19, 2006, at 8:47 PM, tony vong wrote:
What is the sql command to export the whole database ?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection aroun
What is the sql command to export the whole database ?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Hi all,
This is a fundamental concept in RDBMS: the use of foreign keys in
database design.
I'd just like to poll the community here, on whether it is a best
practice, or practically essential to 'link' related tables by use of
foreign keys.
For myself, I usually do all the validity checki
I installed 5.0 and 5.1-beta on three different system (all are Fedora Core 4),
and each time when I use the command-line client, I can not use the familiar
up-arrow feature that normally lets you scroll through queries issued during
previous command-line sessions. My history is completely blan
Hello,
I like to have a full outer join. if you have the following tables:
t1:
id | val
1 | A
2 | B
t2:
id | val
1 | B
2 | C
SELECT t1.id, t2.id, t1.val FROM t1 FULL OUTER JOIN t2 ON t1.val=t2.val
ORDER BY t1.id,t2.id
I want to get the following result (and in this order):
t1.id | t2
Rhino wrote:
SELECT SiteCode, TypeOfJob, count(TypeOfJob) As countJobType FROM
jobs GROUP
BY SiteCode
I think he wants something like
select SiteCode, TypeOfJob, count(TypeOfJob) As countJobType, (select *
from jobs) as alljobs, countJobType*100.0/alljobs FROM jobs GROUP BY
SiteCode
I'm pre
- Original Message -
From: shreeseva
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, March 20, 2006 01:15 AM
Subject: About Data types
Dear friends,
I am using MySQL 5.0.17 on Win XP Prof. I have created a prototype database
design in Ms Access 2003 and using MySQL Migrati
- Original Message -
From: "Zack Vernon" <[EMAIL PROTECTED]>
To:
Sent: Sunday, March 19, 2006 12:11 PM
Subject: Counting Multiple Fields
Hello,
Would be grateful for any help!
I have a table like (in reality few more fields!!!):
Id Site Code Type of Job
Hi,
I want to give quota each user's accounts. I think this is possible
cause I saw lots of hosting company do that but couldn't find anything
about that. Is there anyone know how I can put qouta on mysql? or is
there any way to move user's data file to its own directory (disk
quota)?
thanks
Cem
Hello,
Would be grateful for any help!
I have a table like (in reality few more fields!!!):
Id Site Code Type of Job
What I want to do is make reports like:
Site Code Type of JobNumber of Jobs for this type and site
Number of jobs for this site
Greetings,
Are there going to be binaries of MySQL 5.0.19 for Mac OS 10.4
PowerPC? That particular platform (mine) is still at 5.0.18 on the
download page.
Thanks,
Jan Pieter Kunst
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
18 matches
Mail list logo
