MySQL – Reordering Table Fields

Every now and then I find myself adding a new field to a table as an after thought, this results in the column being listed last in your database client and depending on the importance my not be grouped next to the field you’d like it beside. I’m guilty of being very picky about what [...]

Tags: , , , ,

  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments

Postgres – Column “name” Does Not Exist

I don’t use Postgres very often, as I prefer MySQL, however a project I took over was built off Postgres and I find myself running into silly little road blocks. Today I encountered one that made me want to slap the developer when I finally realized what was going on. I created a simple insert [...]

Tags: , , ,

  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS
read comments