Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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
Options
Set default
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:
Database structure
Choose which details to show in the database structure (list of tables).
Database structure
Documentation Show or hide a column displaying the charset for all tables. Restore default value
Documentation Show or hide a column displaying the comments for all tables. Restore default value
Documentation Show or hide a column displaying the Creation timestamp for all tables. Restore default value
Documentation Show or hide a column displaying the Last update timestamp for all tables. Restore default value
Documentation Show or hide a column displaying the Last check timestamp for all tables. Restore default value
Filters
Table Ascending Descending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
actor   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 200 InnoDB utf8_general_ci 32.0 KiB -
actor_info   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
address   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 603 InnoDB utf8_general_ci 96.0 KiB -
category   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16 InnoDB utf8_general_ci 16.0 KiB -
city   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 600 InnoDB utf8_general_ci 64.0 KiB -
country   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 109 InnoDB utf8_general_ci 16.0 KiB -
customer   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 599 InnoDB utf8_general_ci 128.0 KiB -
customer_list   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
film   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,000 InnoDB utf8_general_ci 272.0 KiB -
film_actor   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,462 InnoDB utf8_general_ci 272.0 KiB -
film_category   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,000 InnoDB utf8_general_ci 80.0 KiB -
film_list   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
film_text   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,000 MyISAM utf8_general_ci 317.8 KiB -
inventory   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,581 InnoDB utf8_general_ci 368.0 KiB -
language   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 InnoDB utf8_general_ci 16.0 KiB -
nicer_but_slower_film_list   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
payment   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16,049 InnoDB utf8_general_ci 2.1 MiB -
rental   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16,044 InnoDB utf8_general_ci 2.7 MiB -
sales_by_film_category   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
sales_by_store   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
staff   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8_general_ci 96.0 KiB -
staff_list   Browse Browse Structure Structure Search Search Insert Insert Edit Edit Drop Drop ~0 This view has at least this number of rows. Please refer to documentation. View --- -  -
store   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8_general_ci 48.0 KiB -
23 tables Sum ~47,273 InnoDB utf8mb4_0900_ai_ci 6.6 MiB 0 B
With selected:

Data dictionary Data dictionary

Create new table Create new table