Re: MySQL - LIMIT 1 on primary KEY - makes sense?
| From: | Martin Zvarík | Date: | Wed, 03 Jun 2009 20:31:00 +0000 |
| Subject: | Re: MySQL - LIMIT 1 on primary KEY - makes sense? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-46218@lists.php.net to get a copy of this message | ||
Bastien Koert napsal(a):
2009/6/3 Martin Zvarík <mzvarik@gmail.com>:"SELECT * FROM xxx WHERE primary_id=123 LIMIT 1" Is it useless (LIMIT 1) ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.phpIt doesn't do anything...you are already returning just the one row since there can only be one primary key record I know, but I thought it might have had a little performance + for the MySQL... but I guess not.