Recent
`information_schema`.`PROFILING`
`sharebot_db`.`admin_users`
`information_schema`.`STATISTICS`
`information_schema`.`CLIENT_STATISTICS`
`information_schema`.`SQL_FUNCTIONS`
`performance_schema`.`host_cache`
`performance_schema`.`setup_consumers`
`performance_schema`.`setup_timers`
`performance_schema`.`setup_actors`
`performance_schema`.`socket_summary_by_instance`
Favorites
There are no favorite tables.
New
freeplay_db
growlog_db
information_schema
lotto_db
mysql
performance_schema
phpmyadmin
podshop_db
sharebot_db
test
weedlhs_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
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: freeplay_db
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
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
Bookmark
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
id
name
identifier
charidentifier
money
gold
items
invspace
*
license
name
time
reason
*
license
name
time
reason
*
id
identifier
charid
name
boat
mods
inv
shared
coal
location
*
identifier
steamname
charidentifier
group
money
gold
rol
xp
healthouter
healthinner
staminaouter
staminainner
hours
LastLogin
inventory
slots
job
joblabel
meta
firstname
lastname
character_desc
gender
age
nickname
skinPlayer
compPlayer
compTints
jobgrade
coords
status
isdead
skills
walk
gunsmith
ammo
discordid
lastjoined
afk_points
multijobs
*
character_id
inventory_type
item_crafted_id
item_name
amount
created_at
degradation
percentage
*
id
identifier
charid
hash
drawable
albedo
normal
material
palette
tint0
tint1
tint2
*
id
items
type
maxprice
price
maxcount
count
discountnum
*
charid
data
*
identifier
charidentifier
location
*
identifier
charidentifier
complements
*
id
name
identifier
charidentifier
key
*
item
label
limit
can_remove
type
usable
id
groupId
metadata
desc
degradation
weight
*
id
character_id
item_id
item_name
updated_at
metadata
*
id
description
*
id
name
grade
label
family
*
id
job_id
character_id
date_created
date_last_active
*
identifier
charid
category
state
*
id
identifier
charid
name
outfit
*
id
identifier
char_id
first_name
last_name
address_number
created_at
*
id
mail_id
item_name
item_count
item_metadata
claimed
*
id
identifier
contact_name
contact_address
created_at
*
id
sender_identifier
sender_name
sender_address
recipient_identifier
recipient_name
recipient_address
subject
content
image_url
location_x
location_y
location_z
has_items
items_claimed
is_system_mail
mail_type
is_read
created_at
*
id
identifier
current_day
current_streak
last_login_date
claimed_days
missed_days
recovery_credits
last_recovery_date
weekend_online_time
online_time_today
current_tier
last_online_date
total_online_time
created_at
updated_at
*
id
identifier
charidentifier
storage_id
slots
is_placed
coords_x
coords_y
coords_z
keys_given
created_at
item_name
*
id
identifier
charidentifier
name
ammo
components
dirtlevel
mudlevel
conditionlevel
rustlevel
used
used2
dropped
comps
label
curr_inv
serial_number
custom_label
custom_desc
*
id
identifier
day_count
first_claimed
last_claimed
claimed_dates
*
id
sender_id
sender_firstname
sender_lastname
receiver_id
receiver_firstname
receiver_lastname
message
opened
received_at
*
id
identifier
charidentifier
title
comps
compTints
*
identifier
quest_list
*
id
identifier
charid
data
*
id
name
identifier
charidentifier
key
*
id
identifier
charid
selected
injured
gender
model
name
equipments
xp
price
specialcoat
age
*
id
identifier
charid
horseid
Saddle
Saddlebags
Blankets
Stirrup
Horns
Bedrolls
Bridles
Tails
Manes
Shoes
Holster
Lantern
Masks
Mustaches
*
id
identifier
charid
model
name
equipment
price
destroyed
*
offense
date
charge
description
jailtime
identifier
dob
officer
fine
idnr
bounty
firstname
lastname
city
jail
u_charid
penal
*
idnr
notes
*
identifier
u_charid
aliases
recordid
weight
eyecolor
haircolor
firstname
lastname
dob
sex
height
city
regdate
image
isfake
imigration
*
id
identifier
charidentifier
name
modelname
type
status
xp
injured
gear
isDefault
inventory
*
id
name
coordinate
owner
stock
products
request
balance
*
identifier
group
warnings
banned
banneduntil
char
max_jobs
*
id
identifier
charid
selected
model
name
items
*
id
name
label
icon
sort_order
*
id
steam_id
charidentifier
product_id
product_name
quantity
total_price
payment_type
status
delivered_at
created_at
*
id
name
description
item_name
item_amount
price_gold
price_money
image
category
active
stock
created_at
*
id
charidentifier
serial_id
planttype
coords
status
growLeft
updated_at
*
id
identifier
status
firstconnection
discordid
select table
bank_users
bans
ban_mic
boates
characters
character_inventories
clothes_bought
dt_economy
fx_idcard
herbalists
horse_complements
housing
items
items_crafted
item_group
jobs
job_assignments
kd_clothes_state
kd_outfits
kenny_mail_addresses
kenny_mail_attachments
kenny_mail_contacts
kenny_mail_messages
kenny_rewards
kenny_storage_boxes
loadout
login_rewards
mailbox_mails
outfits
quest_data
ricx_graverobbery
rooms
sirevlc_horses
sirevlc_horses_equipment
sirevlc_wagons
ss_archives
ss_archivesnotes
ss_identitycard
stables
stores
users
wagons
webshop_categories
webshop_orders
webshop_products
weedplants
whitelist
.
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
bank_users
bans
ban_mic
boates
characters
character_inventories
clothes_bought
dt_economy
fx_idcard
herbalists
horse_complements
housing
items
items_crafted
item_group
jobs
job_assignments
kd_clothes_state
kd_outfits
kenny_mail_addresses
kenny_mail_attachments
kenny_mail_contacts
kenny_mail_messages
kenny_rewards
kenny_storage_boxes
loadout
login_rewards
mailbox_mails
outfits
quest_data
ricx_graverobbery
rooms
sirevlc_horses
sirevlc_horses_equipment
sirevlc_wagons
ss_archives
ss_archivesnotes
ss_identitycard
stables
stores
users
wagons
webshop_categories
webshop_orders
webshop_products
weedplants
whitelist
.
select column
select table
bank_users
bans
ban_mic
boates
characters
character_inventories
clothes_bought
dt_economy
fx_idcard
herbalists
horse_complements
housing
items
items_crafted
item_group
jobs
job_assignments
kd_clothes_state
kd_outfits
kenny_mail_addresses
kenny_mail_attachments
kenny_mail_contacts
kenny_mail_messages
kenny_rewards
kenny_storage_boxes
loadout
login_rewards
mailbox_mails
outfits
quest_data
ricx_graverobbery
rooms
sirevlc_horses
sirevlc_horses_equipment
sirevlc_wagons
ss_archives
ss_archivesnotes
ss_identitycard
stables
stores
users
wagons
webshop_categories
webshop_orders
webshop_products
weedplants
whitelist
.
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
bank_users
bans
ban_mic
boates
characters
character_inventories
clothes_bought
dt_economy
fx_idcard
herbalists
horse_complements
housing
items
items_crafted
item_group
jobs
job_assignments
kd_clothes_state
kd_outfits
kenny_mail_addresses
kenny_mail_attachments
kenny_mail_contacts
kenny_mail_messages
kenny_rewards
kenny_storage_boxes
loadout
login_rewards
mailbox_mails
outfits
quest_data
ricx_graverobbery
rooms
sirevlc_horses
sirevlc_horses_equipment
sirevlc_wagons
ss_archives
ss_archivesnotes
ss_identitycard
stables
stores
users
wagons
webshop_categories
webshop_orders
webshop_products
weedplants
whitelist
.
select column
select table
bank_users
bans
ban_mic
boates
characters
character_inventories
clothes_bought
dt_economy
fx_idcard
herbalists
horse_complements
housing
items
items_crafted
item_group
jobs
job_assignments
kd_clothes_state
kd_outfits
kenny_mail_addresses
kenny_mail_attachments
kenny_mail_contacts
kenny_mail_messages
kenny_rewards
kenny_storage_boxes
loadout
login_rewards
mailbox_mails
outfits
quest_data
ricx_graverobbery
rooms
sirevlc_horses
sirevlc_horses_equipment
sirevlc_wagons
ss_archives
ss_archivesnotes
ss_identitycard
stables
stores
users
wagons
webshop_categories
webshop_orders
webshop_products
weedplants
whitelist
.
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
bank_users
bans
ban_mic
boates
characters
character_inventories
clothes_bought
dt_economy
fx_idcard
herbalists
horse_complements
housing
items
items_crafted
item_group
jobs
job_assignments
kd_clothes_state
kd_outfits
kenny_mail_addresses
kenny_mail_attachments
kenny_mail_contacts
kenny_mail_messages
kenny_rewards
kenny_storage_boxes
loadout
login_rewards
mailbox_mails
outfits
quest_data
ricx_graverobbery
rooms
sirevlc_horses
sirevlc_horses_equipment
sirevlc_wagons
ss_archives
ss_archivesnotes
ss_identitycard
stables
stores
users
wagons
webshop_categories
webshop_orders
webshop_products
weedplants
whitelist
.
select column
select table
bank_users
bans
ban_mic
boates
characters
character_inventories
clothes_bought
dt_economy
fx_idcard
herbalists
horse_complements
housing
items
items_crafted
item_group
jobs
job_assignments
kd_clothes_state
kd_outfits
kenny_mail_addresses
kenny_mail_attachments
kenny_mail_contacts
kenny_mail_messages
kenny_rewards
kenny_storage_boxes
loadout
login_rewards
mailbox_mails
outfits
quest_data
ricx_graverobbery
rooms
sirevlc_horses
sirevlc_horses_equipment
sirevlc_wagons
ss_archives
ss_archivesnotes
ss_identitycard
stables
stores
users
wagons
webshop_categories
webshop_orders
webshop_products
weedplants
whitelist
.
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
bank_users
bans
ban_mic
boates
characters
character_inventories
clothes_bought
dt_economy
fx_idcard
herbalists
horse_complements
housing
items
items_crafted
item_group
jobs
job_assignments
kd_clothes_state
kd_outfits
kenny_mail_addresses
kenny_mail_attachments
kenny_mail_contacts
kenny_mail_messages
kenny_rewards
kenny_storage_boxes
loadout
login_rewards
mailbox_mails
outfits
quest_data
ricx_graverobbery
rooms
sirevlc_horses
sirevlc_horses_equipment
sirevlc_wagons
ss_archives
ss_archivesnotes
ss_identitycard
stables
stores
users
wagons
webshop_categories
webshop_orders
webshop_products
weedplants
whitelist
.
select column