On 02 Mar 2001 12:11:22 -0700, Tony Foiani <[EMAIL PROTECTED]> wrote:
Tony,
I don't believe MySQL supports REFERENCES in the CREATE TABLE. Is there an
alternative using MySQL??
>>If the words are always whole, you will get much better performance by
>>normalizing this into another table. Add a (or use an existing)
>>unique identifier to your "bus_info" table, then use that unique ID to
>>establish a 1-to-many relationship into another table of nothing but:
>>
>>| CREATE TABLE bus_search_words
>>| (
>>| bus_id INTEGER REFERENCES bus_info ( bus_id ),
>>| search_word VARCHAR(20),
>>| INDEX ( search_word )
>>| )
Mike(mickalo)Blezien
========================================
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=========================================
