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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customise browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `1country_states`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id country_id country_code code default_name
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 1
1 244 US AL Alabama
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 2
2 244 US AK Alaska
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 3
3 244 US AS American Samoa
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 4
4 244 US AZ Arizona
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 5
5 244 US AR Arkansas
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 6
6 244 US AE Armed Forces Africa
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 7
7 244 US AA Armed Forces Americas
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 8
8 244 US AE Armed Forces Canada
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 9
9 244 US AE Armed Forces Europe
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 10
10 244 US AE Armed Forces Middle East
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 11
11 244 US AP Armed Forces Pacific
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 12
12 244 US CA California
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 13
13 244 US CO Colorado
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 14
14 244 US CT Connecticut
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 15
15 244 US DE Delaware
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 16
16 244 US DC District of Columbia
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 17
17 244 US FM Federated States Of Micronesia
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 18
18 244 US FL Florida
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 19
19 244 US GA Georgia
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 20
20 244 US GU Guam
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 21
21 244 US HI Hawaii
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 22
22 244 US ID Idaho
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 23
23 244 US IL Illinois
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 24
24 244 US IN Indiana
Edit Edit Copy Copy Delete Delete
DELETE FROM 1country_states WHERE `1country_states`.`id` = 25
25 244 US IA Iowa
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query