Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: phpmyadmin
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
pma__bookmark
pma__central_columns
pma__column_info
pma__designer_settings
pma__export_templates
pma__favorite
pma__history
pma__navigationhiding
pma__pdf_pages
pma__recent
pma__relation
pma__savedsearches
pma__table_coords
pma__table_info
pma__table_uiprefs
pma__tracking
pma__userconfig
pma__usergroups
pma__users


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.

PDF

Dump table

CSV

CodeGen

LaTeX

Dump table

Object creation options

Data dump options

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:

YAML

This format has no options

Microsoft Word 2000

Dump table

Data dump options

JSON

XML

Object creation options (all are recommended)

Data dump options

MediaWiki Table

Dump table

OpenDocument Text

Dump table

Object creation options

Data dump options

CSV for MS Excel

OpenDocument Spreadsheet

Texy! text

Dump table

Data dump options

Notice in ./templates/database/designer/js_fields.phtml#5
Undefined index: token

Backtrace

./libraries/Template.class.php#80: include(./templates/database/designer/js_fields.phtml)
./libraries/db_designer.lib.php#152: PMA\Template->render(array)
./db_designer.php#148: PMA_getHtmlForJSFields(
array,
array,
array,
integer -1,
)
Notice in ./templates/database/designer/js_fields.phtml#5
Undefined index: token

Backtrace

./libraries/Template.class.php#80: include(./templates/database/designer/js_fields.phtml)
./libraries/db_designer.lib.php#152: PMA\Template->render(array)
./db_designer.php#148: PMA_getHtmlForJSFields(
array,
array,
array,
integer -1,
)