List:General Discussion« Previous MessageNext Message »
From:JohnHomer Date:November 7 2001 4:36am
Subject:Re: Re: normalization
View as plain text  
he probably means, creation of table relationships

you join tables in mysql right with your select query.

like

select table1.* from table1 left join table2 on
table1.id = table2.id etc etc....

thats the way to do it in mysql.

cheers.


John Homer H. Alvero
http://www.fag.com



Sherwin Ang wrote:

>Isn't it database normalization a part of good database design rather than
>the rdbms itself?
>
>regards,
>
>Sherwin Ang
>Web Programmer / Systems Administrator
>Alchemy Solutions
>
>Tridel Technologies, Inc.
>7th Floor Hanston Building
>Emerald Ave., Ortigas Center
>Pasig City
>
>Tel: (632) 634-5141/ (632) 634-5140
>Fax: (632) 634-5139
>
>----- Original Message -----
>From: "Michael P. Carel" <mikecarel@stripped>
>To: <mysql@stripped>
>Sent: Wednesday, November 07, 2001 10:52 AM
>Subject: Fw: normalization
>
>>
>> Hi there,
>>
>>  Im just a MySQL newbie and i would like to ask question to any body
>>  regarding the MySQL normalization.
>>  I've red alot of manuals regarding MySQL but i havent seen any document
>> that
>>  would answer my problem.
>>  I whant to normalize one of my MySQL database table field with the other
>>  table field (basic concept of database normalization) but i havent red
>>  regarding the MySQL command that will do this kind of normalization like
>> the
>>  MSaccess of microsoft that it can create a database model and normalize
>it
>>  within.
>>
>>  Please help.
>>
>>
>>  Regards,
>>
>>  Michael P. Carel
>>  Systems Administrator
>>
>>
>>  TEAM PACIFIC CORPORATION
>>  FTI Taguig Metro, Manila. PHIL.
>>  Tel. Nos.  (02) 838-50-05 local 363
>>                 (02) 838-84-38 direct
>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread90299@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-john=leyte.ph@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>

__________________________________
www.edsamail.com
Thread
Re: Re: normalizationJohnHomer7 Nov