Explain Codes LogoExplain Codes Logo

Sql

Can MySQL convert a stored UTC time to local timezone?

sql
mysql
timezone
performance

How to insert a record into a table with a column declared with the SERIAL function

sql
best-practices
performance
concurrent-inserts

How to get the size of a varchar[n] field in one SQL statement?

sql
database-schema-management
varchar-field-size
information-schema

How to export a MySQL database to JSON?

sql
mysql
json
data-export

Unioning two tables with different number of columns

sql
union
data-types
sql-variants

Postgresql: Create schema in specific database

sql
database-management
schema-creation
postgresql

Sql: Capitalize First Letter Only

sql
string-manipulation
custom-functions
xml-and-nodes

How to remove unique key from MySQL table

sql
database-backup
index-operations
sql-queries

How can I merge two MySQL tables?

sql
data-integrity
database-management
sql-queries

Can we pass parameters to a view in SQL?

sql
udf
stored-procedures
session-context

Sql Server: Cannot insert an explicit value into a timestamp column

sql
data-types
datetime
timestamp

Mysql "CREATE TABLE IF NOT EXISTS" -> Error 1050

sql
database-performance
data-integrity
best-practices

Mysql - Selecting data from multiple tables all with same structure but different data

sql
database-engine
query-optimization
data-management

What are good alternatives to SQL (the language)?

sql
database-language
sql-alternatives
data-access

What SQLite column name can be/cannot be?

sql
best-practices
database-design
sql-optimization

Reference alias (calculated in SELECT) in WHERE clause

sql
prompt-engineering
best-practices
join

Only inserting a row if it's not already there

sql
database-management
data-integrity
concurrency-control

How to Convert PostgreSQL 9.4's jsonb Type to Float

sql
jsonb
casting
postgresql

Add a row number to result set of a SQL query

sql
window-functions
row-numbering
sql-performance

How to report an error from a SQL Server user-defined function

sql
custom-error-handling
udf
sql-server