MySQL (error) Code Reference

ER_ERROR_ON_RENAME

---

#define ER_ERROR_ON_RENAME 1025

---

Got this when I was attempted to alter an existing table that had foreign keys. Apparently when you alter a table - it creates a new temporary table and does a quick swap of the existing table for the new one. But if the existing table has dependencies - it wont work.

ER_TABLEACCESS_DENIED_ERROR

---

Sample Message:
SELECT command denied to user ‘myapp’@'127.0.0.1′ for table ‘user’

---

Got this in SQLyog when I attempted to manage permissions - which tried to access the user table & I my login didn’t have permission to do so

Hi,

I’m Jason, a Win32/Linux developer that’s making the move from Oracle to MySQL**.  And along the way I noticed a certain lack of  unified MySQL error listing sites - or at least like the one I’m accustomed to - http://ora-code.com

This site is a poor-mans knock off of ora-code.com ;-)  As well as a place for me to document the causes of error codes I come across and my sperlunking through the MySQL experience.

Enjoy.

 -Jason De Arte

**reasons for the switch are not important, there are plenty of forums out their that will debate the merits of either DB technology for years to come.  I will not participate in these debates.  My reason is simple, my employer which is currently using Oracle decided to use me and my project as a MySQL test bed to find out the limitations/advantages of both technologies.