Amass

MySQL 4.1 and dashes

October 5th, 2007 Luke

I’m working on a quick, one-off Facebook application right now. And, while setting up the basic PHP stuff, I encountered an issue with MySQL that took a pathetically long time to solve.

Here’s the gist of it: MySQL 4.1(I don’t know about higher versions) doesn’t support dashes inside table names. Underscores are fine, but dashes are not.

Example: notesbook-pages does not work; notesbook_pages does.

This bit me way too hard.

Posted in facebook, mysql | No Comments »