Cara Instalasi MySql di Debian

Cara Instalasi berdasar dokumentasi MySql

https://dev.mysql.com/doc/refman/8.4/en/linux-installation-apt-repo.html

Daftar Perintah umum

• Show databases:

  SHOW DATABASES;

• Login:

  mysql -u root -p;

• Set or Change Password:

  ALTER USER 'user_name'@'localhost' IDENTIFIED BY 'new_password';

  ALTER USER 'root'@'localhost' IDENTIFIED BY '12345678';

• Create Database:

  CREATE DATABASE nama_database;

• Use Database:

  USE nama_database;

• Create Tabel:

  CREATE TABLE nama_tabel (
      kolom1 tipe_data1,
      kolom2 tipe_data2,
      ...
  );

• Get Data:

  SELECT kolom1, kolom2 FROM nama_tabel WHERE kondisi;
  SELECT * FROM nama_tabel;
  SELECT col2 FROM tb1

• Add New Data:

  INSERT INTO nama_tabel (kolom1, kolom2) VALUES (nilai1, nilai2);

• Update Data:

  UPDATE nama_tabel SET kolom1 = nilai1 WHERE kondisi;

• Delete Data:

  DELETE FROM nama_tabel WHERE kondisi;

• Delete Tabel:

  DROP TABLE nama_tabel;

• Delete Database:

  DROP DATABASE nama_database;

• Join Data:

  SELECT kolom1, kolom2 FROM tabel1
  JOIN tabel2 ON tabel1.kolom_id = tabel2.kolom_id;

• Describe Tabel:

  DESCRIBE nama_tabel;

• Rename Tabel:

  RENAME TABLE nama_tabel_lama TO nama_tabel_baru;

• Export Database:

  mysqldump -u username -p nama_database > nama_file_backup.sql

• Import Database:

  mysql -u username -p nama_database < nama_file_backup.sql