Re: MySQL constraint question

2005-02-23 Thread Gerald Taylor
Thanks for these answers. I can now write this in the application and be OK with it without that nagging feeling that somebody will say upa if you just put xxx in the database then you could filter all that in your query. If it ever happens I can say, ah yes but when I wrote that we were only on

Re: MySQL constraint question

2005-02-22 Thread Martijn Tonies
> > I have a database thats full of ingredients that are placed in various > > categories. and then there are mixtures that are allowed to > > be labelled with a certain grade based on the quality and > > composition of the ingredients it is comprised from. > > But the formulas are not always the

Re: MySQL constraint question

2005-02-22 Thread SGreen
Gerald Taylor <[EMAIL PROTECTED]> wrote on 02/18/2005 10:18:29 AM: > I have a database thats full of ingredients that are placed in various > categories. and then there are mixtures that are allowed to > be labelled with a certain grade based on the quality and > composition of the ingredients it

MySQL constraint question

2005-02-18 Thread Gerald Taylor
I have a database thats full of ingredients that are placed in various categories. and then there are mixtures that are allowed to be labelled with a certain grade based on the quality and composition of the ingredients it is comprised from. But the formulas are not always the same, as long as the

Re: constraint question

2001-06-21 Thread Tyler Longren
just do: mysqldump db_name > db_name.sql Your database tables and contents will be dumped into db_name.sql Tylre - Original Message - From: ah <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 21, 2001 12:19 PM Subject: constraint question > hi &g

constraint question

2001-06-21 Thread ah
hi I am using mysql 3.23.29 under windows 2000.I have a table: create table raries( libID bigint NOT NULL AUTO_INCREMENT , lib_datsvrID bigint null, primary key (libID), constraint FK_LIBRAR_REF_584_DATASE foreign key (lib_datsvrID) refe