Andrew,
> ok ok I get it what you are saying if I change a tables attributes from
> varchar on one table it wont chnage another tables varchars attributes AND
> WHY THE F**K WOULD I EXPECT IT TO!,
>
> what I am asking is it necessary to make chnages to the other table.
The answer to your questio
"Andrew" <[EMAIL PROTECTED]> wrote:
>
> If I chnage a varchar in one table will it effect another related column in
> another table?
Nope.
Take a look at FOREIGN KEY with ON UPDATE CASCADE:
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
--
For technical support contra
3, 2003 9:24 AM
> To: Mike Hillyer; [EMAIL PROTECTED]; MySQL-Lista
> Subject: RE: varchar restriction
>
>
> ok ok I get it what you are saying if I change a tables
> attributes from varchar
> on one table it wont chnage another tables varchars
> attributes AND WH
: Mike Hillyer [mailto:[EMAIL PROTECTED]
>Sent: 23 June 2003 15:50
>To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; MySQL-Lista
>Subject: RE: varchar restriction
>
>
>If I have table A with a varchar and table B with a varchar, any
>modification I make to A will have NO EFFECT WHATSOEVER
more clear?
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Efficient E [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 23, 2003 8:50 AM
> To: Mike Hillyer; [EMAIL PROTECTED]; MySQL-Lista
> Subject: RE: varchar restriction
>
>
> not sure I un
It will not. If such a change is desirable, you will have to make the
change in the related table as well.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Andrew [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 23, 2003 7:57 AM
> To: MySQL-Lista
> Subject: varchar restr
