June 2005
Intermediate
720 pages
20h 6m
English
The most common SQL errors are caused by the following issues:
Unbalanced use of quotation marks or parentheses
Unescaped apostrophes in column values
Misspelling a column name, table name, or function
Ambiguously referring to a column in a join
Placing a query’s clauses (WHERE, GROUP BY, ORDER BY, LIMIT) in the wrong order
Furthermore, when using MySQL you can also run across the following:
Unpredictable or inappropriate query results
Inability to access the database
Difficulty starting MySQL
Since you’ll be running the queries for your dynamic Web sites from PHP, you need a methodology for debugging SQL and MySQL errors within that context (PHP will not report a problem with your SQL).
Read now
Unlock full access