• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Jaranguda

Belajar Mengajar

  • Home
  • Sponsor/Jasa
  • Tentang

Kesalahan Query MySQL Bila Tipe Varchar

Last Updated on 4 April 2019 By tommy Leave a Comment

Kesalahan Query MySQL Bila Tipe kolom varchar vs integer

Query Varchar

SELECT * FROM `purchase_order` WHERE status = 0
# output
+----+------------+------------+---------+---------+-------------------+------------+------------+--------+---------------------+---------------------+
| id | po_number  | po_date    | site_id | status  | file_pdf          | updated_by | created_by | active | created_at          | updated_at          |
+----+------------+------------+---------+---------+-------------------+------------+------------+--------+---------------------+---------------------+
|  1 | 8100009248 | 2016-05-31 |       1 | Dikirim | 81-9248.pdf       |          2 |          2 |      1 | 2016-08-10 11:07:22 | 2016-08-15 14:15:10 |
|  2 | 8100009547 | 2016-06-21 |       2 | Dikirim | 81-9547.pdf       |          2 |          2 |      1 | 2016-08-10 11:10:51 | 2016-08-15 14:14:46 |
|  3 | 8100008792 | 2016-04-27 |       2 | Dikirim | po 8100008792.pdf |          2 |          2 |      1 | 2016-08-10 11:13:25 | 2016-08-15 14:14:11 |
|  4 | 8100008436 | 2016-03-29 |       2 | Dikirim | PO 8100008436.pdf |          2 |          2 |      1 | 2016-08-10 11:15:12 | 2016-08-15 14:20:40 |

Query Varchar

SELECT * FROM `purchase_order` WHERE status = '0'
# output
+-----+-------------+------------+---------+--------+----------+------------+------------+--------+---------------------+---------------------+
| id  | po_number   | po_date    | site_id | status | file_pdf | updated_by | created_by | active | created_at          | updated_at          |
+-----+-------------+------------+---------+--------+----------+------------+------------+--------+---------------------+---------------------+
| 173 | F60794      | 2016-09-01 |      28 | 0      | NULL     |          4 |          4 |      1 | 2016-09-02 09:25:05 | 2016-09-02 09:25:05 |
| 190 | HAI12880807 | 2016-10-06 |      28 | 0      | pdf.pdf  |          1 |          1 |      1 | 2016-10-06 12:37:00 | 2016-10-07 22:50:38 |
+-----+-------------+------------+---------+--------+----------+------------+------------+--------+---------------------+---------------------+

karena tipe data 0 adalah char, maka harus dalam tanda petik, kalo ngga hasilnya akan beda.

Tulisan menarik lainnya

  • Contoh MySQL Menggabungkan Hasil Query GROUP BY

    Contoh kasus, saya memiliki tabel yang berisi barang dan pembeli. Saya mau menampilkan data dari…

  • Mengatasi Error MySQL logger: command not found Debian

    Error yang muncul sewaktu menginstall mysql di Debian 7 Setting up mysql-server-5.5 (5.5.40-0+wheezy1) ... debconf:…

  • Cara Reset AUTO_INCREMENT MySQL

    Cara untuk mereset AUTO_INCREMENT MySQL/MariaDB dengan menjalankan perintah ALTER TABLE NAMATABEL AUTO_INCREMENT=1 Ganti NAMATABEL dengan…

  • Instalasi Mail Server Postfix Dovecot MySQL Debian 7

    Hal pertama yang perlu di sesuaikan adalah hostname. Untuk mengganti hostname Debian edit file /etc/hostname,…

Filed Under: Linux

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Pencarian

Tanya Jawab tentang DevOps SRE CPE, gabung di https://t.me/devopsindonesia

Terbaru

  • Cara Mengganti Port Screen Sharing macOS
  • Cara Menonaktifkan Pager di macOS
  • Cara Mengupdate Nama Apple silicon-as-a-Service Scaleway
  • Cara Force Delete Namespace di Kubernetes
  • Install PHP MariaDB di Mac Monterey

Komentar

  • adi on Menggunakan Mikrotik Sebagai SSH Client
  • aris u on Solusi Simple Queue Mikrotik Tidak Berjalan
  • Bowo on Cara Mematikan SSID Molecool Balifiber
  • aris on Solusi Simple Queue Mikrotik Tidak Berjalan
  • Alief on Password Router Huawei HG8245H5 Indihome

Tulisan Populer

  • Password Router Huawei HG8245H5 Indihome 1.1m views
  • Password Terbaru ZTE F609 Indihome 784.5k views
  • Password Superadmin Huawei HG8245A 318k views
  • Cara Setting Manual Modem GPON ZTE F609 Indihome 273k views
  • Cara Setting Wireless ZTE F609 Indihome 257.1k views
  • Mengaktifkan Port LAN di Huawei HG8245 Indihome 169.8k views
  • Akses UseeTV Indihome via Wireless ZTE F609 156.8k views
  • Kemana Menghilangnya Saldo BCA 50 ribu 153k views
  • Cara Reset Password ZTE F609 Indihome 147.5k views
  • Cara Setting DHCP Server Modem/Router ZTE F609 113.5k views

Kategori

  • Delphi
  • dll
  • Gambas
  • Internet
  • Java
  • Lazarus
  • Linux
  • PHP
  • Review
  • Teknologi

Sponsor

kadal.id
carakami.com
kuotabisa.com
Untuk jadi sponsor, hubungi kita lewat halaman sponsor
© 2021. Jaranguda
  • Linux
  • PHP
  • Internet
  • Teknologi
  • Delphi
  • Gambas
  • Java