MySQL's syntax for the UPDATE SQL statement does not
allow for the use of multiple tables. You cannot
update existing records in one table with data from
another using SQL statements at the interactive
prompt. There are work-arounds; but I they are both
incovenient and very inefficient. Fixing this has
been on their todo list for a very long time; but
without any priority.
This was the most significant reason I switched from
MySQL to PostgreSQL. There are other great reasons
switch; but I am a newbie and didn't know what they
were at the time. ;-)
Best of luck,
Andrew Gould
--- Tom Ince <tince@acsinc-nj.com> wrote:
> I am attempting to convert an database currently
> running on Informix to
> a free database on Linux (RedHat 6.1). I have a
> question.....
>
> I learned that MySQL, does not maintain foreign
> keys, which affects me
> because I need to use things like CHECK in the
> CREATE TABLE statements.
> So thats why I am not trying PostgreSQL. Does
> PostgreSQL support
> foreign keys? Are there any other quirks I might
> run into as far as
> SQL syntax goes?
>
> Thank In Advance,
>
> Thomas Ince
> Software Systems Engineer
> Atlantic Consulting Services
> Shrewsbury, NJ
> tince@acsinc-nj.com
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org
__________________________________________________
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com