Ketika memindahkan website ke hosting baru, salah satu tantangan yang sering muncul adalah mengimpor file database MySQL berukuran besar. Misalnya, file hasil ekspor (.sql) bisa mencapai puluhan hingga ratusan MB. Sayangnya, banyak shared hosting membatasi ukuran upload dan tidak menyediakan akses terminal (SSH), sehingga kita tidak bisa langsung menjalankan perintah mysql < backup.sql.Lalu, bagaimana cara […]

Seperti hal sederhana tapi penting dan susah dicari, gimana cara nge run MySQL yang dari XAMPP tapi via shell? Bisa? Bisa, saya udah biasa melakukan dari dulu kalau pas MySQLnya kumat shutdown unexpectedly. Tak kira sampeyan-sampeyan juga sudah sering menemukan hal semacam ini, dan ketika kita googling buat mencari solusi, selalu ada solusi ini itu […]

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;

Its happend recently after I reinstall my OS and development environment. But, I’ve fix this after search some references from many source. Now, I’ll write here so when sometimes I forgot the way, I can read this, but it’s more better if its also can help for you. Its always denied if we run the […]

Sometimes, we feel very annoyed where doing job in database management. Building apps without good database is like building a skyscraper without cement. It’s imposible, actually, although it’s posible but it’s harder to do that. Well, we agree if database is so important to building apps. If we understand that, we can be more carefull […]