Letakkan berkas disini

SQL upload ( 0 ) x -

Server: localhost »Basis data: fixsmart »Tabel: absensi
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.

Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya.
Dokumentasi Gunakan hanya ikon, hanya teks, atau keduanya.
Dokumentasi Whether a user should be displayed a "show all (rows)" button.
Dokumentasi Jumlah baris yang ditampilkan saat browsing hasil set. Jika hasil set berisi lebih dari satu baris, tautan "Previous" and "Next" akan ditampilkan.
Dokumentasi SMART - yaitu urutan untuk kolom jenis TIME, DATE, DATETIME dan TIMESTAMP, urutan ascending dan sebaliknya.
Dokumentasi Sorot baris yang ditunjuk dengan kursor mouse.
Dokumentasi Sorot baris terpilih.
Dokumentasi
Dokumentasi
Dokumentasi Ulangi header setiap X sel, 0 menonaktifkan fitur ini.
Dokumentasi Jumlah maksimum karakter yang ditunjukkan pada kolom non-angka pada mode jelajah.
Dokumentasi Berikut ini adalah tautan Edit, Salin, dan Hapus.
Dokumentasi Apakah untuk menampilkan link baris bahkan tanpa adanya unique key.
Dokumentasi Default sort order for tables with a primary key.
Dokumentasi Saat browsing tabel, penyortiran setiap tabel akan diingat.
Dokumentasi Untuk pengaturan tampilan
Menampilkan baris 0 - 24 (total 28, Pencarian dilakukan dalam 0.0010 detik.) [foto_masuk: ... - ...]
SELECT * FROM `absensi` ORDER BY `foto_masuk`  ASC
[Edit dikotak] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan]
|
|
|
|
Jumlah baris:
Saring baris:
Sort by key:
Teks penuh iduser_idtanggaljam_masukjam_keluarstatusterlambat_menitpulang_awal_menitdurasi_kerjaketeranganfoto_masuk Menaik Menurun 1foto_keluardevice_infolat_masuklon_masuklat_keluarlon_keluarinput_olehshift_idcreated_byupdated_bydicatat_olehcreated_at
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 12
12 15 2026-03-17 14:05:20 14:08:49 hadir 0 0 3 NULL NULL NULL Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWeb... NULL NULL -8.0752119 111.9150841 self NULL 15 15 NULL 2026-03-17 14:05:18
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 13
13 16 2026-03-17 14:58:06 14:58:21 hadir 0 0 0 NULL NULL NULL Mozilla/5.0 (iPhone; CPU iPhone OS 15_8 like Mac O... -8.0753001 111.9151235 -8.0753001 111.9151235 self NULL 16 16 NULL 2026-03-17 14:58:09
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 14
14 15 2026-03-18 13:47:22 21:13:03 hadir 0 0 445 NULL NULL NULL Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537... -8.0752261 111.9150290 -8.0752370 111.9149371 self 29 15 15 NULL 2026-03-18 13:47:23
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 15
15 11 2026-03-18 NULL NULL hadir 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL admin 29 14 NULL NULL 2026-03-18 14:20:35
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 16
16 16 2026-03-19 07:58:59 15:05:29 hadir 0 0 426 NULL NULL NULL Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_5) Ap... -8.0752395 111.9151840 NULL NULL self 26 16 16 NULL 2026-03-19 07:59:00
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 17
17 15 2026-03-20 06:47:28 NULL hadir 0 0 NULL NULL NULL NULL Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537... -8.0751945 111.9150242 NULL NULL self 28 15 NULL NULL 2026-03-20 06:47:29
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 18
18 15 2026-03-21 21:34:41 NULL terlambat 34 0 NULL NULL NULL NULL Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537... -8.0751941 111.9150239 NULL NULL self 30 15 NULL NULL 2026-03-21 21:34:43
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 19
19 15 2026-03-22 20:59:59 NULL hadir 0 0 NULL NULL NULL NULL Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537... -8.0752351 111.9153384 NULL NULL self 30 15 NULL NULL 2026-03-22 21:00:02
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 20
20 17 2026-03-23 11:35:37 14:05:41 hadir 0 0 150 NULL NULL NULL Mozilla/5.0 (iPhone; CPU iPhone OS 26_3_1 like Mac... -8.0750725 111.9150006 -8.0754373 111.9149252 self NULL 17 17 NULL 2026-03-23 11:35:37
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 21
21 16 2026-03-23 12:47:32 12:53:27 terlambat 287 0 5 NULL NULL NULL Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537... NULL NULL -8.0751435 111.9150321 self 26 16 16 NULL 2026-03-23 12:47:32
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 22
22 17 2026-03-24 07:29:56 14:09:46 hadir 0 0 399 NULL NULL NULL Mozilla/5.0 (iPhone; CPU iPhone OS 26_3_1 like Mac... -8.0753966 111.9150364 -8.0750751 111.9149992 self NULL 17 17 NULL 2026-03-24 07:29:56
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 23
23 16 2026-03-25 07:59:40 NULL hadir 0 0 NULL NULL NULL NULL Mozilla/5.0 (iPhone; CPU iPhone OS 15_8 like Mac O... -8.0752607 111.9151616 NULL NULL self 26 16 NULL NULL 2026-03-25 07:59:40
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 24
24 17 2026-03-25 21:00:35 NULL hadir 0 0 NULL NULL NULL NULL Mozilla/5.0 (iPhone; CPU iPhone OS 26_3_1 like Mac... -8.0754312 111.9149992 NULL NULL self NULL 17 NULL NULL 2026-03-25 21:00:35
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 25
25 17 2026-03-26 07:44:40 07:44:49 hadir 0 0 0 NULL NULL NULL Mozilla/5.0 (iPhone; CPU iPhone OS 26_3_1 like Mac... -8.0753780 111.9150171 -8.0753780 111.9150171 self NULL 17 17 NULL 2026-03-26 07:44:40
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 26
26 16 2026-03-26 07:58:11 15:07:14 hadir 0 0 429 NULL NULL NULL Mozilla/5.0 (iPhone; CPU iPhone OS 15_8 like Mac O... -8.0753253 111.9151078 -8.0754631 111.9150389 self 26 16 16 NULL 2026-03-26 07:58:12
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 27
27 15 2026-03-26 14:01:11 NULL terlambat 1 0 NULL NULL NULL NULL Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537... -8.0751970 111.9150217 NULL NULL self 29 15 NULL NULL 2026-03-26 14:01:15
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 28
28 15 2026-03-27 07:08:51 NULL hadir 0 0 NULL NULL NULL NULL Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537... -8.0751927 111.9150218 NULL NULL self 28 15 NULL NULL 2026-03-27 07:08:52
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 29
29 17 2026-03-27 07:41:46 07:41:54 hadir 0 0 0 NULL NULL NULL Mozilla/5.0 (iPhone; CPU iPhone OS 26_3_1 like Mac... -8.0753736 111.9150224 -8.0753736 111.9150224 self NULL 17 17 NULL 2026-03-27 07:41:46
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 30
30 16 2026-03-27 07:58:02 15:09:39 hadir 0 0 431 NULL NULL NULL NULL NULL -8.0753000 111.9151209 self 26 16 16 NULL 2026-03-27 07:58:12
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 31
31 15 2026-03-28 07:04:56 NULL hadir 0 0 NULL NULL NULL NULL Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537... -8.0751940 111.9150166 NULL NULL self 28 15 NULL NULL 2026-03-28 07:05:14
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 32
32 16 2026-03-28 13:05:08 13:05:22 terlambat 305 0 0 NULL NULL NULL Mozilla/5.0 (iPhone; CPU iPhone OS 15_8 like Mac O... -8.0753923 111.9151197 -8.0753923 111.9151197 self 27 16 16 NULL 2026-03-28 13:05:08
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 33
33 17 2026-03-29 13:59:03 21:10:27 hadir 0 0 431 NULL NULL NULL Mozilla/5.0 (iPhone; CPU iPhone OS 26_3_1 like Mac... -8.0753930 111.9151821 -8.0753774 111.9150354 self NULL 17 17 NULL 2026-03-29 13:59:04
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 34
34 17 2026-03-30 13:51:55 21:08:30 hadir 0 0 436 NULL NULL NULL Mozilla/5.0 (iPhone; CPU iPhone OS 26_3_1 like Mac... -8.0753149 111.9149901 -8.0751616 111.9149627 self NULL 17 17 NULL 2026-03-30 13:52:05
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 35
35 15 2026-03-30 20:43:29 NULL hadir 0 0 NULL NULL NULL NULL Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537... NULL NULL NULL NULL self 30 15 NULL NULL 2026-03-30 20:43:30
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `absensi` WHERE `absensi`.`id` = 36
36 17 2026-03-31 07:33:55 14:02:46 hadir 0 0 388 NULL NULL NULL Mozilla/5.0 (iPhone; CPU iPhone OS 26_3_1 like Mac... -8.0754165 111.9149793 -8.0749541 111.9150359 self NULL 17 17 NULL 2026-03-31 07:33:55
Dengan pilihan: Dengan pilihan:
|
|
|
|
Jumlah baris:
Saring baris:
Sort by key:
Operasi hasil kueriCetak CetakSalin ke clipboard Salin ke clipboardEkspor EksporTampilkan bagan Tampilkan baganBuat tampilan Buat tampilan

Markahi kueri SQL ini Markahi kueri SQL ini