2
votes
1answer
102 views

Why can't I select from a table named range without using backticks?

I'm facing a problem with mysql. A query select * from range; works on mysql 5.0.22 but does not work mysql 5.1.61. but it works with backtick: i.e. select * from `range`; Kindly help in this ...
1
vote
1answer
212 views

MySQL Syntax error when trying to reset Joomla password

I'm trying to reset my Joomla admin password by executing the following code in MySQL: INSERT INTO `jos_users` (`id`,`name`, `username`, `password`, `params`) VALUES ...
1
vote
1answer
1k views

How can I set up mysql logs so that syntax errors are logged?

I've got mysql logging log_slow_queries or whatever, and had turned on all query logging for a moment before I found it to just be spammy and thus useless. How can I log only mysql queries that ...