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 […]

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

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