DEV Community

# mysql

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

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
What day is one month after 31st January? What day is one month before 31st March? I checked it with various RDBs.

What day is one month after 31st January? What day is one month before 31st March? I checked it with various RDBs.

6
Comments 5
5 min read
Unit testing in go with MySQL

Unit testing in go with MySQL

4
Comments
1 min read
Partitioning a billion-row table of soccer data using data context

Partitioning a billion-row table of soccer data using data context

6
Comments
8 min read
Multiple approaches of storing data using NodeJS and KnexJS

Multiple approaches of storing data using NodeJS and KnexJS

11
Comments
2 min read
Create Controller in Laravel 8 using Artisan Command

Create Controller in Laravel 8 using Artisan Command

11
Comments
2 min read
PHP MySQL Delete Query using PDO

PHP MySQL Delete Query using PDO

7
Comments
2 min read
How To Extract Content Between Keywords using PHP Regex

How To Extract Content Between Keywords using PHP Regex

8
Comments
1 min read
PHP Keyword or Shortcode Extractor Class

PHP Keyword or Shortcode Extractor Class

6
Comments
1 min read
😈 Let's run deadlock manually ! [SQL]

😈 Let's run deadlock manually ! [SQL]

6
Comments
1 min read
🤹‍♀️ SELECT ORDER [SQL]

🤹‍♀️ SELECT ORDER [SQL]

6
Comments
1 min read
🤨 What is N+1 problem?

🤨 What is N+1 problem?

5
Comments
1 min read
🤔 What is Database Index?

🤔 What is Database Index?

7
Comments
2 min read
How to create a delete endpoint with node.js and MySql

How to create a delete endpoint with node.js and MySql

7
Comments
2 min read
Nested Classes - CustomRowMapper !! Not a Problem Anymore !! - Part 2

Nested Classes - CustomRowMapper !! Not a Problem Anymore !! - Part 2

10
Comments
3 min read
How to manage sessions in Node.js using Passport, Redis, and MySQL

How to manage sessions in Node.js using Passport, Redis, and MySQL

10
Comments
12 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.