Skip to content
Sutriman
A little notes, logs, and resume
MENU
  • Home
  • Programming
    • ajax
    • Javascript
    • Library
    • nodejs
    • Pemrograman Mobile
      • Android
      • React Native
    • Pemrograman Web
      • PHP
        • CodeIgniter
    • Python
      • django
    • Rest
  • Linux
  • Security
    • Security and Hacking
    • Digital Forensic
  • Data Science
  • Database
    • SQL
  • Books
    • Ebook
Homepage / Database / SQL

Category: SQL

Run MySQL XAMPP via XAMPP Shell (MySQL Shutdown Solution)

By sutrimanPosted on November 2, 2022November 2, 2022

Seperti hal sederhana tapi penting dan susah dicari, gimana cara nge run MySQL yang dari XAMPP tapi via shell? Bisa? […]

Search or Filter Column Name in MySQL

By sutrimanPosted on June 21, 2021June 21, 2021

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

By sutrimanPosted on April 9, 2021April 9, 2021

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

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

By sutrimanPosted on March 25, 2021March 25, 2021

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?

By sutrimanPosted on February 11, 2019April 24, 2019

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

By sutrimanPosted on December 15, 2017April 24, 2019

Sometimes, we feel very annoyed where doing job in database management. Building apps without good database is like building a […]

Tentang Blog

Blog ini mengandung catatan informatif yang berpotensi meningkatkan skill dan pengatahuan Anda dalam dunia teknologi informasi

Links

  • Tentang
  • Publications & Conferences
  • Panduan Email Subscribtions

Contact

Hubungi untuk:

  • Web & Mobile Programing
  • VPS & Web Server config
  • pekerjaan lainya

WA: 08562564625

@2013-2024 Sutriman.com