On Fri, Nov 28, 2008 at 5:52 PM, Fergus Gibson <[EMAIL PROTECTED]> wrote:
> On Thu, Nov 27, 2008 at 11:19 AM, Bastien Koert <[EMAIL PROTECTED]> wrote:
> > 2. It is possible to use the application to handle the keys instead of
> the
> > database, it involves more work around key checking / validati
On Thu, Nov 27, 2008 at 11:19 AM, Bastien Koert <[EMAIL PROTECTED]> wrote:
> 2. It is possible to use the application to handle the keys instead of the
> database, it involves more work around key checking / validation before
> creating or updating records, but it can be done if the INNODB table ty
pdated too.
> (5) There are options other than ON UPDATE and ON DELETE. Give'm a look.
>
> Good luck, and welcome to the DB development club.
>
> Cheers,
> Adam
>
> -Original Message-
> From: mrfroasty [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November
d ON DELETE. Give'm a look.
Good luck, and welcome to the DB development club.
Cheers,
Adam
-Original Message-
From: mrfroasty [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 27, 2008 5:19 AM
To: php-db@lists.php.net
Subject: [PHP-DB] re:database tables relations advice
I
danaketh wrote:
> This is solved by using FOREIGN KEY but I'm not sure if MySQL have
> them present or just planned for some future release.
>
> mrfroasty napsal(a):
>> I am quite new to database designs, I have a problem in my design...I
>> can actually feel it, but I am not quite sure if there is
maruti wrote:
> hey lemme knoe, how many columns are you planning for?
> y not put table B columns in table A??
> if you are least bothered about data normalizations, simply go the way
> you want to.
> userId Name Age Age Sex Occupation Location
> all the data which has correspondence with userid
This is solved by using FOREIGN KEY but I'm not sure if MySQL have them
present or just planned for some future release.
mrfroasty napsal(a):
I am quite new to database designs, I have a problem in my design...I
can actually feel it, but I am not quite sure if there is a feature in
mysql or I h
I am quite new to database designs, I have a problem in my design...I
can actually feel it, but I am not quite sure if there is a feature in
mysql or I have to solve it with programming.
Example:
CREATE TABLE A (
user_id int(16) NOT NULL auto_increment,
..ot
