Re inserting duplicate records I havn't dealt with this and MySQL-Front is not helped with an online faq, I`ll look at mysql.com for more info later, what GUI frontend do you use for MySQL instead of the above?
Colm -----Original Message----- From: Christopher Chaduka [mailto:[EMAIL PROTECTED] Sent: 07 March 2003 15:59 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT----MySQL I haven't used MySQL-Front, but there's a IGNORE option to the INSERT statement which allows you to duplicate records, ...ummm duplicate primary keys that is. ..something like: insert ignore into tblUsers () values (); At 15:47 03/07/2003 +0000, you wrote: > > Anybody know how to limit the number of records that can be > > inserted in a field or table in MySQL, using MySQL-Front, > > also how to allow duplicate records. > >What do you mean by this? It's quite a confusing statement. Could you >clarify? > >Paul > >PS Why do you want to duplicate records? > > > >-- >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 25/02/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 25/02/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
