MySQL Forums :: Constraints :: LIMIT 1
LIMIT 1
Posted by: Hugh Vassel ()
Date: May 21, 2007 08:52AM
Is "LIMIT 1" Required for SELECT-Querys using a Primary-Key in the WHERE-Constraint.
i. e.:
SELECT *
FROM table
WHERE id = x
LIMIT 1;
Edited 1 time(s). Last edit at 06/30/2007 07:18AM by Hugh Vassel.
i. e.:
SELECT *
FROM table
WHERE id = x
LIMIT 1;
Edited 1 time(s). Last edit at 06/30/2007 07:18AM by Hugh Vassel.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| LIMIT 1 | 71344 | Hugh Vassel | 05/21/2007 08:52AM |
| Re: LIMIT 1 | 16425 | Brent Morgan | 05/22/2007 03:03PM |
| Re: LIMIT 1 | 10129 | Hugh Vassel | 06/04/2007 08:37AM |
| Re: LIMIT 1 | 7569 | Andene Stephenson | 04/10/2008 07:21PM |
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.
© 2013, Oracle Corporation and/or its affiliates