MySQL 5 and Condition
The word “condition” is a reserved name in MySQL 5, apparently. It was not in MySQL 4. Thus, if you have a query where you do something like this:
SELECT the_field_name AS condition FROM the_table
That causes problems.
Michi Knows
Insights on the IT world by Michi Kono
Subscribers
Pages
Categories
- Business (198)
- Dumb Ideas (19)
- Entertainment (13)
- Jobs (12)
- News (127)
- Predictions (28)
- Life (70)
- Geeky Stuff (30)
- Off-beat (13)
- Politics (8)
- Programming (77)
- Javascript (17)
- Libraries (4)
- MySQL (9)
- PHP (33)
- Random Code (9)
- Business (198)
My Sites
Calendar
Recent Comments
-
Recent Posts
- Did Digg Miss the Boat Again?
- PHP Tip: Always Put Constants on the Left in Boolean Comparisons
- Is Your Blog Not Receiving Pingbacks? I Fixed Mine.
- Autocast Variables Whitepaper: What I Want to See in PHP 6
- A PHP/MySQL Bug Most People Have But Don’t Realize
- Representing heirarchical data in MySQL
- Incentives and the Related Dangers
- Is PHP here to stay?
- The Destruction of the Head Hunting Industry
- Q: Hiding JS Files? A: Impossible
Twitter Stream
- Did Digg Miss the Boat Again? http://www.michiknows.com/2010/08/26/did-digg-miss-the-boat-again/ # 2010/08/26
- RT @myzt: The main idea of "Inception": if you run a VM inside a VM inside a VM inside a VM, everything will be very slow # 2010/08/16
- A PHP/MySQL Bug Most People Have But Donât Realize http://bit.ly/b3tdJX # 2010/07/26
- I thought this article about Reddit's scaling lessons was interesting. http://bit.ly/coW5N0 # 2010/05/18
- I just discovered iTunes U. It is filled with free lectures (video and audio) on everything I'm interested in. Awesome. # 2010/05/02
Tags