近期访问
`performance_schema`.`socket_summary_by_event_name`
`phpmyadmin`.`pma__relation`
`performance_schema`.`table_io_waits_summary_by_table`
`performance_schema`.`performance_timers`
`phpmyadmin`.`pma__recent`
`mysql`.`proc`
`mysql`.`time_zone_leap_second`
`phpmyadmin`.`pma__usergroups`
`phpmyadmin`.`pma__designer_settings`
`mysql`.`time_zone`
表收藏夹
表收藏夹为空。
新建
information_schema
loansystemdb
mysql
performance_schema
phpmyadmin
test
导航面板
导航树
服务器
数据库
表
导航面板
自定义导航面板。
以树状显示数据库导航面板
导航栏使用数据库选择器替代树形列表
与主面板链接
高亮当前数据库或表链接到主面板。
显示徽标
在导航面板中显示图示。
徽标链接地址
导航面板中图示指向的链接地址。
徽标链接目标
在主窗口(
main
)或新窗口(
new
)打开目标页面。
main
new
启用高亮
高亮鼠标指针所在位置的服务器。
第一层节点的最大项数
每页导航树所能显示的第一层的最大项数。
显示筛选框的最少项数
设置达到多少个项(表、视图、程序和事件)时将显示筛选框。
最近使用的表
最近使用的表的最大数量;设为 0 为禁用。
表收藏夹
收藏表的最大数量;设为 0 为禁用。
导航面板宽度
设置为0以折叠导航面板。
导航树
自定义导航树。
节点中最大项数
每页导航树所能显示的最大项数。
分组树中的项
将导航树中的项分组(根据上面 数据库与数据表 页面设置的分隔符分组)。
启用表导航条展开功能
是否允许在导航栏中展开导航树。
在导航树显示表
在导航树是否在数据库下显示数据表节点
在导航树显示视图
在导航树中是否在数据库下显示视图节点
在导航树显示函数
是否显示导航树中数据库下级功能
在导航树显示进程
是否在导航树中显示数据库进程
在导航树显示事件
在导航树中数据库下是否显示事件节点
展开单个数据库
是否自动在导航树中展开单个数据库。
服务器
服务器显示选项。
显示服务器选择
在导航面板顶部显示可选的服务器。
列表显示服务器
直接显示服务器列表而不使用下拉框。
数据库
数据库显示选项。
设置达到多少个数据库时将显示数据库筛选框
数据库树分隔符
将数据库分为不同层级的字符串。
表
表显示选项。
快速访问图标的目标
结构
SQL
搜索
插入
浏览
第二快速访问图标的目标页面
结构
SQL
搜索
插入
浏览
表树分隔符
将表分为不同层级的字符串。
表树最大深度
将文件拖动至此
SQL 上传 (
0
)
x
-
该处必须启用 Javascript!
服务器: 127.0.0.1
数据库: loansystemdb
结构
SQL
搜索
查询
(current)
导出
导入
操作
权限
程序
事件
触发器
追踪
设计器
文本框列
控制台
清除
历史
选项
书签
调试 SQL
按 Ctrl+Enter 键执行查询
按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃
扩展
显示跟踪
隐藏跟踪
数量
用时
书签
刷新
添加
没有书签
添加书签
标签:
目标数据库:
共享和谐书签
确定
选项
恢复默认
总是扩展查询消息
在开始时显示查询历史
显示当前浏览查询
浏览设置,使按Shift+Enter键执行输入和插入新行作为永久设置。
切换到黑色主题
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
查询时间 :
多表查询
通过示例查询
*
id
Message
Email
Bitcoin_Address
*
ID
branchname
Khmername
Englishname
Address
officephone
email
website
status
*
id
cashid
dateclose
amtcash
currency
Username
Branchoffice
*
id
cashid
branchoffice
dateclose
currency
cashcount
number
username
*
ID
Timestamp
UserName
BranchOffice
loanID
InvoiceType
CustomerID
BookingType
DateBooking
Currency
AmtDeposit
AmtWithdraw
AccountID
Note
StaffID
UserNTm
Principlepaid
Interestpaid
OperationPaid
SavingPaid
PenaltyPaid
AmtPaid
No
datepayment
*
ID
TimeStamp
date
Branchoffice
Username
AccountID
CashIn
CashOut
Currency
Branchname
Note
*
CategoryID
Username
CategoryName
CDesption
Category_Pic
CWidth
CLength
CNorth
CSouth
CWest
CEast
CVillage
CCommune
CDistrict
CCity
UserNTm
*
ID
TimeStamp
Username
AccountID
AccountName
AccountType
SubAccountID
Status
*
ID
LoanID
CustomerID
CollateralType
DateAttd
CollateralName
CollateralNo
OwnerName
DateIssued
Price
Status
CollateralPic
*
ID
TimeStamp
Username
Branchoffice
LoanID
CustomerID
DocType
DocNum
DateIssued
OwnerDoc
*
ID
TimeStamp
Username
Branchoffice
LoanID
CustomerID
DocType
DateIssued
DocNum
CollateralType
Issuedby
Size
North
South
East
West
Note
EstimatePrice
Pic
*
ID
Username
Branchoffice
LoanID
CustomerID
CollatType
Brand
Color
PlateNum
BodyNum
MachineNum
YearProduct
latabot
Issuedby
DocType
Note
EstimatePrice
Pic
*
CustomerID
Timestamp
UserName
BranchOffice
KhmerName
LatinName
Sex
Nationality
Dob
IDCard
NoCard
DateIssue
DateExpir
Issued By
NoStreet
NoHouse
Addgroup
Village
Commune
District
City
Job
WorkPlace
Role
CellPhone
HomePhone
WorkPhone
Email
Facebook
CustPhoto
Address_Map
Relationship
Co_KhmerName
Co_LatinName
Co_Sex
Co_Nationality
Co_Dob
Co_IDCard
Co_NoCard
Co_DateIssue
Co_DateExpir
Co_Issued By
Co_NoStreet
Co_NoHouse
Co_Group
Co_Village
Co_Commune
Co_District
Co_City
Co_Job
Co_WorkPlace
Co_Role
Co_CellPhone
Co_HomePhone
Co_WorkPhone
Co_Email
Co_Facebook
Co_CustPhoto
Status
UserNTm
*
ID
CustomerID
BranchOffice
DateAttached
AttachName
OwnerName
AttachNo
AttachPic
*
GuaranteeID
Timestamp
UserName
BranchOffice
Khmername
LatinName
Sex
Nationality
Dob
IDCard
NoCard
DateIssue
DateExpir
Issued By
NoStreet
NoHouse
Addgroup
Village
Commune
District
City
Job
WorkPlace
Role
CellPhone
HomePhone
WorkPhone
Email
Facebook
GuarPhoto
Address_Map
Relationship
Co_KhmerName
Co_LatinName
Co_Sex
Co_Nationality
Co_Dob
Co_IDCard
Co_NoCard
Co_DateIssue
Co_DateExpir
Co_Issued By
Co_NoStreet
Co_NoHouse
Co_Group
Co_Village
Co_Commune
Co_District
Co_City
Co_Job
Co_WorkPlace
Co_Role
Co_CellPhone
Co_HomePhone
Co_WorkPhone
Co_Email
Co_Facebook
Co_GuarPhoto
Status
UserNTm
*
ID
UserName
BranchOffice
InvoiceDate
InvoiceID
CustomerID
ProductID
Quanty
Price
Discount
Tax
Cost
Invoicetype
*
ID
UserName
BranchOffice
GLID
DateGL
Transection_Type
Currency
AccountID
Debit
Credit
Note
CashID
UserNTm
*
GLID
TimeStamp
Username
BranchOffice
UserNTm
*
loanID
TimeStamp
UserName
BranchOffice
CustomerID
LoanType
LoanCycle
Currency
Loansize
InterestRate
Term
TimePayment
PaymentType
DateDisbusement
DateCollect
DateClose
StaffID
DepositRequire
AdminFee
OtherFee
OperationFee
Saving
GuaranteeID
RalationShip
LoanPurpose
LoanStatus
DateWriteOff
ComisionCo
ComisionID
ComisionAgent
Amtfirstday
UserNTm
*
ProductID
UserName
ProductName
ProductType
CategoryID
PDesption
Unit
Cost
Price
tax
PWidth
PLength
PNorth
PSouth
PWest
PEast
PVillage
PCommune
PDistrict
PCity
Status
Product_Pic
UserNTm
*
ID
InvoiceID
CustomerID
DatePay
AmtPay
Percentage
*
SavingID
Timestamp
UserName
BranchOffice
CustomerID
SavingType
Cycle
Currency
SavingAmount
Rate
Term
TimeSaving
Note
DateSaving
DateClose
AdminFee
StaffID
ComisionCo
ComisionID
ComisionAgent
UserNTm
*
ID
savingID
customerid
No
Bbprint
principle
interest
amtpay
endingbalance
datepayment
*
ID
LoanID
CustomerID
No
DatePayment
NumbDay
BeginnigBalance
Principle
Interest
Operation
Saving
AmtPayment
LoanOutstanding
Status
*
StaffID
TimeStamp
UserName
StaffName
Phone
BranchOffice
Type
Status
Photo
UserNTm
*
InvoiceID
TimeStamp
UserName
BranchOffice
InvoiceDate
CustomerID
AmtPay
Currency
Exchange
Ref_PO
StaffID
ComisionerID
StaffFee
ComisionerFee
DatePay
UserNTm
*
UserID
TimeStamp
Inputer
Username
Password
Role
Status
User_Photo
LoginStatus
TimeIn
TimeOut
*
ID
Role
Description
Setting
User
ChartAcct
Journal
SalesStaff
Customer
Loan
Saving
Authorise
CashReciev
RepCust
Loanlate
RepColl
LoanDeposit
RepPmt
RepDis
RepStaff
LoanClosed
RepCollateral
Loansummarise
RepCashInOut
RepProfit
RepBalShet
RepCashVerify
选择表
readme
tb_branchoffice
tb_cashclose
tb_cashcount
tb_cashrecieve
tb_cashtransfer
tb_category
tb_chartaccount
tb_collateral
tb_collateraldocument
tb_collateralestate
tb_collateralvichel
tb_customer
tb_customerattach
tb_guarantee
tb_invoicedetail
tb_journalentry
tb_journalid
tb_loanrequest
tb_product
tb_repaymentterm
tb_saving
tb_savingschedule
tb_schedule
tb_staff
tb_uniqueinvoice
tb_user
tb_usersetting
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
readme
tb_branchoffice
tb_cashclose
tb_cashcount
tb_cashrecieve
tb_cashtransfer
tb_category
tb_chartaccount
tb_collateral
tb_collateraldocument
tb_collateralestate
tb_collateralvichel
tb_customer
tb_customerattach
tb_guarantee
tb_invoicedetail
tb_journalentry
tb_journalid
tb_loanrequest
tb_product
tb_repaymentterm
tb_saving
tb_savingschedule
tb_schedule
tb_staff
tb_uniqueinvoice
tb_user
tb_usersetting
.
选择字段
X
选择表
readme
tb_branchoffice
tb_cashclose
tb_cashcount
tb_cashrecieve
tb_cashtransfer
tb_category
tb_chartaccount
tb_collateral
tb_collateraldocument
tb_collateralestate
tb_collateralvichel
tb_customer
tb_customerattach
tb_guarantee
tb_invoicedetail
tb_journalentry
tb_journalid
tb_loanrequest
tb_product
tb_repaymentterm
tb_saving
tb_savingschedule
tb_schedule
tb_staff
tb_uniqueinvoice
tb_user
tb_usersetting
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
readme
tb_branchoffice
tb_cashclose
tb_cashcount
tb_cashrecieve
tb_cashtransfer
tb_category
tb_chartaccount
tb_collateral
tb_collateraldocument
tb_collateralestate
tb_collateralvichel
tb_customer
tb_customerattach
tb_guarantee
tb_invoicedetail
tb_journalentry
tb_journalid
tb_loanrequest
tb_product
tb_repaymentterm
tb_saving
tb_savingschedule
tb_schedule
tb_staff
tb_uniqueinvoice
tb_user
tb_usersetting
.
选择字段
X
选择表
readme
tb_branchoffice
tb_cashclose
tb_cashcount
tb_cashrecieve
tb_cashtransfer
tb_category
tb_chartaccount
tb_collateral
tb_collateraldocument
tb_collateralestate
tb_collateralvichel
tb_customer
tb_customerattach
tb_guarantee
tb_invoicedetail
tb_journalentry
tb_journalid
tb_loanrequest
tb_product
tb_repaymentterm
tb_saving
tb_savingschedule
tb_schedule
tb_staff
tb_uniqueinvoice
tb_user
tb_usersetting
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
readme
tb_branchoffice
tb_cashclose
tb_cashcount
tb_cashrecieve
tb_cashtransfer
tb_category
tb_chartaccount
tb_collateral
tb_collateraldocument
tb_collateralestate
tb_collateralvichel
tb_customer
tb_customerattach
tb_guarantee
tb_invoicedetail
tb_journalentry
tb_journalid
tb_loanrequest
tb_product
tb_repaymentterm
tb_saving
tb_savingschedule
tb_schedule
tb_staff
tb_uniqueinvoice
tb_user
tb_usersetting
.
选择字段
X
选择表
readme
tb_branchoffice
tb_cashclose
tb_cashcount
tb_cashrecieve
tb_cashtransfer
tb_category
tb_chartaccount
tb_collateral
tb_collateraldocument
tb_collateralestate
tb_collateralvichel
tb_customer
tb_customerattach
tb_guarantee
tb_invoicedetail
tb_journalentry
tb_journalid
tb_loanrequest
tb_product
tb_repaymentterm
tb_saving
tb_savingschedule
tb_schedule
tb_staff
tb_uniqueinvoice
tb_user
tb_usersetting
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
readme
tb_branchoffice
tb_cashclose
tb_cashcount
tb_cashrecieve
tb_cashtransfer
tb_category
tb_chartaccount
tb_collateral
tb_collateraldocument
tb_collateralestate
tb_collateralvichel
tb_customer
tb_customerattach
tb_guarantee
tb_invoicedetail
tb_journalentry
tb_journalid
tb_loanrequest
tb_product
tb_repaymentterm
tb_saving
tb_savingschedule
tb_schedule
tb_staff
tb_uniqueinvoice
tb_user
tb_usersetting
.
选择字段
X