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 `help_topic`
Edit dikotak ] [ Ubah ] [ Jelaskan SQL ] [ Buat kode PHP ] [ Segarkan ]
Teks penuh help_topic_id name help_category_id description example url
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 0
0 MIN 16 Syntax:
MIN([DISTINCT] expr)

Returns the minimum ...
MariaDB> SELECT student_name, MIN(test_score), MAX...
https://mariadb.com/kb/en/min/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 1
1 JOIN 27 MySQL supports the following JOIN syntaxes for the...
SELECT left_tbl.*
  FROM left_tbl LEFT JOIN right_...
https://mariadb.com/kb/en/join-syntax/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 2
2 HEX 37 Syntax:
HEX(str), HEX(N)

For a string argument st...
MariaDB> SELECT 0x616263, HEX('abc'), UNHEX(HEX('a...
https://mariadb.com/kb/en/hex/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 3
3 REPLACE 27 Syntax:
REPLACE [LOW_PRIORITY | DELAYED]
   [INTO...
https://mariadb.com/kb/en/replace/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 4
4 CONTAINS 30 Contains(g1,g2)

Returns 1 or 0 to indicate whethe...
https://mariadb.com/kb/en/contains/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 5
5 SRID 36 SRID(g)

Returns an integer indicating the Spatial...
MariaDB> SELECT SRID(GeomFromText('LineString(1 1,...
https://mariadb.com/kb/en/srid/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 6
6 CURRENT_TIMESTAMP 31 Syntax:
CURRENT_TIMESTAMP, CURRENT_TIMESTAMP()

CU...
https://mariadb.com/kb/en/current_timestamp/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 7
7 SHOW CONTRIBUTORS 26 Syntax:
SHOW CONTRIBUTORS

The SHOW CONTRIBUTORS s...
https://mariadb.com/kb/en/show-contributors/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 8
8 VARIANCE 16 Syntax:
VARIANCE(expr)

Returns the population sta...
https://mariadb.com/kb/en/variance/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 9
9 DROP SERVER 39 Syntax:
DROP SERVER [ IF EXISTS ] server_name

Dro...
https://mariadb.com/kb/en/drop-server/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 10
10 SHOW AUTHORS 26 Syntax:
SHOW AUTHORS

The SHOW AUTHORS statement d...
https://mariadb.com/kb/en/show-authors/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 11
11 VAR_SAMP 16 Syntax:
VAR_SAMP(expr)

Returns the sample varianc...
https://mariadb.com/kb/en/var_samp/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 12
12 CONCAT 37 Syntax:
CONCAT(str1,str2,...)

Returns the string ...
MariaDB> SELECT CONCAT('My', 'S', 'QL');
        -...
https://mariadb.com/kb/en/concat/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 13
13 GEOMETRY HIERARCHY 34 Geometry is the base class. It is an abstract clas... https://mariadb.com/kb/en/geometry-hierarchy/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 14
14 CHAR FUNCTION 37 Syntax:
CHAR(N,... [USING charset_name])

CHAR() i...
MariaDB> SELECT CHAR(77,121,83,81,'76');
        -...
https://mariadb.com/kb/en/char-function/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 15
15 DATETIME 22 DATETIME

A date and time combination. The support...
https://mariadb.com/kb/en/datetime/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 16
16 SHOW CREATE TRIGGER 26 Syntax:
SHOW CREATE TRIGGER trigger_name

This sta...
https://mariadb.com/kb/en/show-create-trigger/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 17
17 SHOW CREATE PROCEDURE 26 Syntax:
SHOW CREATE PROCEDURE proc_name

This stat...
MariaDB> SHOW CREATE PROCEDURE test.simpleproc\G
*...
https://mariadb.com/kb/en/show-create-procedure/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 18
18 OPEN 23 Syntax:
OPEN cursor_name

This statement opens a p...
https://mariadb.com/kb/en/open/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 19
19 INTEGER 22 INTEGER[(M)] [UNSIGNED] [ZEROFILL]

This type is a...
https://mariadb.com/kb/en/sql_language-data_types-int
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 20
20 LOWER 37 Syntax:
LOWER(str)

Returns the string str with al...
https://mariadb.com/kb/en/lower/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 21
21 SHOW COLUMNS 26 Syntax:
SHOW [FULL] COLUMNS {FROM | IN} tbl_name [...
https://mariadb.com/kb/en/show-columns/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 22
22 CREATE TRIGGER 39 Syntax:
CREATE
   [DEFINER = { user | CURRENT_USE...
https://mariadb.com/kb/en/create-trigger/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 23
23 MONTH 31 Syntax:
MONTH(date)

Returns the month for date, i...
MariaDB> SELECT MONTH('2008-02-03');
        -> 2

https://mariadb.com/kb/en/month/
Ubah Ubah Salin Salin Hapus Hapus
DELETE FROM help_topic WHERE `help_topic`.`help_topic_id` = 24
24 TINYINT 22 TINYINT[(M)] [UNSIGNED] [ZEROFILL]

A very small i...
https://mariadb.com/kb/en/tinyint/
Dengan pilihan: Dengan pilihan:
Markahi kueri SQL ini Markahi kueri SQL ini