Explain Codes LogoExplain Codes Logo

Sql

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

Is there an advantage to varchar(500) over varchar(8000)?

sql
data-integrity
performance-optimization
database-design

Compare dates in T-SQL, ignoring the time part

sql
date-comparisons
sql-performance
best-practices

Sql Server 2005 - Export table programmatically (run a .sql file to rebuild it)

sql
data-integrity
sql-server
export-import

Sql - Search String Starts With

sql
sql-injection
query-efficiency
full-text-search

Best way to delete millions of rows by ID

sql
database-optimization
performance-tuning
data-management

Display an array in a readable/hierarchical format

sql
data-hierarchy
sql-functions
data-formatting

How can I reorder rows in SQL database

sql
database-management
sql-queries
data-organization

Postgresql Get a random datetime/timestamp between two datetime/timestamp

sql
performance
best-practices
timestamp

Oracle: SQL query to find all the triggers belonging to the tables?

sql
trigger-management
sql-queries
database-administration

How to create a new database with the hstore extension already installed?

sql
prompt-engineering
best-practices
data-types

Pl/sql block problem: No data found error

sql
exception-handling
best-practices
debugging
explain.codes / Sql