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.
Spring Embedded MySQL Server

Spring Embedded MySQL Server

6
Comments
4 min read
PHP as a Pain Reliever

PHP as a Pain Reliever

8
Comments
4 min read
.Net Core 3 - Part 2 - MySQL

.Net Core 3 - Part 2 - MySQL

16
Comments 1
3 min read
Creating REST API in Node.js with Express and MySQL

Creating REST API in Node.js with Express and MySQL

15
Comments
10 min read
Flexible data types with the JSON field

Flexible data types with the JSON field

10
Comments
5 min read
Le comportement particulier des autoincrement dans les tables MySQL InnoDB

Le comportement particulier des autoincrement dans les tables MySQL InnoDB

5
Comments
3 min read
How to Transfer MySQL Databases

How to Transfer MySQL Databases

5
Comments
1 min read
How to get the list of all the affected columns in a SQL query

How to get the list of all the affected columns in a SQL query

7
Comments 1
1 min read
Install and setup Apache + MySQL + PHP on Windows

Install and setup Apache + MySQL + PHP on Windows

14
Comments 3
3 min read
How to access the MySQL CLI With MAMP

How to access the MySQL CLI With MAMP

33
Comments 5
1 min read
Using MySQL with Rails 6 and installing MySQL on Mac (macOS Mojave)

Using MySQL with Rails 6 and installing MySQL on Mac (macOS Mojave)

23
Comments 5
5 min read
How to generate random IDs that are not individually unique, but unique across 2 fields (columns) in a MySQL database table?

How to generate random IDs that are not individually unique, but unique across 2 fields (columns) in a MySQL database table?

9
Comments 8
1 min read
A simple user permission model for sophisticated systems

A simple user permission model for sophisticated systems

22
Comments
14 min read
Add a LAMP Stack to a server with Centos OS

Add a LAMP Stack to a server with Centos OS

8
Comments 2
2 min read
A definitive guide to SQL in NodeJS with Objection.js + Knex — Part 1

A definitive guide to SQL in NodeJS with Objection.js + Knex — Part 1

71
Comments 12
10 min read
Why I don't use a database for my blog

Why I don't use a database for my blog

7
Comments 1
4 min read
Problem when line feed code is mixed when csv in import into varchar column with AWS Aurora.

Problem when line feed code is mixed when csv in import into varchar column with AWS Aurora.

8
Comments
1 min read
Improve query performance for polymorphic relationships in Laravel

Improve query performance for polymorphic relationships in Laravel

8
Comments
3 min read
How To Install WordPress with a Managed Database on Ubuntu 18.04

How To Install WordPress with a Managed Database on Ubuntu 18.04

34
Comments 8
17 min read
MySQL implicit commit

MySQL implicit commit

6
Comments
2 min read
Query Optimization with MySQL

Query Optimization with MySQL

10
Comments
7 min read
Moving from MySQL 5.7 to MariaDB 10.1

Moving from MySQL 5.7 to MariaDB 10.1

6
Comments
7 min read
Playing with Django Models

Playing with Django Models

22
Comments 1
10 min read
Understanding timezones

Understanding timezones

11
Comments
1 min read
Advanced usage of yum-config-manager with setopts

Advanced usage of yum-config-manager with setopts

8
Comments 5
1 min read
loading...