Explain Codes LogoExplain Codes Logo

Sql

How can I list the tables in a SQLite database file that was opened with ATTACH?

sql
sqlite
database-management
sql-commands

Is MySQL "between" clause not inclusive?

sql
datetime
timestamp
date

Online databases for trying out Oracle SQL queries?

sql
online-databases
sql-practice
database-management

Postgresql list and order tables by size

sql
database-management
postgresql
sql-queries

Sql User Defined Function Within Select

sql
udf
sql-performance
data-transformations

How do I find the creation date of a MySQL table?

sql
metadata
database-performance

Group by day from timestamp

sql
group-by
timestamp
date-formatting

Invalid default value for 'dateAdded'

sql
default-values
mysql-versions
error-handling

Error SQL70001: This statement is not recognized in this context

sql
sql-error
sql-syntax
sql-best-practices

Mysql update column with value from another table

sql
conditional-statements
performance-optimization
data-safety

What is Full Text Search vs LIKE

sql
prompt-engineering
best-practices
indexing

How to delete multiple rows in SQL where id = (x to y)

sql
delete-operations
sql-performance
sql-best-practices

How do I find a "gap" in running counter with SQL?

sql
prompt-engineering
join
performance

Why do people hate SQL cursors so much?

sql
best-practices
performance
join

Updating columns with a sequence number mysql

sql
join
performance
best-practices

Nested select statement in SQL Server

sql
subqueries
data-aggregation
query-optimization

Mysql Cannot Add Foreign Key Constraint

sql
foreign-key-constraints
mysql-troubleshooting
database-design

Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement

sql
database-administration
sql-server
database-maintenance

Sql SELECT multi-columns INTO multi-variable

sql
sql-scripts
variable-assignment
null-handling

Find Nearest Latitude/Longitude with an SQL Query

sql
geometric-operations
database-performance
sql-injection
explain.codes / Sql