I've been working with mysql/php for many years, and although there is no substitute for the command line when it comes to certain tasks (like running mysqldump), there are a few MySql GUI programs that I use for almost all of my mysql database development. I've tested many commercial products, but in the end I still wind up using these free GUI tools for MySql … [Read more...] about Free MySQL GUI tools for Database Development and Maintenance
Database
mySql error 1005 (errno: 150)
mySql error 1005 (errno: 150) solution This mysql error occurs when creating a table with the InnoDB engine and is basically telling you that there is a "foreign key problem" with your schema. The thing to check to fix this error is to make sure that your foreign key fields are of the same datatype as their source fields. As an example, assume the main table is "people", … [Read more...] about mySql error 1005 (errno: 150)
PHP/MySQL: How to Store Queries in a Separate Include File
When implementing a php/mysql database (or any database for that matter), it's sometimes easy to have all of the queries located in one place, as opposed to having them hard-coded into the pages. If the queries are hard-coded in, and the queries are reused on multiple pages (which they often are), it can be a cumbersome task to update all of the queries. Having hard-coded … [Read more...] about PHP/MySQL: How to Store Queries in a Separate Include File