database 1714

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