Skip to content

Instantly share code, notes, and snippets.

View east2dd's full-sized avatar
🏠
Working from home

east2dd east2dd

🏠
Working from home
View GitHub Profile
@east2dd
east2dd / postgresql-set-id-seq.sql
Created April 19, 2021 03:13 — forked from henriquemenezes/postgresql-set-id-seq.sql
PostgreSQL set Next ID Sequence Value to MAX(id) from Table
-- Get Max ID from table
SELECT MAX(id) FROM table;
-- Get Next ID from table
SELECT nextval('table_id_seq');
-- Set Next ID Value to MAX ID
SELECT setval('table_id_seq', (SELECT MAX(id) FROM table) + 1);
@east2dd
east2dd / mysql2-mojave.md
Created November 12, 2019 23:16 — forked from fernandoaleman/mysql2-mojave.md
Install mysql2 on MacOS Mojave

Problem

Installing mysql2 gem errors on MacOS Mojave.

Solution

Make sure openssl is installed on Mac via Homebrew.

brew install openssl