Letakkan berkas disini

SQL upload ( 0 ) x -

Server: localhost »Basis data: mysql »Tabel: help_topic"help topics"
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 508, Pencarian dilakukan dalam 0.0009 detik.) [name: !... - ALTER DATABASE...]
SELECT * FROM `help_topic` ORDER BY `name`  ASC
[Edit dikotak] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan]
|
|
|
Jumlah baris:
Saring baris:
Sort by key:
Teks penuh help_topic_idname Menaik Menurun 1help_category_iddescriptionexampleurl
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 312
312 ! 15 Syntax:
NOT, !

Logical NOT. Evaluates to 1 if the...		 
MariaDB> SELECT NOT 10;
        -> 0
MariaDB> SELE...
https://mariadb.com/kb/en/not/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 495
495 != 18 Syntax:
<>, !=

Not equal:

URL: https://mariadb.c...		 
MariaDB> SELECT '.01' <> '0.01';
        -> 1
Mari...
https://mariadb.com/kb/en/not-equal/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 174
174 % 4 Syntax:
N % M, N MOD M

Modulo operation. Returns ...		 https://mariadb.com/kb/en/modulo-operator/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 227
227 & 19 Syntax:
&

Bitwise AND:

URL: https://mariadb.com/...		 
MariaDB> SELECT 29 & 15;
        -> 13
https://mariadb.com/kb/en/bitwise_and/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 316
316 && 15 Syntax:
AND, &&

Logical AND. Evaluates to 1 if al...		 
MariaDB> SELECT 1 && 1;
        -> 1
MariaDB> SELE...
https://mariadb.com/kb/en/and/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 98
98 * 4 Syntax:
*

Multiplication:

URL: https://mariadb.c...		 
MariaDB> SELECT 3*5;
        -> 15
MariaDB> SELECT...
https://mariadb.com/kb/en/multiplication-operator/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 444
444 + 4 Syntax:
+

Addition:

URL: https://mariadb.com/kb/...		 
MariaDB> SELECT 3+5;
        -> 8
https://mariadb.com/kb/en/addition-operator/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 245
245 - BINARY 4 Syntax:
-

Subtraction:

URL: https://mariadb.com/...		 
MariaDB> SELECT 3-5;
        -> -2
https://mariadb.com/kb/en/subtraction-operator-/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 259
259 - UNARY 4 Syntax:
-

Unary minus. This operator changes the ...		 
MariaDB> SELECT - 2;
        -> -2
https://mariadb.com/kb/en/subtraction-operator-/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 268
268 / 4 Syntax:
/

Division:

URL: https://mariadb.com/kb/...		 
MariaDB> SELECT 3/5;
        -> 0.60
https://mariadb.com/kb/en/division-operator/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 217
217 < 18 Syntax:
<

Less than:

URL: https://mariadb.com/kb...		 
MariaDB> SELECT 2 < 2;
        -> 0
https://mariadb.com/kb/en/less-than/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 214
214 << 19 Syntax:
<<

Shifts a longlong (BIGINT) number to t...		 
MariaDB> SELECT 1 << 2;
        -> 4
https://mariadb.com/kb/en/shift-left/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 81
81 <= 18 Syntax:
<=

Less than or equal:

URL: https://mari...		 
MariaDB> SELECT 0.1 <= 2;
        -> 1
https://mariadb.com/kb/en/less-than-or-equal/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 117
117 <=> 18 Syntax:
<=>

NULL-safe equal. This operator perfor...		 
MariaDB> SELECT 1 <=> 1, NULL <=> NULL, 1 <=> NULL...
https://mariadb.com/kb/en/null-safe-equal/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 71
71 = 18 =

Equal:

URL: https://mariadb.com/kb/en/equal/

 
MariaDB> SELECT 1 = 0;
        -> 0
MariaDB> SELEC...
https://mariadb.com/kb/en/equal/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 469
469 > 18 Syntax:
>

Greater than:

URL: https://mariadb.com...		 
MariaDB> SELECT 2 > 2;
        -> 0
https://mariadb.com/kb/en/greater-than/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 283
283 >= 18 Syntax:
>=

Greater than or equal:

URL: https://m...		 
MariaDB> SELECT 2 >= 2;
        -> 1
https://mariadb.com/kb/en/greater-than-or-equal/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 382
382 >> 19 Syntax:
>>

Shifts a longlong (BIGINT) number to t...		 
MariaDB> SELECT 4 >> 2;
        -> 1
https://mariadb.com/kb/en/shift-right/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 90
90 ABS 4 Syntax:
ABS(X)

Returns the absolute value of X.

...		 
MariaDB> SELECT ABS(2);
        -> 2
MariaDB> SELE...
https://mariadb.com/kb/en/abs/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 446
446 ACOS 4 Syntax:
ACOS(X)

Returns the arc cosine of X, that...		 
MariaDB> SELECT ACOS(1);
        -> 0
MariaDB> SEL...
https://mariadb.com/kb/en/acos/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 231
231 ADDDATE 31 Syntax:
ADDDATE(date,INTERVAL expr unit), ADDDATE(...		 
MariaDB> SELECT ADDDATE('2008-01-02', 31);
       ...
https://mariadb.com/kb/en/adddate/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 59
59 ADDTIME 31 Syntax:
ADDTIME(expr1,expr2)

ADDTIME() adds expr2...		 
MariaDB> SELECT ADDTIME('2007-12-31 23:59:59.99999...
https://mariadb.com/kb/en/addtime/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 497
497 AES_DECRYPT 12 Syntax:
AES_DECRYPT(crypt_str,key_str)

This funct...		 https://mariadb.com/kb/en/aes_decrypt/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 443
443 AES_ENCRYPT 12 Syntax:
AES_ENCRYPT(str,key_str)

AES_ENCRYPT() an...		 
INSERT INTO t VALUES (1,AES_ENCRYPT('text','passwo...
https://mariadb.com/kb/en/aes_encrypt/
Ubah UbahSalin SalinHapus Hapus
DELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 212
212 ALTER DATABASE 39 Syntax:
ALTER {DATABASE | SCHEMA} [db_name]
   al...		 https://mariadb.com/kb/en/alter-database/
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