Current server:
(Servers) ...
phpMyAdmin demo - MariaDB (root)
phpMyAdmin demo - MySQL (root)
Recent
`sakila`.`film`
`world`.`City`
`sakila`.`actor`
`sakila`.`city`
`sakila`.`payment`
`world`.`Country`
`information_schema`.`COLLATIONS`
`sakila`.`customer`
`sakila`.`inventory`
`sakila`.`country`
Favorites
There are no favorite tables.
New
buku_tamu_db
information_schema
menagerie
mysql
opengis
performance_schema
phpmyadmin
RAFIANO
sakila
student
Student_info
world
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: phpMyAdmin demo - MariaDB
pangkalan data
SQL
Status
User accounts
Eksport
Import
Settings
(current)
Binary log
Replikasi
Pemboleh-pembolehubah
Charsets
Engines
Plugins
root@192.168.30.%
Dokumentasi phpMyAdmin
MariaDB documentation
Appearance:
Light
Dark
Settings
Log keluar
Console
Clear
History
Options
Bookmarks
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count:
Time taken:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
Options
Restore default values
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Ubah
Explain
Profiling
Bookmark
Query failed
Pangkalan Data:
Queried time:
Loading
ENUM/SET editor
Create view
Manage your settings
Two-factor authentication
Features
SQL queries
Navigation panel
Main panel
Eksport
Import
Import defaults
SQL
data CSV
OpenDocument
Import defaults
Customize default common import options.
Import defaults
Format of imported file
Default format; be aware that this list depends on location (database, table) and only SQL is always available.
csv
docsql
ldi
sql
Character set of the file
iso-8859-1
iso-8859-2
iso-8859-3
iso-8859-4
iso-8859-5
iso-8859-6
iso-8859-7
iso-8859-8
iso-8859-9
iso-8859-10
iso-8859-11
iso-8859-12
iso-8859-13
iso-8859-14
iso-8859-15
windows-1250
windows-1251
windows-1252
windows-1256
windows-1257
koi8-r
big5
gb2312
utf-16
utf-8
utf-7
x-user-defined
euc-jp
ks_c_5601-1987
tis-620
SHIFT_JIS
SJIS
SJIS-win
Partial import: allow interrupt
Allow interrupt of import in case script detects it is close to time limit. This might be a good way to import large files, however it can break transactions.
Partial import: skip queries
Number of queries to skip from start.
Enable drag and drop import
Uncheck the checkbox to disable drag and drop import
SQL
Customize default options.
SQL
SQL compatibility mode
NONE
ANSI
DB2
MAXDB
MYSQL323
MYSQL40
MSSQL
ORACLE
TRADITIONAL
Do not use AUTO_INCREMENT for zero values
Read as multibytes
data CSV
Customize default options.
data CSV
data CSV
Add ON DUPLICATE KEY UPDATE
Update data when duplicate keys found on import
Do not abort on INSERT error
Columns terminated with
Columns enclosed with
Columns escaped with
Lines terminated with
CSV using LOAD DATA
Add ON DUPLICATE KEY UPDATE
Update data when duplicate keys found on import
Do not abort on INSERT error
Columns terminated with
Columns enclosed with
Columns escaped with
Use LOCAL keyword
auto
Ya
Tidak
OpenDocument
Customize default options.
OpenDocument
OpenDocument Spreadsheet
Column names in first row
Do not import empty rows
Import percentages as proper decimals (12.00% to .12)
Import currencies ($5.00 to 5.00)
phpMyAdmin Demo Server:
Currently running Git revision
RELEASE_5_2_1-4907-g5b04607256
from the
master
branch.