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 :

Log biner

Pilih log biner untuk ditampilkan 392 Berkas, 4,569 MB
SHOW BINLOG EVENTS LIMIT 0, 25
Show full queries - »
Catat nama Posisi Jenis event ID Server Posisi aslinya Informasi
mysql-bin.000001 4 Format_desc 1 256
Server ver: 10.4.20-MariaDB-log, Binlog ver: 4
mysql-bin.000001 256 Gtid_list 1 285
[]
mysql-bin.000001 285 Binlog_checkpoint 1 328
mysql-bin.000001
mysql-bin.000001 328 Gtid 1 370
GTID 0-1-1
mysql-bin.000001 370 Query 1 455
create database sik
mysql-bin.000001 455 Gtid 1 497
GTID 0-1-2
mysql-bin.000001 497 Query 1 617
use `sik`; DROP TABLE IF EXISTS `admin` /* generated by server */
mysql-bin.000001 617 Gtid 1 659
GTID 0-1-3
mysql-bin.000001 659 Query 1 847
use `sik`; CREATE TABLE `admin` (
  `usere` text DEFAULT NULL,
  `passworde` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
mysql-bin.000001 847 Gtid 1 889
GTID 0-1-4
mysql-bin.000001 889 Query 1 999
use `sik`; /*!40000 ALTER TABLE `admin` DISABLE KEYS */
mysql-bin.000001 999 Gtid 1 1041
BEGIN GTID 0-1-5
mysql-bin.000001 1041 Query 1 1197
use `sik`; INSERT INTO `admin` VALUES ('!c¯tÕÐ<¦Á%‚s‰D','K¤ŠÈÝf¡ÖàgâA™Æã½')
mysql-bin.000001 1197 Xid 1 1228
COMMIT /* xid=24 */
mysql-bin.000001 1228 Gtid 1 1270
GTID 0-1-6
mysql-bin.000001 1270 Query 1 1379
use `sik`; /*!40000 ALTER TABLE `admin` ENABLE KEYS */
mysql-bin.000001 1379 Gtid 1 1421
GTID 0-1-7
mysql-bin.000001 1421 Query 1 1556
use `sik`; DROP TABLE IF EXISTS `akun_aset_inventaris` /* generated by server */
mysql-bin.000001 1556 Gtid 1 1598
GTID 0-1-8
mysql-bin.000001 1598 Query 1 2190
use `sik`; CREATE TABLE `akun_aset_inventaris` (
  `kd_rek` varchar(15) DEFAULT NULL,
  `id_jenis` char(10) NOT NULL,
  PRIMARY KEY (`id_jenis`) USING BTREE,
  KEY `kd_rek` (`kd_rek`) USING BTREE,
  CONSTRAINT `akun_aset_inventaris_ibfk_1` FOREIGN KEY (`kd_rek`) REFERENCES `rekening` (`kd_rek`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `akun_aset_inventaris_ibfk_2` FOREIGN KEY (`id_jenis`) REFERENCES `inventaris_jenis` (`id_jenis`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC
mysql-bin.000001 2190 Gtid 1 2232
GTID 0-1-9
mysql-bin.000001 2232 Query 1 2357
use `sik`; /*!40000 ALTER TABLE `akun_aset_inventaris` DISABLE KEYS */
mysql-bin.000001 2357 Gtid 1 2399
GTID 0-1-10
mysql-bin.000001 2399 Query 1 2523
use `sik`; /*!40000 ALTER TABLE `akun_aset_inventaris` ENABLE KEYS */
mysql-bin.000001 2523 Gtid 1 2565
GTID 0-1-11