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.
Squashing Laravel Migrations: 5 Ways schema:dump --prune Bites a Real Team
hafiz619 profile

Squashing Laravel Migrations: 5 Ways schema:dump --prune Bites a Real Team

#laravel #migrations #mysql #testing
1
Comments
8 min read
"Duplicate entry '0' for key PRIMARY" usually means your database lost AUTO_INCREMENT
megventure profile

"Duplicate entry '0' for key PRIMARY" usually means your database lost AUTO_INCREMENT

#mysql #php #database #devops
Comments
4 min read
PostgreSQL vs MySQL: 7 syntax differences that break migrations
sharefun2023 profile

PostgreSQL vs MySQL: 7 syntax differences that break migrations

#postgres #mysql #database #sql
Comments
4 min read
How to make a Grocery store Web app with Python, Flask and MySQL (Part-3 How to use Flask to make the actual webapp)
kartikjhaprod profile

How to make a Grocery store Web app with Python, Flask and MySQL (Part-3 How to use Flask to make the actual webapp)

#python #flask #webdev #mysql
Comments
11 min read
The NOT IN trap: why your SQL query returns zero rows
sharefun2023 profile

The NOT IN trap: why your SQL query returns zero rows

#sql #database #postgres #mysql
Comments
3 min read
ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N
sharefun2023 profile

ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N

#sql #database #postgres #mysql
Comments
4 min read
Database Concurrency 101: Optimistic vs. Pessimistic Locking
saurav_tb_pandey profile

Database Concurrency 101: Optimistic vs. Pessimistic Locking

#optimisticlocking #database #node #mysql
Comments
3 min read
How I Structured a Java Library Management System with DAO and Service Layers
hamad_19 profile

How I Structured a Java Library Management System with DAO and Service Layers

#java #jdbc #mysql #oop
Comments
8 min read
How I Built a Java Hotel Reservation System with JDBC and MySQL
hamad_19 profile

How I Built a Java Hotel Reservation System with JDBC and MySQL

#jdbc #java #mysql #beginners
Comments
9 min read
Is your WHMCS charging last year's EU VAT rate?
vainamoinen profile

Is your WHMCS charging last year's EU VAT rate?

#whmcs #php #mysql #sysadmin
Comments
7 min read
WHMCS 9.0: check your custom reports for double-counting
vainamoinen profile

WHMCS 9.0: check your custom reports for double-counting

#whmcs #mysql #php #sysadmin
Comments
6 min read
Specialization and Generalization in DBMS: Explained with Simple Examples
siddhu_kumar_fd7a80402b7e profile

Specialization and Generalization in DBMS: Explained with Simple Examples

#database #webdev #programming #mysql
Comments
4 min read
Moving off EventON: its timestamps aren't what they look like
jeffreyinman profile

Moving off EventON: its timestamps aren't what they look like

#wordpress #php #mysql #webdev
1
Comments 1
4 min read
Moving off WP Event Manager: what's in your database and what breaks
jeffreyinman profile

Moving off WP Event Manager: what's in your database and what breaks

#wordpress #php #mysql #webdev
Comments 1
3 min read
Moving off Modern Events Calendar: what's in your database and what breaks
jeffreyinman profile

Moving off Modern Events Calendar: what's in your database and what breaks

#wordpress #php #mysql #webdev
Comments 1
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.