>>>>> "Mike" == Mike<mickalo>Blezien  <[EMAIL PROTECTED]> writes:

Mike> I don't believe MySQL supports REFERENCES in the CREATE TABLE.
Mike> Is there an alternative using MySQL??

Actually, MySQL does support the syntax, it just doesn't do anything.
(At least, this has been the situation for the last two years or so;
I'm not sure exactly which version this came about in.)

You can safely remove it; it's just an indication that "bus_id" is
slaved off bus_id in the bus_info table.

I was taking quite a few guesses at the existing structure of your
tables, and the SQL I used wasn't really any specific dialect (it is
probably reasonably close to Oracle, since that's what I've been using
the most lately, but it's by no means guaranteed to even have correct
syntax...)

t.












Reply via email to