database 2,132

  1. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  2. Why shouldn't I use mysql_* functions in PHP?
  3. How does database indexing work?
  4. Insert into … values ( SELECT … FROM … )
  5. What are the options for storing hierarchical data in a relational database?

  6. How to list the tables in an SQLite database file that was opened with ATTACH?
  7. MyISAM versus InnoDB
  8. How do I quickly rename a MySQL database (change schema name)?
  9. What's the difference between identifying and non-identifying relationships?
  10. MongoDB vs. Cassandra
  11. What are the best practices for SQLite on Android?
  12. Database, Table and Column Naming Conventions?
  13. 'IF' in 'SELECT' statement - choose output value based on column values
  14. Database development mistakes made by application developers
  15. Do you use source control for your database items?
  16. Difference between rake db:migrate db:reset and db:schema:load
  17. How to shrink/purge ibdata1 file in MySQL
  18. What is the difference between Left, Right, Outer and Inner Joins?
  19. MongoDB or CouchDB - fit for production?
  20. How to drop columns using Rails migration
  21. Solutions for INSERT OR UPDATE on SQL Server
  22. Multiple Indexes vs Multi-Column Indexes
  23. Reset identity seed after deleting records in SQL Server
  24. Skip certain tables with mysqldump
  25. Error renaming a column in MySQL
  26. What's the Hi/Lo algorithm?
  27. Storing Images in DB - Yea or Nay?
  28. Rails DB Migration - How To Drop a Table?
  29. How do I restore a dump file from mysqldump?
  30. Difference between scaling horizontally and vertically for databases
  31. Run MySQLDump without Locking Tables
  32. Copying PostgreSQL database to another server
  33. Difference between partition key, composite key and clustering key in Cassandra?
  34. Best way to store password in database
  35. How do you rename a MongoDB database?
  36. Compare two MySQL databases
  37. What is the ideal data type to use when storing latitude / longitudes in a MySQL database?
  38. How to secure database passwords in PHP?
  39. How to get size of mysql database?
  40. Elasticsearch query to return all records
  41. What database does Google use?
  42. Maximum length for MySQL type text
  43. What is this Javascript “require”?
  44. Rails :include vs. :joins
  45. When and why are database joins expensive?
  46. How to replace a string in a SQL Server Table Column
  47. Can I have multiple primary keys in a single table?
  48. Auto Generate Database Diagram MySQL
  49. How to select the nth row in a SQL database table?
  50. List of standard lengths for database fields