Letakkan berkas disini

SQL upload ( 0 ) x -

Pengaturan Terkait dengan Halaman Klik pada bar untuk menggulir ke atas halaman
Tekan Ctrl+Enter untuk menjalankan kueri Press Enter to execute query
ascending
descending
Order:
Men-Debug SQL
Jumlah
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Tampilkan Buka Show trace Hide trace Jumlah : Time taken :
Bookmark
Segarkan
Tambah
Tidak ada penanda
Tambah bookmark
Opsi
Kembalikan nilai bawaan





Tampilkan Buka Kueri ulang Ubah Jelaskan Profil Bookmarks Kueri gagal Basis data : Waktu eksekusi kueri :
Modus jelajah
Atur mode jelajah.
Modus jelajah
Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya. Kembalikan nilai bawaan
Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya. Kembalikan nilai bawaan
Dokumentasi Whether a user should be displayed a "show all (rows)" button. Kembalikan nilai bawaan
Dokumentasi Jumlah baris yang ditampilkan saat browsing hasil set. Jika hasil set berisi lebih dari satu baris, tautan "Previous" and "Next" akan ditampilkan. Kembalikan nilai bawaan
Dokumentasi SMART - yaitu urutan untuk kolom jenis TIME, DATE, DATETIME dan TIMESTAMP, urutan ascending dan sebaliknya. Kembalikan nilai bawaan
Dokumentasi Sorot baris yang ditunjuk dengan kursor mouse. Kembalikan nilai bawaan
Dokumentasi Sorot baris terpilih. Kembalikan nilai bawaan
Dokumentasi Kembalikan nilai bawaan
Dokumentasi Kembalikan nilai bawaan
Dokumentasi Ulangi header setiap X sel, 0 menonaktifkan fitur ini. Kembalikan nilai bawaan
Dokumentasi Jumlah maksimum karakter yang ditunjukkan pada kolom non-angka pada mode jelajah. Kembalikan nilai bawaan
Dokumentasi Berikut ini adalah tautan Edit, Salin, dan Hapus. Kembalikan nilai bawaan
Dokumentasi Apakah untuk menampilkan link baris bahkan tanpa adanya unique key. Kembalikan nilai bawaan
Dokumentasi Default sort order for tables with a primary key. Kembalikan nilai bawaan
Dokumentasi Saat browsing tabel, penyortiran setiap tabel akan diingat. Kembalikan nilai bawaan
Dokumentasi Untuk pengaturan tampilan Kembalikan nilai bawaan
SELECT * FROM `tickets` ORDER BY `title` ASC 
Edit dikotak ] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan ]
Teks penuh id ticket_no requester_name requester_phone department_id category_id title Menaik Menurun 1 description priority status assigned_to_tech_id approval_pic_id approval_token approval_status approval_sent_at approval_decided_at approval_decided_by_pic_id approval_note assigned_by_type assigned_by_id assigned_by_name assigned_at created_at updated_at
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 6
6 LJMAV26020002 sdfsdf 34 1 4 234 ewrwe MEDIUM OPEN NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-02-14 04:31:12 2026-02-14 04:31:12
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 11
11 LJMAV26020007 aaaa 8888 3 6 888 yyyy MEDIUM IN_PROGRESS 3 1 4d4d04d4fbbd2cc5798cca4341dcca010d08cbb3ae0a488ae4... APPROVED 2026-02-14 18:30:57 2026-02-14 18:32:05 1 NULL NULL NULL NULL NULL 2026-02-14 18:30:02 2026-02-14 18:32:05
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 12
12 LJMAV26020008 ZX 2112 1 3 asd asd HIGH OPEN 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-02-14 19:37:24 2026-02-14 19:37:24
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 13
13 LJMAV26020009 asdasd 111 3 5 asdads asdasd MEDIUM OPEN 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-02-14 19:37:53 2026-02-14 19:37:53
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 14
14 LJMAV26020010 asdasd 1111111 3 5 asdads asdasd MEDIUM OPEN 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-02-14 20:04:30 2026-02-14 20:04:30
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 15
15 LJMAV26020011 asdasd 5666 3 5 asdads asdasd MEDIUM OPEN 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-02-14 20:05:06 2026-02-14 20:05:06
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 3
3 LJMAV2026020003 tester 6288888 NULL 1 asdasd asddas MEDIUM IN_PROGRESS 3 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-02-14 00:31:34 2026-02-14 02:35:59
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 10
10 LJMAV26020006 dddddd 21321321 2 3 asdsa sadsad MEDIUM IN_PROGRESS 1 1 902c67f5b62357eda4cd0ae120b639588a0db77439095bf36f... APPROVED 2026-02-14 18:03:36 2026-02-14 18:04:41 1 NULL NULL NULL NULL NULL 2026-02-14 12:19:35 2026-02-14 18:04:41
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 17
17 LJMAV26020013 Abcd 1234567 3 4 Case error Detail case MEDIUM IN_PROGRESS 1 1 bcb31d5f79c4b813f0c29bad440624f46130a73f7e94188177... PENDING 2026-02-15 01:10:13 NULL NULL NULL NULL NULL NULL NULL 2026-02-15 01:03:44 2026-02-15 01:10:13
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 18
18 LJMAV26020014 Tester 123456789 3 1 Case test Detail case MEDIUM IN_PROGRESS 1 1 2670efaf774271f29a756d04dc20f70a34e5e1d8b4279a3be0... APPROVED 2026-02-15 02:16:45 2026-02-15 02:17:14 1 Ok saya approve ya NULL NULL NULL NULL 2026-02-15 02:16:02 2026-02-15 02:17:14
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 16
16 LJMAV26020012 Gilbert 628135487215 2 4 Coba case Detail case MEDIUM OPEN NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-02-15 01:01:51 2026-02-15 01:01:51
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 4
4 LJMAV2026020004 fghghfgfh 456 NULL 3 dfggfd dfggfd MEDIUM OPEN NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-02-14 00:32:52 NULL
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 2
2 LJMAV2026020002 tester 9081239082190382901 NULL 5 ewrwer ewsrferd URGENT RESOLVED 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-02-13 23:15:29 2026-02-14 02:36:29
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 5
5 LJMAV26020001 testing 008399 1 6 ga bisa print printer tidak merespon MEDIUM IN_PROGRESS 1 1 1076aea2668a4ca5834b187d4d94e3a67b78bd4184072d1b58... APPROVED 2026-02-14 19:38:33 2026-02-14 19:39:27 1 NULL TECH 1 Maryo 2026-02-14 19:38:23 2026-02-14 04:30:26 2026-02-14 19:39:27
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 9
9 LJMAV26020005 Test 62813000000 1 5 Keyboard rusak Tombol tidak bisa ditekan HIGH IN_PROGRESS 1 1 dc27b02d2c7df5ec62fe582c23f81faea83ce1ee48f535f484... APPROVED 2026-02-14 20:05:33 2026-02-14 20:06:03 1 NULL TECH 1 Maryo 2026-02-14 16:10:26 2026-02-14 04:41:01 2026-02-14 20:06:03
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 7
7 LJMAV26020003 Gindez 6281371000115 7 5 Monitor ga hidup Ga ada gambarnya MEDIUM OPEN NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2026-02-14 04:33:54 2026-02-14 04:33:54
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM tickets WHERE `tickets`.`id` = 8
8 LJMAV26020004 Gindez 6281371000115 7 5 Monitor ga hidup Ga ada gambarnya MEDIUM IN_PROGRESS 1 1 47fe22240d22c301aec2f0187fc70eb793634615bee54e5600... APPROVED 2026-02-15 01:11:20 2026-02-15 01:11:32 1 NULL ADMIN 1 Super Admin 2026-02-14 17:44:57 2026-02-14 04:36:35 2026-02-15 01:11:32
Dengan pilihan: Dengan pilihan:
Operasi hasil kueri Salin ke clipboard Salin ke clipboard Ekspor Ekspor Tampilkan bagan Tampilkan bagan Buat tampilan Buat tampilan
Markahi kueri SQL ini Markahi kueri SQL ini