Homepage / Database / SQL / SQL Query

Category: SQL Query

Search or Filter Column Name in MySQL

By sutrimanPosted on June 21, 2021June 21, 2021

When we have a big database with too much column, its hard to find some column when we need it […]

#notes Query simple hitung umur MySQL

By sutrimanPosted on April 9, 2021April 9, 2021

SELECT TIMESTAMPDIFF(YEAR, ‘1984-05-01’, CURDATE()) AS umur from nama_table;

Menambah kolom di MySQL table dengan not null dan default value #queryNotes

By sutrimanPosted on March 25, 2021March 25, 2021

Contoh query: ALTER TABLE nama_tabel ADD kolom_baru SMALLINT(6) NOT NULL DEFAULT 0;