On Sunday 18 February 2007 11:24, Uri Even-Chen wrote: > On 2/18/07, Arieh Skliarouk <[EMAIL PROTECTED]> wrote: > > http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-foreign-keys.html > > Thanks! I didn't know about InnoDB and Foreign Keys. > > Is it possible to define Primary Keys and Foreign Keys with more than > one field? I used Access to define keys with up to 5 fields.
In postgresql you can definately do. However, i suspect you have a worse problem of a poor design for your tables. Read about ERD and convertion rules of ERD to relations. > > The Access visual interface is very convenient. Does MySQL have a > similar interface? > > Which text encoding should I use? Should I use Unicode (UTF-8), or > Hebrew Windows encoding? > > Uri. > > ================================================================= > To unsubscribe, send mail to [EMAIL PROTECTED] with > the word "unsubscribe" in the message body, e.g., run the command > echo unsubscribe | mail [EMAIL PROTECTED] -- Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info WARNING TO SPAMMERS: see at http://members.lycos.co.uk/my2nis/spamwarning.html ================================================================To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
