#4 Install mysql di server nginx Ubuntu

 Setelah sukses install Nginx pada server ubuntu, selanjutnya akan kita install MySql untuk databasenya

1. Install MySql

  sudo apt install mysql-server

Enter Y untuk konfirmasi.

2. Setup Validate Password Plugin

  sudo mysql_secure_installation

Enter Y sampai dengan selesai.

3. Tes Uji MySql

  sudo mysql

OutputWelcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 22

Server version: 8.0.19-0ubuntu5 (Ubuntu)

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

Read More

How to select date from datetime column?

SELECT * FROM data  WHERE datetime BETWEEN '2009-10-20 00:00:00' AND '2009-10-20 23:59:59'

Update: the impact on using LIKE instead of operators in an indexed column is high. These are some test results on a table with 1,176,000 rows:

1. using datetime LIKE '2009-10-20%' => 2931ms

2. using datetime >= '2009-10-20 00:00:00' AND datetime <= '2009-10-20 23:59:59' => 168ms

Contoh Lain

Tanggal : 2018-06-02 15:50:30

1. select DATE(date_created) from data;

2018-06-02

2. select YEAR(date_created) from data;

2018

3. select MONTH(date_created) from data;

6

4. select DAY(date_created) from data;

2

5. select HOUR(date_created) from data;

15

6. select MINUTE(date_created) from data;

50

7. select SECOND(date_created) from data;

30

Tes Kecepatan dan Perbandingan penggunaan Query

QUERY 1

SELECT * FROM ttransaksi_all WHERE fid_outlet='OTL20190426095926383' AND `ftgl_transaksi` BETWEEN '2021-04-01 00:00:00' AND '2021-12-31 23:59:59'

[ Query took 2.4054 sec ]

QUERY 2

SELECT * FROM ttransaksi_all WHERE fid_outlet='OTL20190426095926383' AND `ftgl_transaksi` >= '2021-06-01 00:00:00' AND `ftgl_transaksi` <='2021-12-31 23:59:59'

[ Query took 1.2411 sec ]

Read More

Ubah directory MySql ke folder lain - PHP 8 Xampp terbaru

Saya menggunakan xampp versi : xampp-windows-x64-8.0.0-2-VS16-installer 

1. pertama buka panel xampp

2. klik config di MySql di atas

3. klik my.in

4. ubah isi my.in

#datadir="C:/xampp/mysql/data" [sebelum]

datadir="H:/WEB_LOKAL/MYSQL/data" [folder yang akan digunakan]

#innodb_data_home_dir="C:/xampp/mysql/data" [sebelum]

innodb_data_home_dir="H:/WEB_LOKAL/MYSQL/data" [folder yang akan digunakan]

#innodb_log_group_home_dir="C:/xampp/mysql/data" [sebelum]

innodb_log_group_home_dir="H:/WEB_LOKAL/MYSQL/data" [folder yang akan digunakan]

5. pergi ke folder C:\xampp\mysql\data

6. copy semua file yang ada disana dan paste di folder yang akan digunakan

7. setelah file di atas di paste, restart MySql di panel xampp

8. buka localhost/phpmyadmin

9. selesai

Read More