Explain Codes LogoExplain Codes Logo

Sql

How to drop SQL default constraint without knowing its name?

sql
dynamic-sql
metadata
database-schema

Add column to table and then update it inside transaction

sql
transactional-database-management
sql-best-practices
error-handling

Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root

sql
database-configuration
security-best-practices
mysql-configuration

How to test run an UPDATE statement in PostgreSQL?

sql
transactions
database-safety
best-practices

Sqlite syntax for If Else condition

sql
best-practices
data-accuracy
database-management

Export table data from one SQL Server to another

sql
data-transfer
sql-server
database-management

What exactly do quotation marks around the table name do?

sql
sql-queries
case-sensitivity
orm-consistency

Mysql SELECT last few days?

sql
date-functions
timestamp
interval

#1025 - Error on rename of './database/#sql-2e0f_1254ba7' to './database/table' (errno: 150)

sql
foreign-keys
database-design
best-practices

How to count occurrences of a column value efficiently in SQL?

sql
prompt-engineering
best-practices
performance

A SQL Query to select a string between two known strings

sql
prompt-engineering
best-practices
full-text-search

Generate insert SQL statements from a CSV file

sql
csv-to-sql
sql-injection
database-functions

Sqlstate[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO

sql
sql-state
pdo-connection
error-handling

How can I query a value in SQL Server XML column

sql
xml-querying
sql-indexing
xpath-expressions

Select without a FROM clause in Oracle

sql
prompt-engineering
best-practices
performance

Copy a table (including indexes) in postgres

sql
database-management
postgresql
table-operations

How to get SQL from Hibernate Criteria API (*not* for logging)

sql
sql-spies
criteria-api
hibernate-logging

Sql is null and = null

sql
null-values
sql-queries
database-design

Hive insert query like SQL

sql
data-insertion
hive-queries
bulk-data-insertion

Search for "whole word match" in MySQL

sql
regex
mysql
database
explain.codes / Sql