Re: MySQL - LIMIT 1 on primary KEY - makes sense?
| From: | Bastien Koert | Date: | Wed, 03 Jun 2009 20:18:20 +0000 |
| Subject: | Re: MySQL - LIMIT 1 on primary KEY - makes sense? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46217@lists.php.net to get a copy of this message | ||
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.php
>
>
It doesn't do anything...you are already returning just the one row
since there can only be one primary key record
--
Bastien
Cat, the other other white meat