Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1:3309 »Database: mysql
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

Export defaults

Customize default export options.

Quick
Custom
SQL

Customize default options.

Structure
Data
CodeGen

Customize default options.

CSV

Customize default options.

CSV
CSV for MS Excel
LaTeX

Customize default options.

Structure
Data
Microsoft Office

Customize default options.

Microsoft Word 2000
OpenDocument

Customize default options.

OpenDocument Spreadsheet
OpenDocument Text
Structure
Data
Texy! text

Customize default options

Data

Export templates:

New template:

Existing templates:

Export method:

Format:

Tables:

TablesStructureData
Select all
agama
applications
app_installed
auth_assignment
auth_data
auth_header
auth_item
auth_item_child
auth_rule
bacaditempat
bacaditempat_locations
backup
bibidavailable
bookinglogs
bookmark
branchs
cardformats
catalogfiles
catalogs
catalogstaging
catalog_ruas
catalog_subruas
cetak_bebas_pustaka
cetak_kartu_anggota
checkpoint_locations
collectioncategorys
collectioncategorysdefault
collectionloanextends
collectionloanitems
collectionloans
collectionlocations
collectionmedias
collectionrules
collectionrulesitems
collections
collectionsources
collectionstatus
colloclib
columns_priv
column_stats
currency
daemons
db
departments
djkn_data
event
favorite
fielddatas
fieldgroups
fieldindicator1s
fieldindicator2s
fields
formats
func
gammu
general_log
groupguesses
gtid_slave_pos
help_category
help_keyword
help_relation
help_topic
historydata
holidays
host
inbox
index_stats
innodb_index_stats
innodb_table_stats
ndb_binlog_index
plugin
proc
procs_priv
proxies_priv
roles_mapping
servers
slave_master_info
slave_relay_log_info
slave_worker_info
slow_log
tables_priv
table_stats
time_zone
time_zone_leap_second
time_zone_name
time_zone_transition
time_zone_transition_type
user
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name
Old column nameNew column name

Output:

MiB

Format-specific options:

Scroll down to fill in the options for the selected format and ignore the options for other formats.

CodeGen

CSV

CSV for MS Excel

Microsoft Word 2000

Dump table

Data dump options

JSON

LaTeX

Dump table

Object creation options

Data dump options

MediaWiki Table

Dump table

OpenDocument Spreadsheet

OpenDocument Text

Dump table

Object creation options

Data dump options

PDF

Dump table

PHP array

This format has no options

SQL

Object creation options

  • Add statements:

Data creation options

  • Instead of INSERT statements, use:

  • Syntax to use when inserting data:

Texy! text

Dump table

Data dump options

XML

Object creation options (all are recommended)

Data dump options

YAML

This format has no options

Warning in .\libraries\session.inc.php#131
session_regenerate_id(): Session object destruction failed

Backtrace

.\libraries\session.inc.php#131: session_regenerate_id(boolean true)
.\libraries\common.inc.php#878: PMA_secureSession()
.\db_export.php#12: require_once(.\libraries\common.inc.php)