Explain Codes LogoExplain Codes Logo

Sql

Import SQL file into mysql

sql
import
mysql
permissions

Mysql search and replace some text in a field

sql
backup
transactions
replace

Is the SQL WHERE clause short-circuit evaluated?

sql
query-optimization
best-practices
short-circuiting

Fastest way to determine if record exists

sql
exists
nolock
performance

Sqlite DateTime comparison

sql
date-comparison
datetime-functions
error-handling

List of special characters for SQL LIKE clause

sql
like-clause
wildcards
database-collation

Replacing NULL with 0 in a SQL server query

sql
null-handling
performance
aggregate-functions

How to generate a new Guid in stored procedure?

sql
guid
stored-procedure
best-practices

Mysql SELECT only not null values

sql
nulls
database-normalization
queries

How to use multiple CTEs in a single SQL query?

sql
ctes
query-optimization
best-practices

Possible to perform cross-database queries with PostgreSQL?

sql
cross-database
dblink
performance-optimization

How can I create a copy of an Oracle table without copying the data?

sql
table-copy
data-integrity
performance

Sql NVARCHAR and VARCHAR Limits

sql
nvarchar
varchar
dynamic-sql

How to order by column A and then by column B?

sql
order-by
where-clause
troubleshooting

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