Seperti hal sederhana tapi penting dan susah dicari, gimana cara nge run MySQL yang dari XAMPP tapi via shell? Bisa? […]
Category: SQL
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 […]
#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;
How to fix if can’t access MySQL without SUDO?
Its happend recently after I reinstall my OS and development environment. But, I’ve fix this after search some references from […]
Magic query for table operation in SQL
Sometimes, we feel very annoyed where doing job in database management. Building apps without good database is like building a […]