Explain Codes LogoExplain Codes Logo

Sql

Min/max vs ORDER BY and LIMIT

sql
performance
indexing
query-optimization

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

sql
mysql
socket-connection
troubleshooting

Select INTO in MySQL

sql
create-table
insert-into
performance

Left join without duplicate rows from the left table

sql
left-join
outer-apply
distinct

How do I limit the number of rows returned by an Oracle query after ordering?

sql
pagination
offset
fetch

Increment value in MySQL update query

sql
increment
sql-injection
transactions

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
explain.codes / Sql