Correctly Using SQL

[MemphiS]

Just wondering about a few things

 

mysql_query("SELECT test FROM table WHERE id = '1' LIMIT 1");

Should i place LIMIT 1 to clarify the query?

 

mysql_query("DELETE FROM table WHERE table.id = '1' LIMIT 1");

 

or should i simply go:

 

mysql_query("DELETE FROM table WHERE id = '1' LIMIT 1");

 

Thanks for your responces

 

Anything else that is "good" practice could you post aswell..

[Illusion]

DELETE FROM table WHERE id = '1' LIMIT 1 will work no need to specify like WHERE table.id = '1' unless you use multiple tables with same name of columns.

[fenway]

Well, assuming that's the UID, the limit isn't necessary either.... but personally, I always use table aliases all the time, so that if I need to add another table, I don't have to change anything.