Explain Codes LogoExplain Codes Logo

Sql

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

How to Ignore "Duplicate Key" error in T-SQL (SQL Server) #

sql
sql-server
duplicate-key-error
try-catch

Solving a "communications link failure" with JDBC and MySQL

sql
connection-pooling
jdbc-configuration
mysql-optimization

Difference between datetime and timestamp in SQL Server?

sql
data-integrity
concurrency
best-practices

How can I have multiple common table expressions in a single SELECT statement?

sql
ctes
sql-queries
performance

Drop...create vs ALTER

sql
prompt-engineering
best-practices
performance