Seperti hal sederhana tapi penting dan susah dicari, gimana cara nge run MySQL yang dari XAMPP tapi via shell? Bisa? […]
Category: Database
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 […]
How to solve error “Unknown collation: ‘utf8mb4_0900_ai_ci'” when import MySQL DB
Do not worry if you find this error, its not mean that your backup.sql is corrupt or anything else. First […]
#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;
Solved. Error saat import MySQL #1071 – Specified key was too long; max key length is 767 bytes
Mungkin teman-teman sedang mengalami error 1071 – Specified key was too long; max key length is 767 bytes pada saat […]
Mengenal Basis Data MySQL
Mungkin teman-teman ingin pemula dalam bidang IT atau basis data, terutama dalam MySQL, namun ketika mempelajari ke sumber lain bahasa […]
Perbedaan superkey, candidate key dan primary key beserta contoh
Untuk kamu yang masih belum lama belajar basis data mungkin bingung, tentang perbedaan antara superkey, candidate key dan primary key. […]
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 […]
- 1
- 2