Explain Codes LogoExplain Codes Logo

Sql

Postgresql "Column does not exist" but it actually does

sql
best-practices
sql-syntax
database-structure

If EXISTS, THEN SELECT ELSE INSERT AND THEN SELECT

sql
transaction-control
database-management
sql-server

How to drop multiple tables in PostgreSQL using a wildcard

sql
database-management
postgresql
best-practices

Howto? Parameters and LIKE statement SQL

sql
sql-injection
stored-procedures
performance-tuning

How to rollback or commit a transaction in SQL Server

sql
transaction-handling
error-handling
database-optimization

How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?

sql
file-system-permissions
mysql-errorcode-13
apparmor

How to speed up insertion performance in PostgreSQL

sql
performance
best-practices
optimization

Transactsql to run another TransactSQL script

sql
sqlcmd-mode
dynamic-execution
script-automation

Not all parameters were used in the SQL statement (Python, MySQL)

sql
parameterized-queries
sql-injection
database-connection

How do I add an auto_increment primary key in SQL Server database?

sql
best-practices
performance
data-structure

Postgresql tables exist, but getting "relation does not exist" when querying

sql
database-management
postgresql
schema-management

How to display open transactions in MySQL

sql
transactional-integrity
reconnection-mechanisms
transactional-anomalies

How to create a unique index on a NULL column?

sql
unique-index
null-values
sql-server

How to get list of dates between two dates in mysql select query

sql
recursive-queries
date-range
performance-optimization

What are projection and selection in SQL?

sql
best-practices
relational-algebra
database-performance

Sql function as default parameter value?

sql
default-values
stored-procedures
data-integrity

Show all triggers in a MySQL database

sql
database-management
mysql-queries
trigger-management

How to execute a stored procedure inside a select query

sql
performance
best-practices
sql-server

Sql query to check if a name begins and ends with a vowel

sql
pattern-matching
regex
database-features

How can I join on a stored procedure?

sql
join
stored-procedure
temp-tables
explain.codes / Sql