Explain Codes LogoExplain Codes Logo

Sql

Mysql - How to quit/exit from stored procedure

sql
best-practices
error-handling
stored-procedures

Mysql ON DUPLICATE KEY UPDATE for multiple rows insert in single query

sql
bulk-insertions
sql-injection
decimal-values

How do I subtract using SQL in MYSQL between two date time values and retrieve the result in minutes or seconds?

sql
timestampdiff
timediff
time_to_sec

Count distinct values

sql
distinct-values
sql-queries
data-visualization

Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio

sql
prompt-engineering
best-practices
dataframe

In MySQL, how to copy the content of one table to another table within the same database?

sql
data-transfer
sql-queries
database-management

How can I tell when a MySQL table was last updated?

sql
database-management
mysql-optimization
timestamping

With (NOLOCK) vs SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

sql
data-integrity
performance-optimization
database-isolation-levels

Sql Server: Arithmetic overflow error converting expression to data type int

sql
overflow-error
data-type
sql-server

When can I save JSON or XML data in an SQL Table

sql
json-optimization
performance-tuning
database-design

How to use LIKE with column name

sql
pattern-matching
sql-server
mysql

Determine Oracle null == null

sql
null-handling
performance-optimization
database-queries

How do I generate a SQL script from my diagram in MySQL Workbench?

sql
sql-scripting
mysql-workbench
database-design

In SQL Server, when should you use GO and when should you use semi-colon ;?

sql
sql-best-practices
sql-syntax
sql-performance

Strings as Primary Keys in MySQL Database

sql
database-design
performance-optimization
data-integrity

Why does MySQL report a syntax error on FULL OUTER JOIN?

sql
join
union
left-join

Convert integer to text in SQLite's SELECT query?

sql
data-extraction
dynamic-queries
type-consistency

Check if a parameter is null or empty in a stored procedure

sql
sql-hacks
best-practices
flow-control

Mysql Workbench: How to keep the connection alive

sql
mysql-workbench
ssh-tunnel
connection-timeout

Coalesce Function in TSQL

sql
null-handling
sql-queries
ansi-sql-standard
explain.codes / Sql