Recent
`mysql`.`proc`
`dbfederation`.`users`
`dbfederation`.`oauth_auth_codes`
`dbfederation`.`model_has_permissions`
`budget`.`beginning_temp`
`lgis_app`.`tbl_items_setup`
`budget`.`lbp2_programappropriation`
`accounting`.`conversion_setup`
`accounting`.`check_prep_apvs`
`humanresource`.`employees_voluntarilywork`
Favorites
There are no favorite tables.
New
accounting
bac_lgu
budget
cenro
dbfederation
db_meter_readings
documenttracker
el_laravue
general
humanresource
information_schema
lgis
lgis_app
lgis_dum_app
lgu_repository
mysql
online_hr
performance
performance_management
performance_schema
qpsii
qpsii_lguengineering
qpsii_lguprocurement
qpsii_lgusystem
qpsii_waterworks
queue
repository
service_request_db
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: bac_lgu
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
Debug SQL
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
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
id
bacc_proj_id
trans_date
ref_no
name_of_project
remarks
proc_type
*
id
bacc_proj_id
project_name
itb_no
philgep
prebidd_conference
opening
bid_fees
itb_member_id
ref
*
id
bacc_proj_id
activities
schedule
*
id
bacc_proj_id
proj_name
trans_date
ref_no
supplemental
remarks
*
id
bacc_proj_id
proj_name
trans_date
ref_no
mop
remarks
*
id
bacc_proj_id
proj_name
trans_date
ref_no
mop
date_effictive
remarks
*
id
entry_type
account_code
*
id
proj_id
bull_no
trans_type
attch_description
remarks
doctype_id
file_name
file_path
file_size
stat
uid
ts
doc_main_id
*
id
proj_id
business_number
business_name
bid_fees
or_date
or_no
abc_amount
security_type
security_remarks
bidsecurity
bidamount
rating
remarks
stat
ts
winner
*
id
org_id
description
*
id
proj_id
contract_date
contract_cost
request_
date_sp_request
session_date
reso_attach
sp_resolution_no
remarks
*
id
proj_id
type
type_id
file_name
file_path
file_size
stat
ts
uid
*
id
proj_id
entry_type
business_id
business_name
date_invitation
date_receipt
attachment
ts
winner
itb_no
doc_amount
abc_amount
organization
*
id
proj_id
entry_type
business_id
business_name
organization
date_invitation
date_receipt
attachment
ts
*
id
proj_id
type
type_id
file_name
file_path
file_size
stat
ts
uid
*
id
proj_id
business_number
business_name
bidamount
noa_issuance_date
noa_receipt
deadline_dole_approved
performance_type
performance_date
performance_amount
dole_cshp
remarks
ts
proc_type
*
id
proj_id
contract_duration
ntp_issuance
effectivity
expected_completion
remarks
*
id
type
description
order
stats
*
id
proj_id
bull_no
trans_type
attch_description
remarks
doctype_id
file_name
file_path
file_size
stat
uid
ts
*
id
process_name
orderby
*
id
mop_id
mop_name
proc_type
ref_no
itb_no
trans_date
steps
pow_id
proj_id
doc_ref
title_of_project
ABC
SOF
pre_proc
posting
pre_bid
bid_opening
post_qua
noa
posting2
perf_sec
sp_resolution
contract_date
ntp_issuance
ntp_effective
winning_bidder
bidder_id
contract_cost
contract_duration
expected_date_completion
remarks
ts
stat
bid_bulletin
row_index
loc_project
*
id
declaration
bac_proj_id
*
id
bac_proj_id
file_size
file_name
file_path
file_full_path
entry_type
ts
*
id
trans_date
resolution_no
mop_id
mop_name
mop_others
remarks
ts
stat
*
id
resolution_id
pr_id
title
pr_ref
AMOUNT
status
*
id
date
resolution_title
status
*
id
mem_id
bacmember_id
emp_name
position
category
present
*
id
itb_no
trans_type
trans_date
bidDate
bidTime
to_person
very_truly
approved_by
stat
ts
*
id
emp_id
emp_name
position
category
type
status
sig
sig_position
*
id
mainID
documents_issued
date_issued
status
*
id
document_name
stat
*
id
row_num
business_id
business_name
business_owner
business_address
eligibility_description
mop
abc_a
abc_b
abc_c
remarks_others
stat
uid
upid
ts
validity
Vat
*
id
row_num
business_id
business_name
business_owner
business_address
mop
stat
uid
upid
ts
Vat
*
id
main_id
remarks
*
ID
MainGroup
SubGroup1
SubGroup2
GroupOrder
STATUS
*
id
bac_project_id
mop_id
mop_name
proc_type
doc_ref
title_of_project
ABC
pre_proc
contract_date
contract_cost
contract_duration
remarks
ts
stat
bid_bulletin
select table
bacc_1pre
bacc_2invitationtobid
bacc_2invitationtobid_activities
bacc_7suplemental
bacc_15resolution
bacc_16noa
bacc_account_mapping
bacc_bid_bulletin
bacc_bid_opening
bacc_commite_tag
bacc_contract
bacc_invitation_bidopening_docs
bacc_invitation_opening_bid
bacc_invitation_prebid
bacc_invitation_prebid_docs
bacc_noa
bacc_ntp
bacc_preproc_docs
bacc_pre_docs_entry
bacc_proc_process
bacc_proj
bacc_proj_bid_declaration
bacc_proj_docs
bacc_resolution
bacc_resolution_details
bacc_resolution_title
bac_attendancemember
bac_bid_invitation_leter
bac_members
eligibility_documents
eligibility_documents_setup
eligibility_main
eligibility_non_main
eligibility_remarks
isgroup_setup
motion_recon
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
bacc_1pre
bacc_2invitationtobid
bacc_2invitationtobid_activities
bacc_7suplemental
bacc_15resolution
bacc_16noa
bacc_account_mapping
bacc_bid_bulletin
bacc_bid_opening
bacc_commite_tag
bacc_contract
bacc_invitation_bidopening_docs
bacc_invitation_opening_bid
bacc_invitation_prebid
bacc_invitation_prebid_docs
bacc_noa
bacc_ntp
bacc_preproc_docs
bacc_pre_docs_entry
bacc_proc_process
bacc_proj
bacc_proj_bid_declaration
bacc_proj_docs
bacc_resolution
bacc_resolution_details
bacc_resolution_title
bac_attendancemember
bac_bid_invitation_leter
bac_members
eligibility_documents
eligibility_documents_setup
eligibility_main
eligibility_non_main
eligibility_remarks
isgroup_setup
motion_recon
.
select column
select table
bacc_1pre
bacc_2invitationtobid
bacc_2invitationtobid_activities
bacc_7suplemental
bacc_15resolution
bacc_16noa
bacc_account_mapping
bacc_bid_bulletin
bacc_bid_opening
bacc_commite_tag
bacc_contract
bacc_invitation_bidopening_docs
bacc_invitation_opening_bid
bacc_invitation_prebid
bacc_invitation_prebid_docs
bacc_noa
bacc_ntp
bacc_preproc_docs
bacc_pre_docs_entry
bacc_proc_process
bacc_proj
bacc_proj_bid_declaration
bacc_proj_docs
bacc_resolution
bacc_resolution_details
bacc_resolution_title
bac_attendancemember
bac_bid_invitation_leter
bac_members
eligibility_documents
eligibility_documents_setup
eligibility_main
eligibility_non_main
eligibility_remarks
isgroup_setup
motion_recon
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
bacc_1pre
bacc_2invitationtobid
bacc_2invitationtobid_activities
bacc_7suplemental
bacc_15resolution
bacc_16noa
bacc_account_mapping
bacc_bid_bulletin
bacc_bid_opening
bacc_commite_tag
bacc_contract
bacc_invitation_bidopening_docs
bacc_invitation_opening_bid
bacc_invitation_prebid
bacc_invitation_prebid_docs
bacc_noa
bacc_ntp
bacc_preproc_docs
bacc_pre_docs_entry
bacc_proc_process
bacc_proj
bacc_proj_bid_declaration
bacc_proj_docs
bacc_resolution
bacc_resolution_details
bacc_resolution_title
bac_attendancemember
bac_bid_invitation_leter
bac_members
eligibility_documents
eligibility_documents_setup
eligibility_main
eligibility_non_main
eligibility_remarks
isgroup_setup
motion_recon
.
select column
select table
bacc_1pre
bacc_2invitationtobid
bacc_2invitationtobid_activities
bacc_7suplemental
bacc_15resolution
bacc_16noa
bacc_account_mapping
bacc_bid_bulletin
bacc_bid_opening
bacc_commite_tag
bacc_contract
bacc_invitation_bidopening_docs
bacc_invitation_opening_bid
bacc_invitation_prebid
bacc_invitation_prebid_docs
bacc_noa
bacc_ntp
bacc_preproc_docs
bacc_pre_docs_entry
bacc_proc_process
bacc_proj
bacc_proj_bid_declaration
bacc_proj_docs
bacc_resolution
bacc_resolution_details
bacc_resolution_title
bac_attendancemember
bac_bid_invitation_leter
bac_members
eligibility_documents
eligibility_documents_setup
eligibility_main
eligibility_non_main
eligibility_remarks
isgroup_setup
motion_recon
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
bacc_1pre
bacc_2invitationtobid
bacc_2invitationtobid_activities
bacc_7suplemental
bacc_15resolution
bacc_16noa
bacc_account_mapping
bacc_bid_bulletin
bacc_bid_opening
bacc_commite_tag
bacc_contract
bacc_invitation_bidopening_docs
bacc_invitation_opening_bid
bacc_invitation_prebid
bacc_invitation_prebid_docs
bacc_noa
bacc_ntp
bacc_preproc_docs
bacc_pre_docs_entry
bacc_proc_process
bacc_proj
bacc_proj_bid_declaration
bacc_proj_docs
bacc_resolution
bacc_resolution_details
bacc_resolution_title
bac_attendancemember
bac_bid_invitation_leter
bac_members
eligibility_documents
eligibility_documents_setup
eligibility_main
eligibility_non_main
eligibility_remarks
isgroup_setup
motion_recon
.
select column
select table
bacc_1pre
bacc_2invitationtobid
bacc_2invitationtobid_activities
bacc_7suplemental
bacc_15resolution
bacc_16noa
bacc_account_mapping
bacc_bid_bulletin
bacc_bid_opening
bacc_commite_tag
bacc_contract
bacc_invitation_bidopening_docs
bacc_invitation_opening_bid
bacc_invitation_prebid
bacc_invitation_prebid_docs
bacc_noa
bacc_ntp
bacc_preproc_docs
bacc_pre_docs_entry
bacc_proc_process
bacc_proj
bacc_proj_bid_declaration
bacc_proj_docs
bacc_resolution
bacc_resolution_details
bacc_resolution_title
bac_attendancemember
bac_bid_invitation_leter
bac_members
eligibility_documents
eligibility_documents_setup
eligibility_main
eligibility_non_main
eligibility_remarks
isgroup_setup
motion_recon
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
bacc_1pre
bacc_2invitationtobid
bacc_2invitationtobid_activities
bacc_7suplemental
bacc_15resolution
bacc_16noa
bacc_account_mapping
bacc_bid_bulletin
bacc_bid_opening
bacc_commite_tag
bacc_contract
bacc_invitation_bidopening_docs
bacc_invitation_opening_bid
bacc_invitation_prebid
bacc_invitation_prebid_docs
bacc_noa
bacc_ntp
bacc_preproc_docs
bacc_pre_docs_entry
bacc_proc_process
bacc_proj
bacc_proj_bid_declaration
bacc_proj_docs
bacc_resolution
bacc_resolution_details
bacc_resolution_title
bac_attendancemember
bac_bid_invitation_leter
bac_members
eligibility_documents
eligibility_documents_setup
eligibility_main
eligibility_non_main
eligibility_remarks
isgroup_setup
motion_recon
.
select column
mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.