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.
How to Add a Default Value to an Existing Column in MySQL

How to Add a Default Value to an Existing Column in MySQL

16
Comments
2 min read
Build a Chatbot with PHP, MySQL and AJAX in 10 minutes

Build a Chatbot with PHP, MySQL and AJAX in 10 minutes

29
Comments 1
6 min read
🚀 Think about Primary Key & Indexes before anything else 🐘

🚀 Think about Primary Key & Indexes before anything else 🐘

56
Comments
8 min read
Learn SQL: Microsoft SQL Server - Episode 8: NULL values in Aggregation

Learn SQL: Microsoft SQL Server - Episode 8: NULL values in Aggregation

6
Comments
3 min read
🆕 SQL Server 2022 First Look - Top 5 New Features (Bonus 5 Features)

🆕 SQL Server 2022 First Look - Top 5 New Features (Bonus 5 Features)

5
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 7: Aggregate data with SUM and AVG

Learn SQL: Microsoft SQL Server - Episode 7: Aggregate data with SUM and AVG

8
Comments
3 min read
Learning The Structure Query Language (SQL)

Learning The Structure Query Language (SQL)

6
Comments
12 min read
Database Management Systems 1

Database Management Systems 1

10
Comments
2 min read
SQL Basics for Beginners

SQL Basics for Beginners

100
Comments 4
3 min read
HOW CAN I LIMIT THE MAXIMUM FILE UPLOAD LIMIT PER USER IN PHP.

HOW CAN I LIMIT THE MAXIMUM FILE UPLOAD LIMIT PER USER IN PHP.

3
Comments 5
1 min read
The Important SQL Queries for Beginners

The Important SQL Queries for Beginners

13
Comments
8 min read
A Complete Guide on How SQL Injection Attacks Work

A Complete Guide on How SQL Injection Attacks Work

40
Comments 2
8 min read
Learn SQL: Microsoft SQL Server - Episode 6: Alias and Aggregate Data

Learn SQL: Microsoft SQL Server - Episode 6: Alias and Aggregate Data

7
Comments
6 min read
SQL - Sub Queries

SQL - Sub Queries

6
Comments
2 min read
Python and SQL

Python and SQL

7
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 5: Joining Tables

Learn SQL: Microsoft SQL Server - Episode 5: Joining Tables

7
Comments
3 min read
Hacktoberfest 2021 with QuestDB community

Hacktoberfest 2021 with QuestDB community

13
Comments 2
2 min read
How to Drop Multiple Databases in PostgreSQL

How to Drop Multiple Databases in PostgreSQL

5
Comments
5 min read
SQL for detecting contiguous and non-contiguous date spans

SQL for detecting contiguous and non-contiguous date spans

8
Comments
5 min read
SQL to derive subsequences

SQL to derive subsequences

2
Comments
4 min read
Learn SQL: Microsoft SQL Server - Episode 4: Sorting Results

Learn SQL: Microsoft SQL Server - Episode 4: Sorting Results

7
Comments
5 min read
SQL - Stored Procedure 📦

SQL - Stored Procedure 📦

34
Comments 1
1 min read
SQL: How to consult the database.

SQL: How to consult the database.

4
Comments
2 min read
DELETE on SQL

DELETE on SQL

2
Comments
1 min read
Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 2

Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 2

7
Comments
5 min read
loading...