Explain Codes LogoExplain Codes Logo

Sql

How to properly set up a PDO connection

sql
database-connections
pdo-configuration
error-handling

Group by with union MySQL select query

sql
best-practices
group-by
union

How to update Identity Column in SQL Server?

sql
identity-insert
data-integrity
database-design

How to use RETURNING with ON CONFLICT in PostgreSQL?

sql
upsert
concurrency-management
performance-optimization

Database design for a survey

sql
database-design
survey-design
sql-queries

Error 1115 (42000): Unknown character set: 'utf8mb4'

sql
mysql
character-set
database-configuration

Sql Server 2005 Using DateAdd to add a day to a date

sql
dateadd
datetime
sql-server

Sql select everything in an array

sql
sql-injection
array-data-types
query-efficiency

Using COALESCE to handle NULL values in PostgreSQL

sql
prompt-engineering
best-practices
data-integrity

Sql-script: How to write ALTER statements to set Primary key on an existing table?

sql
best-practices
database
sql-scripts

List all sequences in a Postgres db 8.1 with SQL

sql
database-migration
postgres-sequences
sql-queries

How to find the row with a minimum value in a field in MySQL?

sql
subquery
performance
best-practices

T-sql Substring - Last 3 Characters

sql
substring
sql-functions
string-manipulation

How do I UPDATE a row in a table or INSERT it if it doesn't exist?

sql
upsert
concurrency
best-practices

Sqlite - How do you join tables from different databases?

sql
database-connections
exception-handling
query-optimisation

Wait on the Database Engine recovery handle failed. Check the SQL server error log for potential causes

sql
installation
best-practices
database-engine

Convert output of MySQL query to utf8

sql
utf8-encoding
mysql-query
data-integrity

How do I format date and time on ssrs report?

sql
formatting
datetime
ssrs

Drop MySQL databases matching some wildcard?

sql
database-management
sql-queries
data-backup

How do I perform a GROUP BY on an aliased column in SQL Server?

sql
join
subqueries
ctes