DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Web Vulnerabilities: SQL Injections

Web Vulnerabilities: SQL Injections

1
Comments 4
3 min read
Why you should never use an UUID as the primary key in SQL Databases

Why you should never use an UUID as the primary key in SQL Databases

104
Comments 66
2 min read
MySQL: Everything You Need To Know

MySQL: Everything You Need To Know

15
Comments
2 min read
Learn SQL Quickly & Join Data Easily, With This Simple Method & Get into 11 New Professions !!!!

Learn SQL Quickly & Join Data Easily, With This Simple Method & Get into 11 New Professions !!!!

9
Comments 1
4 min read
SQL Cheat Sheet: A Comprehensive Guide to SQL Commands and Queries

SQL Cheat Sheet: A Comprehensive Guide to SQL Commands and Queries

3
Comments 2
2 min read
Surrogate Key vs Primary Key: What's the Difference?

Surrogate Key vs Primary Key: What's the Difference?

1
Comments
11 min read
How to store and calculate historical big data with lower usage frequency

How to store and calculate historical big data with lower usage frequency

6
Comments
4 min read
`OR` Filter on Two Tables, and Batched Nested Loops

`OR` Filter on Two Tables, and Batched Nested Loops

1
Comments
6 min read
Set-oriented Syntax – Using SQL as an Example

Set-oriented Syntax – Using SQL as an Example

6
Comments 1
4 min read
Communicate with Microsoft SQL Server that works on Flutter app compiled for multiple platforms

Communicate with Microsoft SQL Server that works on Flutter app compiled for multiple platforms

21
Comments 1
7 min read
Simple Database Software For MySQL

Simple Database Software For MySQL

Comments
8 min read
Isolation Levels - part XII: To go further

Isolation Levels - part XII: To go further

Comments 2
2 min read
Slash Slow Queries by Rewriting OR to UNION

Slash Slow Queries by Rewriting OR to UNION

Comments 1
3 min read
How To Execute A Query In SQL: Using Queries And Data Views

How To Execute A Query In SQL: Using Queries And Data Views

Comments
5 min read
SQL - Handle NULL Values Safely in Queries

SQL - Handle NULL Values Safely in Queries

2
Comments
1 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.