Tag: database

4144 What is the difference between "INNER JOIN" and "OUTER JOIN"? 2008-09-01T22:36:06.940

2267 Why shouldn't I use mysql_* functions in PHP? 2012-10-12T13:18:39.307

2018 How does database indexing work? 2008-08-04T10:07:12.673

1166 Insert into ... values ( SELECT ... FROM ... ) 2008-08-25T12:45:56.930

1113 What are the options for storing hierarchical data in a relational database? 2010-10-29T00:23:33.310

1065 How to list the tables in a SQLite database file that was opened with ATTACH? 2008-09-17T12:59:53.633

835 How do I quickly rename a MySQL database (change schema name)? 2008-09-15T21:22:00.090

825 MyISAM versus InnoDB 2008-08-21T14:50:52.780

726 What's the difference between identifying and non-identifying relationships? 2009-04-18T05:04:55.070

695 MongoDB vs. Cassandra 2010-05-23T17:39:56.540

665 Database, Table and Column Naming Conventions? 2008-08-11T10:27:22.780

645 What are the best practices for SQLite on Android? 2010-03-22T15:13:32.573

613 'IF' in 'SELECT' statement - choose output value based on column values 2011-05-10T13:53:31.433

571 Do you use source control for your database items? 2008-09-22T15:07:33.273

566 Database development mistakes made by application developers 2009-03-07T14:12:06.140

553 Difference between rake db:migrate db:reset and db:schema:load 2012-04-24T16:11:32.397

533 Reset identity seed after deleting records in SQL Server 2014-02-17T08:51:48.637

526 How to drop columns using Rails migration 2010-05-14T00:02:54.707

518 Multiple Indexes vs Multi-Column Indexes 2008-10-07T15:36:44.597

515 How to shrink/purge ibdata1 file in MySQL 2010-08-11T07:20:29.893

512 What is the difference between Left, Right, Outer and Inner Joins? 2009-01-15T19:07:31.377

508 Solutions for INSERT OR UPDATE on SQL Server 2008-09-20T15:00:47.833

494 Difference between scaling horizontally and vertically for databases 2012-07-29T08:40:08.583

485 MongoDB or CouchDB - fit for production? 2009-05-21T23:22:23.540

478 Skip certain tables with mysqldump 2009-01-08T17:30:17.323

446 How do I restore a dump file from mysqldump? 2008-09-19T21:27:00.673

442 Rails DB Migration - How To Drop a Table? 2010-10-26T01:52:32.497

432 What's the Hi/Lo algorithm? 2008-11-11T20:53:00.957

428 Error renaming a column in MySQL 2010-10-23T03:35:23.100

416 Difference between partition key, composite key and clustering key in Cassandra? 2014-07-25T06:49:46.067

415 Storing Images in DB - Yea or Nay? 2008-08-06T17:38:35.383

413 How do you rename a MongoDB database? 2012-02-08T21:35:39.553

408 Best way to store password in database 2009-06-28T01:50:50.563

408 Copying PostgreSQL database to another server 2009-08-06T08:56:16.287

392 How to get size of mysql database? 2009-11-14T06:40:21.020

390 Run MySQLDump without Locking Tables 2008-09-19T19:07:09.293

378 Elasticsearch query to return all records 2012-01-12T02:41:25.847

368 Compare two MySQL databases 2008-10-22T13:41:07.557

361 How to secure database passwords in PHP? 2008-09-18T23:27:03.913

351 What database does Google use? 2008-12-12T14:48:04.517

351 What is this Javascript "require"? 2012-03-28T04:18:58.647

345 Maximum length for MySQL type text 2011-07-20T18:37:45.827

326 How to select the nth row in a SQL database table? 2008-08-19T17:13:11.023

325 How to replace a string in a SQL Server Table Column 2009-05-02T09:43:52.523

324 Auto Generate Database Diagram MySQL 2008-08-05T15:45:02.930

323 When and why are database joins expensive? 2008-10-06T09:52:19.473

323 Can I have multiple primary keys in a single table? 2008-10-20T09:56:23.283

321 import sql dump into postgresql database 2011-07-27T09:50:50.780

320 List of standard lengths for database fields 2008-08-21T19:50:42.887

319 Rails :include vs. :joins 2009-07-30T19:00:51.970

312 Is storing a delimited list in a database column really that bad? 2010-09-06T18:11:25.110

300 Best database field type for a URL 2008-10-20T19:29:04.563

298 What are the performance characteristics of sqlite with very large database files? 2009-04-24T01:09:33.047

296 How do I show the schema of a table in a MySQL database? 2009-09-30T15:15:32.033

293 Versioning SQL Server database 2008-08-01T18:33:08.333

293 T-SQL Cast versus Convert 2009-04-01T21:05:48.217

287 What's the best strategy for unit-testing database-driven applications? 2008-09-28T03:26:42.120

285 Should each and every table have a primary key? 2009-05-08T14:49:14.963

278 What does character set and collation mean exactly? 2008-12-04T16:47:01.703

271 Kill a postgresql session/connection 2011-02-24T18:30:10.127

269 Good PHP ORM Library? 2008-09-20T16:44:52.230

267 How can I modify the size of column in a mysql table? 2009-08-14T18:56:54.037

264 How big can a MySQL database get before performance starts to degrade 2008-08-04T14:31:11.410

264 Extreme wait-time when taking a SQL Server database offline 2009-04-30T17:53:15.423

264 What datatype to use when storing latitude and longitude data in SQL databases? 2009-07-28T20:04:59.497

263 Is there a .NET/C# wrapper for SQLite? 2008-09-18T15:36:48.053

263 How do you query for "is not null" in Mongo? 2010-10-30T04:04:10.593

262 What are database normal forms and can you give examples? 2009-04-07T02:43:56.390

256 Entity Framework and Connection Pooling 2010-09-06T16:42:47.020

252 Differences between B trees and B+ trees 2009-05-15T18:42:14.047

249 Postgres and Indexes on Foreign Keys and Primary Keys 2009-06-09T14:56:40.663

248 How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework? 2009-03-25T19:17:43.163

246 Version of SQLite used in Android? 2010-03-10T22:37:23.363

243 Drop postgresql database through command line 2011-08-16T04:59:38.123

242 Why do you create a View in a database? 2009-08-14T15:26:28.570

242 What's the difference between MyISAM and InnoDB? 2012-09-27T05:18:04.837

240 How can I stop redis-server? 2011-08-02T10:07:50.243

239 What's wrong with foreign keys? 2008-09-17T13:25:54.570

238 First-time database design: am I overengineering? 2010-02-23T18:18:07.317

238 Rename a table in MySQL 2012-09-29T06:01:54.817

235 How to check if mysql database exists 2009-05-08T09:22:14.163

235 How can I put a database under git (version control)? 2009-05-11T03:49:31.650

234 Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in 2010-11-18T21:53:43.287

234 Proper Repository Pattern Design in PHP? 2013-04-23T18:50:05.320

233 Max length for client ip address 2009-07-02T21:12:32.083

232 What's faster, SELECT DISTINCT or GROUP BY in MySQL? 2009-02-24T12:04:19.143

231 How to cache data in a MVC application 2008-12-05T13:53:07.340

226 How Stuff and 'For Xml Path' work in Sql Server 2015-07-03T17:03:05.350

223 Django CharField vs TextField 2011-09-08T21:13:47.973

220 What's the best practice for primary keys in tables? 2008-12-03T15:30:23.450

220 Postgresql: Scripting psql execution with password 2011-06-29T15:16:02.630

219 How to check if a database exists in SQL Server? 2009-03-24T19:56:11.410

216 Is the primary key automatically indexed in MySQL? 2009-07-01T20:21:26.560

216 Best way to work with dates in Android SQLite 2011-09-09T14:22:23.900

215 Use email address as primary key? 2010-09-27T13:12:21.047

215 SQL JOIN and different types of JOINs 2013-07-30T11:48:12.387

215 Authentication plugin 'caching_sha2_password' cannot be loaded 2018-03-09T13:19:55.327

214 How should I tackle --secure-file-priv in MySQL? 2015-09-23T10:43:53.150

211 What is the difference between JOIN and UNION? 2009-05-25T04:55:16.337