bind-address question

2005-01-18 Thread Cere Davis
Hi everyone, I would like to bind mysqld to more than one IP address (localhost and my private unrouted interface). Is there a way to get --bind-address to bind to more than one IP? I have been unsucessfull when trying comma/space delimited arguments to bind-address, etc. Thanks, -Cere -- M

foreign key constraints are driving me crazy!

2004-03-04 Thread Cere Davis
So I have made a table called 'uid' where on uid is the only field in the table. Then I make another table called 'users' where there are two fields, 'uid1' and 'uid2' and both uid values have foreign key constraints referencing the 'uid' field in the uid table. No problem, tables are created

constraints within a table

2004-03-04 Thread Cere Davis
Hi everyone, I have a table where I would like members of a uid field to be limited by the range of values that are in another field. What I am looking for would be taken care of with the enum() operator except I need the range of values to be dynamic - because uid will change. I've been told