Perl Guru Forums: Perl Programming Help: DBI: Limiting mySQL entries

CGI/Perl Guide | Learning Center | Forums | Advertise | Login

Site Search: in


	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	LOG IN

Home: Perl Programming Help: DBI:
Limiting mySQL entries

skirrow
stranger

Jan 23, 2003, 7:36 AM

Post #1 of 3 (2478 views)

Limiting mySQL entries	Can't Post

Hi,
I was wondering if you can limit entries in a mySQL table somehow with a mySQL command when creating the table or similar? Or is the only way to read the db and count entries and just not write to it if it equals the limit?
Thanks
- Neil
--
http://www.locked-area.com/
http://www.opencrypt.com/

Jasmine
Administrator / Moderator

Jan 23, 2003, 8:47 AM

Post #2 of 3 (2475 views)

Re: [skirrow] Limiting mySQL entries [In reply to]	Can't Post

As far as I know, you can't limit the number of rows a table can have. You can do a quick count of existing rows by executing the following MySQL command:

Code

SELECT count(*) FROM table_name

and then compare it to a number you have defined elsewhere.

(This post was edited by Jasmine on Jan 23, 2003, 8:48 AM)

skirrow
stranger

Jan 23, 2003, 9:14 AM

Post #3 of 3 (2471 views)

Re: [Jasmine] Limiting mySQL entries [In reply to]	Can't Post

That's what I thought. Oh well.
Thanks for responding!
- Neil
--
http://www.locked-area.com/
http://www.opencrypt.com/

Search for (options)

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives