Search or Filter Column Name in MySQL

When we have a big database with too much column, its hard to find some column when we need it to create query or just to identifying the table. Even we just DESC table query, its nont enough because still to hard to find what we need if we have too much table. Then, how […]

#notes Query simple hitung umur MySQL

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

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

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