How do you manage databases in development, test, and production? *

Question I've had a hard time trying to find good examples of how to manage database schemas and data between development, test, and pro...

Read More

Multiple foreign keys? *

Question I've got a table that is supposed to track days and costs for shipping product from one vendor to another. We (brilliantly :p) ...

Read More

Add 1 to a field *

Question How do I turn the following 2 queries into 1 query $sql = "SELECT level FROM skills WHERE id = $id LIMIT 1;"; $result ...

Read More

Issues using MS Access as a front-end to a MySQL database back-end? *

Question Two users wanted to share the same database, originally written in MS Access, without conflicting with one another over a single MD...

Read More

Bigger than a char but smaller than a blob *

Question Char's are great because they are fixed size and thus make for a faster table. They are however limited to 255 characters. I wa...

Read More

How do I retrieve my MySQL username and password? *

Question I lost my MySQL username and password. How do I retrieve it? Answer Stop the MySQL process. Start the MySQL process wit...

Read More

How do I Concatenate entire result sets in MySQL? *

Question I'm trying out the following query: SELECT A,B,C FROM table WHERE field LIKE 'query%' UNION SELECT A,B,C FROM table ...

Read More

Distribution of table in time *

Question I have a MySQL table with approximately 3000 rows per user. One of the columns is a datetime field, which is mutable, so the rows a...

Read More

SQLite vs MySQL *

Question SQLite is a single-file based database and MySQL is a normal database. That's great, but I'm not sure which is faster where...

Read More

Create a new Ruby on Rails application using MySQL instead of SQLite *

Question I want to create my Rails application with MySQL, because I like it so much. How can I do that in the latest version of Rails inste...

Read More

Multiple Updates in MySQL *

Question I know that you can insert multiple rows at once, is there a way to update multiple rows at once (as in, in one query) in MySQL? ...

Read More

MySQL/Apache Error in PHP MySQL query *

Question I am getting the following error: Access denied for user 'apache'@'localhost' (using password: NO) ...

Read More

What do I need to escape when sending a query? *

Question When you execute a SQL query, you have to clean your strings or users can execute malicious SQL on your website. I usually just ...

Read More

Auto Generate Database Diagram MySQL *

Question I'm tired of opening Dia and creating a database diagram at the beginning of every project. Is there a tool out there that will...

Read More

Mechanisms for tracking DB schema changes *

Question What are the best methods for tracking and/or automating DB schema changes? Our team uses Subversion for version control and we...

Read More

How big can a MySQL database get before performance starts to degrade *

Question At what point does a MySQL database start to lose performance? Does physical database size matter? Do number of records matt...

Read More

Python and MySQL *

Question I can get Python to work with Postgresql but I cannot get it to work with MySQL. The main problem is that on the shared hosting acc...

Read More

SQL Server 2005 implementation of MySQL REPLACE INTO? *

Question MySQL has this incredibly useful yet properitary REPLACE INTO SQL Command. I wonder: Can this easily be emulated in SQL Server ...

Read More

Throw an error in a MySQL trigger *

Question If I have a trigger before the update on a table, how can I throw an error that prevents the update on that table? Answer Here i...

Read More

Binary Data in MySQL *

Question How do I store binary data in MySQL ? Answer The answer by phpguy is correct but I think there is a lot of confusing additional ...

Read More