Explain Codes LogoExplain Codes Logo

Sql

Mysql Results as comma-separated list

sql
group-concat
sql-injection
string-aggregation

Mysql: Get character-set of database or table or column?

sql
character-set
best-practices
data-migration

How to calculate percentage with a SQL statement

sql
percentage-calculation
window-functions
data-accuracy

Combining UNION and LIMIT operations in MySQL query

sql
union
limit
pagination

Using a Conditional Update Statement in SQL

sql
conditional-update
case-statement
best-practices

Mysql, better to insert NULL or empty string?

sql
null
empty-string
data-integrity

Select statement to find duplicates on certain fields

sql
duplicates
subqueries
window-functions

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

sql
constraint-violation
data-integrity
debugging

How to combine date from one field with time from another field - MS SQL Server

sql
datetime
performance
readability

Right query to get the current number of connections in a PostgreSQL DB

sql
postgresql
database
connections

Cte error: "Types don't match between the anchor and the recursive part"

sql
data-types
casting
null-handling

How can I group by datetime column without considering time

sql
grouping
datetime
performance

Sql order string as number

sql
string-sorting
performance
cte

What is the best tool to compare two SQL Server databases (schema and data)?

sql
database-comparison
tools
synchronization

Converting Select results into Insert script - SQL Server

sql
insert-scripts
dynamic-sql
stored-procedures

Error Code: 2013. Lost connection to MySQL server during query

sql
mysql
performance
timeout

Postgres manually alter sequence

sql
sequences
setval
database-performance

New Line Issue when copying data from SQL Server 2012 to Excel

sql
new-line
excel
ssms

How do I query between two dates using MySQL?

sql
date-queries
date-format
string-to-date

Can I concatenate multiple MySQL rows into one field?

sql
group-concat
distinct
data-aggregation