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 Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Ascending Descending Size Overhead
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 --- -  -
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 --- -  -
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_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 --- -  -
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 --- -  -
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 --- -  -
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 -
film_category   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,000 InnoDB utf8_general_ci 80.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 -
film_text   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,000 MyISAM utf8_general_ci 317.8 KiB -
staff   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8_general_ci 96.0 KiB -
country   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 109 InnoDB utf8_general_ci 16.0 KiB -
inventory   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,581 InnoDB utf8_general_ci 368.0 KiB -
customer   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 599 InnoDB utf8_general_ci 128.0 KiB -
language   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 InnoDB utf8_general_ci 16.0 KiB -
store   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8_general_ci 48.0 KiB -
actor   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 200 InnoDB utf8_general_ci 32.0 KiB -
film   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,000 InnoDB utf8_general_ci 272.0 KiB -
payment   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16,049 InnoDB utf8_general_ci 2.1 MiB -
film_actor   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,462 InnoDB utf8_general_ci 272.0 KiB -
rental   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16,044 InnoDB utf8_general_ci 2.7 MiB -
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