Explain Codes LogoExplain Codes Logo

Sql

Mysql very slow for alter table query

sql
alter-table
performance
best-practices

How to check DB2 version

sql
db2
version-check
sql-syntax

How do I get textual contents from BLOB in Oracle SQL?

sql
blob-extraction
character-set
oracle-19c

Optimal way to concatenate/aggregate strings

sql
string-aggregation
performance
best-practices

Does PostgreSQL support "accent insensitive" collations?

sql
unaccent
full-text-search
collations

How to do a count on a union query

sql
union
count
subquery

How do I change db schema to dbo

sql
schema-change
database-backup
best-practices

How to bulk delete a range of records in MySQL?

sql
bulk-delete
data-backup
foreign-key

Rails includes with conditions

sql
eager-loading
performance
joins

Sqlite - ORDER BY RAND()

sql
random
performance
datasets

Is it possible to GROUP BY multiple columns using MySQL?

sql
group-by
aggregate-functions
distinct

Alter TABLE to add a composite primary key

sql
composite-key
foreign-key
data-integrity

Update multiple rows with different values in one query in MySQL

sql
case
join
upsert

Sql Server Insert if not exists

sql
race-conditions
merge
performance-optimization

Sql multiple column ordering

sql
multiple-column-sort
order-by
case-statements

Import SQL file into mysql

sql
import
mysql
permissions

Mysql search and replace some text in a field

sql
backup
transactions
replace

Is the SQL WHERE clause short-circuit evaluated?

sql
query-optimization
best-practices
short-circuiting

Fastest way to determine if record exists

sql
exists
nolock
performance

Sqlite DateTime comparison

sql
date-comparison
datetime-functions
error-handling