Explain Codes LogoExplain Codes Logo

Sql

Insert vs INSERT INTO

sql
best-practices
sql-standards
portability

Postgresql: How to create a table only if it does not already exist?

sql
database-interaction
error-prevention
schema-verification

How do I delete multiple rows with different IDs?

sql
delete-queries
performance-optimization
database-management

How can I update the top 100 records in SQL server

sql
update-records
sql-server
performance-optimization

Condition within JOIN or WHERE

sql
join
best-practices
performance

Php: maximum execution time when importing large .SQL data files

sql
importing-large-data
performance-optimization
command-line-tools

Add Foreign Key relationship between two Databases

sql
data-integrity
database-design
triggers

Mysql auto-store datetime for each row

sql
timestamp-management
database-design
mysql-optimization

Sql connection-string for localhost server

sql
connection-string
sql-server
database-connection

How to execute raw queries with Laravel 5.1?

sql
database-engineering
laravel
sql-queries

How can I determine the status of a job?

sql
job-status
sql-queries
database-management

Sql Server equivalent to MySQL enum data type?

sql
data-integrity
check-constraints
enum-data-type

How to delete duplicate rows in SQL Server?

sql
data-deletion
sql-server
best-practices

Concatenate multiple rows in an array with SQL on PostgreSQL

sql
array_agg
postgresql
data-aggregation

What does "select count(1) from table_name" on any database tables mean?

sql
count-function
sql-performance
database-optimization

Mysql LIKE IN()?

sql
regexp
like
performance

Remove duplicate rows in MySQL

sql
prompt-engineering
best-practices
join

Using union and count(*) together in an SQL query

sql
join
performance
best-practices

Sql query to select dates between two dates

sql
date-range
sql-queries
datetime

Use variable with TOP in select statement in SQL Server without making it dynamic

sql
prompt-engineering
best-practices
join