RE: [ cf-dev ] OT----MySQL

[Christopher Chaduka]

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]

-- 
** 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]