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(11)
palc_type int(11)
palc_id int(11)
evaluation_id int(11)
app_date date
refno varchar(100) latin1_swedish_ci
clearanceno varchar(100) latin1_swedish_ci
applicationno varchar(100) latin1_swedish_ci
referenceno varchar(100) latin1_swedish_ci
projectID int(11)
projectName varchar(255) latin1_swedish_ci
projectLoc varchar(255) latin1_swedish_ci
projectTel varchar(255) latin1_swedish_ci
applicantID int(11)
applicantName varchar(255) latin1_swedish_ci
app_address varchar(255) latin1_swedish_ci
app_tellno varchar(255) latin1_swedish_ci
app_type varchar(11) latin1_swedish_ci
total_area varchar(255) latin1_swedish_ci
total_lots varchar(255) latin1_swedish_ci
projectclass varchar(255) latin1_swedish_ci
rightoverland varchar(255) latin1_swedish_ci
issue_by int(11)
purpose varchar(250) latin1_swedish_ci
evaluation_facts varchar(250) latin1_swedish_ci
decision_ varchar(255) latin1_swedish_ci
conditions1 varchar(50) latin1_swedish_ci
conditions2 varchar(50) latin1_swedish_ci
conditions3 varchar(50) latin1_swedish_ci
conditions4 varchar(50) latin1_swedish_ci
conditions5 varchar(50) latin1_swedish_ci
conditions6 varchar(50) latin1_swedish_ci
authorityby int(11)
authorityname varchar(255) latin1_swedish_ci
toID varchar(11) latin1_swedish_ci
toName varchar(255) latin1_swedish_ci
toPosition varchar(255) latin1_swedish_ci
devID int(11)
devName varchar(255) latin1_swedish_ci
devAddress varchar(255) latin1_swedish_ci
devTelNo varchar(255) latin1_swedish_ci
devType varchar(11) latin1_swedish_ci
devPermit int(11)
stat varchar(11) latin1_swedish_ci
timestamp timestamp
Display order: