Results 1 to 2 of 2
Thread: SQL syntax questions
Nov 24, 2004, 12:52 #1
- Join Date
- Aug 2001
- Hattiesburg, MS
- 0 Post(s)
- 0 Thread(s)
SQL syntax questions
I've got a book here on SQL, as well as, several PHP/MySQL books, but I'm having problems figuring out three things.
1. What is the * for in "SELECT * FROM tbl_name"?
2. I'm looking at the MySQL docs on DATE_FORMAT, and the only examples it gives are in the format "SELECT DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');" How can I apply this in PHP? The result of the query will be the correctly formatted date?
3. Can functions like DATE_FORMAT only be applied after SELECT or can they be elsewhere in the statement?
Nov 24, 2004, 13:14 #2Originally Posted by subnet_rx
Originally Posted by subnet_rx