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 sort posts by top and latest.
Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String

Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String

Reactions 2 Comments
3 min read
Fun times with MySQL upgrade

Fun times with MySQL upgrade

Reactions 2 Comments
5 min read
How Covid changed the way we work with SQL

How Covid changed the way we work with SQL

Reactions 2 Comments
4 min read
Learn how to write SQL recursive CTE in 5 steps

Learn how to write SQL recursive CTE in 5 steps

Reactions 2 Comments
6 min read
How To Swap 2 Unique Primary Keys In The Same Table With MySQL

How To Swap 2 Unique Primary Keys In The Same Table With MySQL

Reactions 2 Comments
1 min read
SQL Basics Tutorial for Beginners (Practice SQL Queries)

SQL Basics Tutorial for Beginners (Practice SQL Queries)

Reactions 2 Comments
1 min read
7 modern and practical MySQL/MariaDB features you should know and use

7 modern and practical MySQL/MariaDB features you should know and use

Reactions 2 Comments
5 min read
Getting started with Redshift

Getting started with Redshift

Reactions 8 Comments
5 min read
SQL Joins - Inner Join vs Outer Join

SQL Joins - Inner Join vs Outer Join

Reactions 5 Comments
1 min read
Please How can I convert the following object oriented PDO fetch_assoc to MYsqli Format below.

Please How can I convert the following object oriented PDO fetch_assoc to MYsqli Format below.

Reactions 2 Comments
1 min read
How To Delete First Or Last n Rows In MySQL

How To Delete First Or Last n Rows In MySQL