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 :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id int
name varchar(255) utf8mb3_general_ci
alias varchar(255) utf8mb3_bin
con_position varchar(255) utf8mb3_general_ci
address text utf8mb3_general_ci
suburb varchar(100) utf8mb3_general_ci
state varchar(100) utf8mb3_general_ci
country varchar(100) utf8mb3_general_ci
postcode varchar(100) utf8mb3_general_ci
telephone varchar(255) utf8mb3_general_ci
fax varchar(255) utf8mb3_general_ci
misc mediumtext utf8mb3_general_ci
image varchar(255) utf8mb3_general_ci
imagepos varchar(20) utf8mb3_general_ci
email_to varchar(255) utf8mb3_general_ci
default_con tinyint
published tinyint(1)
checked_out int
checked_out_time datetime
ordering int
params text utf8mb3_general_ci
user_id int
catid int
access int
mobile varchar(255) utf8mb3_general_ci
webpage varchar(255) utf8mb3_general_ci
sortname1 varchar(255) utf8mb3_general_ci
sortname2 varchar(255) utf8mb3_general_ci
sortname3 varchar(255) utf8mb3_general_ci
language char(7) utf8mb3_general_ci
created datetime
created_by int
created_by_alias varchar(255) utf8mb3_general_ci
modified datetime
modified_by int
metakey text utf8mb3_general_ci
metadesc text utf8mb3_general_ci
metadata text utf8mb3_general_ci
featured tinyint
xreference varchar(50) utf8mb3_general_ci
publish_up datetime
publish_down datetime
Display order: