Recent
`phpmyadmin`.`pma__table_coords`
`enchanted`.`phone_twitter_notifications`
`enchanted`.`mdt_creative_warnings`
`enchanted`.`painel_creative_transactions`
`enchanted`.`mdt_creative_board`
`enchanted`.`phone_maps_locations`
`enchanted`.`phone_photos`
`enchanted`.`phone_instagram_posts`
`enchanted`.`mdt_creative_medals_users`
`enchanted`.`esrp_phone_emergency_calls`
Favorites
There are no favorite tables.
New
centraldear
coregg-sp
enchanted
information_schema
lossantos
mysql
performance_schema
phpmyadmin
test
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: lossantos
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
type
label
citizenid
*
record_id
citizenid
business
businessid
gangid
amount
account_type
*
record_id
citizenid
cardNumber
cardPin
cardActive
cardLocked
cardType
*
record_id
citizenid
account
business
businessid
gangid
deposited
withdraw
balance
date
type
*
id
name
license
discord
ip
reason
expire
bannedby
*
id
owner
songname
author
imageurl
songurl
*
cid
cameradata
camID
*
plate
mileage
*
identifier
data
stress
*
id
citizenid
skill_name
value1
value2
value3
*
crypto
worth
history
*
id
citizenid
title
message
date
*
id
name
coords
time
createdby
*
id
time
text
*
id
name
data
*
location
owned
owner
fuel
fuelprice
balance
label
*
id
cooldown
timestamp
*
id
plate
items
*
id
name
label
coords
owned
price
tier
garage
*
id
building
stage
sort
gender
food
health
progress
coords
plantid
*
id
name
checkpoints
records
creator
distance
raceid
*
id
type
label
*
id
job_name
amount
type
*
id
name
normal
auction
*
id
identifier
totalsold
earnings
*
id
author
title
plate
owner
individual
detail
tags
gallery
officersinvolved
time
jobtype
*
id
title
desc
author
time
jobtype
*
id
user_id
firstname
lastname
clock_in_time
clock_out_time
total_time
*
id
cid
linkedincident
warrant
guilty
processed
associated
charges
fine
sentence
recfine
recsentence
time
*
id
cid
information
tags
gallery
jobtype
pfp
fingerprint
*
id
vehicleid
linkedreport
fee
time
*
id
author
title
details
tags
officersinvolved
civsinvolved
evidence
time
jobtype
*
id
text
time
jobtype
*
id
author
title
type
details
tags
officersinvolved
civsinvolved
gallery
time
jobtype
*
id
plate
information
stolen
code5
image
points
*
id
serial
owner
information
weapClass
weapModel
image
*
id
seller
price
description
plate
model
mods
occasionid
*
society
society_name
value
iban
is_withdrawing
*
id
receiver_identifier
receiver_name
sender_identifier
sender_name
date
value
type
*
id
receiver_identifier
receiver_name
author_identifier
author_name
society
society_name
item
invoice_value
status
notes
sent_date
limit_pay_date
fees_amount
paid_date
*
admin_identifier
responded_reports
*
id
dealershipId
data
*
id
dealershipId
data
*
id
room_code
room_name
room_owner_id
room_owner_name
room_members
room_pin
unpaid_balance
is_pinned
created
*
id
room_id
member_id
member_name
message
is_pinned
created
*
citizenid
image
date
*
id
citizenid
amount
society
sender
sendercitizenid
time
*
id
citizenid
number
messages
time
*
id
citizenid
title
text
lastupdate
*
id
citizenid
firstName
lastName
type
message
url
tweetId
date
*
id
citizenid
cid
license
name
money
charinfo
job
gang
position
metadata
inventory
last_updated
dnzv3
dnzv3_active
dnzv3_timeblock
iban
pincode
tattoos
crafting_level
crafting_xp
credits
tasks
tasks_completed
winnings
ownedskills
skillsinfo
frkn_craftxp
frkn_craftlevel
*
id
citizenid
model
skin
active
*
id
citizenid
name
number
*
id
player_id
emote_category
emote_index
emote_type
emote_value
*
id
house
identifier
citizenid
keyholders
decorations
stash
outfit
logout
*
id
jobname
employees
maxEmployee
*
id
citizenid
sender
subject
message
read
mailid
date
button
*
id
citizenid
outfitname
model
skin
outfitId
*
id
license
citizenid
vehicle
hash
mods
plate
fakeplate
garage
fuel
engine
body
state
depotprice
drivingdistance
status
balance
paymentamount
paymentsleft
financetime
nosColour
traveldistance
noslevel
hasnitro
stored
parking
favorite
logs
*
id
senderIdentifier
targetIdentifier
reason
warnId
*
property_id
owner_citizenid
street
region
description
has_access
extra_imgs
furnitures
for_sale
price
shell
apartment
door_data
garage_data
*
id
name
score
*
id
x
y
z
rx
ry
rz
scale
text
font
color
interior
created_at
*
id
stash
items
*
id
plate
items
*
id
type
owner
select table
apartments
bank_accounts
bank_cards
bank_statements
bans
boombox
cameras
carmileages
codem-hud-data
core_skills
crypto
crypto_transactions
dealers
debux_recentpost
ds_blipcreator
fuel_stations
gammy_scrapyard
gloveboxitems
houselocations
house_plants
lapraces
licenses
management_funds
marketplace
marketplace_sellers
mdt_bolos
mdt_bulletin
mdt_clocking
mdt_convictions
mdt_data
mdt_impound
mdt_incidents
mdt_logs
mdt_reports
mdt_vehicleinfo
mdt_weaponinfo
occasion_vehicles
okokbanking_societies
okokbanking_transactions
okokbilling
okokreports
pa_vehicleshop_showroom_vehicles
pa_vehicleshop_stocks
phone_chatrooms
phone_chatroom_messages
phone_gallery
phone_invoices
phone_messages
phone_note
phone_tweets
players
playerskins
player_contacts
player_emotes
player_houses
player_jobs
player_mails
player_outfits
player_vehicles
player_warns
properties
punchmachine
sprays
stashitems
trunkitems
user_licenses
.
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
apartments
bank_accounts
bank_cards
bank_statements
bans
boombox
cameras
carmileages
codem-hud-data
core_skills
crypto
crypto_transactions
dealers
debux_recentpost
ds_blipcreator
fuel_stations
gammy_scrapyard
gloveboxitems
houselocations
house_plants
lapraces
licenses
management_funds
marketplace
marketplace_sellers
mdt_bolos
mdt_bulletin
mdt_clocking
mdt_convictions
mdt_data
mdt_impound
mdt_incidents
mdt_logs
mdt_reports
mdt_vehicleinfo
mdt_weaponinfo
occasion_vehicles
okokbanking_societies
okokbanking_transactions
okokbilling
okokreports
pa_vehicleshop_showroom_vehicles
pa_vehicleshop_stocks
phone_chatrooms
phone_chatroom_messages
phone_gallery
phone_invoices
phone_messages
phone_note
phone_tweets
players
playerskins
player_contacts
player_emotes
player_houses
player_jobs
player_mails
player_outfits
player_vehicles
player_warns
properties
punchmachine
sprays
stashitems
trunkitems
user_licenses
.
select column
select table
apartments
bank_accounts
bank_cards
bank_statements
bans
boombox
cameras
carmileages
codem-hud-data
core_skills
crypto
crypto_transactions
dealers
debux_recentpost
ds_blipcreator
fuel_stations
gammy_scrapyard
gloveboxitems
houselocations
house_plants
lapraces
licenses
management_funds
marketplace
marketplace_sellers
mdt_bolos
mdt_bulletin
mdt_clocking
mdt_convictions
mdt_data
mdt_impound
mdt_incidents
mdt_logs
mdt_reports
mdt_vehicleinfo
mdt_weaponinfo
occasion_vehicles
okokbanking_societies
okokbanking_transactions
okokbilling
okokreports
pa_vehicleshop_showroom_vehicles
pa_vehicleshop_stocks
phone_chatrooms
phone_chatroom_messages
phone_gallery
phone_invoices
phone_messages
phone_note
phone_tweets
players
playerskins
player_contacts
player_emotes
player_houses
player_jobs
player_mails
player_outfits
player_vehicles
player_warns
properties
punchmachine
sprays
stashitems
trunkitems
user_licenses
.
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
apartments
bank_accounts
bank_cards
bank_statements
bans
boombox
cameras
carmileages
codem-hud-data
core_skills
crypto
crypto_transactions
dealers
debux_recentpost
ds_blipcreator
fuel_stations
gammy_scrapyard
gloveboxitems
houselocations
house_plants
lapraces
licenses
management_funds
marketplace
marketplace_sellers
mdt_bolos
mdt_bulletin
mdt_clocking
mdt_convictions
mdt_data
mdt_impound
mdt_incidents
mdt_logs
mdt_reports
mdt_vehicleinfo
mdt_weaponinfo
occasion_vehicles
okokbanking_societies
okokbanking_transactions
okokbilling
okokreports
pa_vehicleshop_showroom_vehicles
pa_vehicleshop_stocks
phone_chatrooms
phone_chatroom_messages
phone_gallery
phone_invoices
phone_messages
phone_note
phone_tweets
players
playerskins
player_contacts
player_emotes
player_houses
player_jobs
player_mails
player_outfits
player_vehicles
player_warns
properties
punchmachine
sprays
stashitems
trunkitems
user_licenses
.
select column
select table
apartments
bank_accounts
bank_cards
bank_statements
bans
boombox
cameras
carmileages
codem-hud-data
core_skills
crypto
crypto_transactions
dealers
debux_recentpost
ds_blipcreator
fuel_stations
gammy_scrapyard
gloveboxitems
houselocations
house_plants
lapraces
licenses
management_funds
marketplace
marketplace_sellers
mdt_bolos
mdt_bulletin
mdt_clocking
mdt_convictions
mdt_data
mdt_impound
mdt_incidents
mdt_logs
mdt_reports
mdt_vehicleinfo
mdt_weaponinfo
occasion_vehicles
okokbanking_societies
okokbanking_transactions
okokbilling
okokreports
pa_vehicleshop_showroom_vehicles
pa_vehicleshop_stocks
phone_chatrooms
phone_chatroom_messages
phone_gallery
phone_invoices
phone_messages
phone_note
phone_tweets
players
playerskins
player_contacts
player_emotes
player_houses
player_jobs
player_mails
player_outfits
player_vehicles
player_warns
properties
punchmachine
sprays
stashitems
trunkitems
user_licenses
.
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
apartments
bank_accounts
bank_cards
bank_statements
bans
boombox
cameras
carmileages
codem-hud-data
core_skills
crypto
crypto_transactions
dealers
debux_recentpost
ds_blipcreator
fuel_stations
gammy_scrapyard
gloveboxitems
houselocations
house_plants
lapraces
licenses
management_funds
marketplace
marketplace_sellers
mdt_bolos
mdt_bulletin
mdt_clocking
mdt_convictions
mdt_data
mdt_impound
mdt_incidents
mdt_logs
mdt_reports
mdt_vehicleinfo
mdt_weaponinfo
occasion_vehicles
okokbanking_societies
okokbanking_transactions
okokbilling
okokreports
pa_vehicleshop_showroom_vehicles
pa_vehicleshop_stocks
phone_chatrooms
phone_chatroom_messages
phone_gallery
phone_invoices
phone_messages
phone_note
phone_tweets
players
playerskins
player_contacts
player_emotes
player_houses
player_jobs
player_mails
player_outfits
player_vehicles
player_warns
properties
punchmachine
sprays
stashitems
trunkitems
user_licenses
.
select column
select table
apartments
bank_accounts
bank_cards
bank_statements
bans
boombox
cameras
carmileages
codem-hud-data
core_skills
crypto
crypto_transactions
dealers
debux_recentpost
ds_blipcreator
fuel_stations
gammy_scrapyard
gloveboxitems
houselocations
house_plants
lapraces
licenses
management_funds
marketplace
marketplace_sellers
mdt_bolos
mdt_bulletin
mdt_clocking
mdt_convictions
mdt_data
mdt_impound
mdt_incidents
mdt_logs
mdt_reports
mdt_vehicleinfo
mdt_weaponinfo
occasion_vehicles
okokbanking_societies
okokbanking_transactions
okokbilling
okokreports
pa_vehicleshop_showroom_vehicles
pa_vehicleshop_stocks
phone_chatrooms
phone_chatroom_messages
phone_gallery
phone_invoices
phone_messages
phone_note
phone_tweets
players
playerskins
player_contacts
player_emotes
player_houses
player_jobs
player_mails
player_outfits
player_vehicles
player_warns
properties
punchmachine
sprays
stashitems
trunkitems
user_licenses
.
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
apartments
bank_accounts
bank_cards
bank_statements
bans
boombox
cameras
carmileages
codem-hud-data
core_skills
crypto
crypto_transactions
dealers
debux_recentpost
ds_blipcreator
fuel_stations
gammy_scrapyard
gloveboxitems
houselocations
house_plants
lapraces
licenses
management_funds
marketplace
marketplace_sellers
mdt_bolos
mdt_bulletin
mdt_clocking
mdt_convictions
mdt_data
mdt_impound
mdt_incidents
mdt_logs
mdt_reports
mdt_vehicleinfo
mdt_weaponinfo
occasion_vehicles
okokbanking_societies
okokbanking_transactions
okokbilling
okokreports
pa_vehicleshop_showroom_vehicles
pa_vehicleshop_stocks
phone_chatrooms
phone_chatroom_messages
phone_gallery
phone_invoices
phone_messages
phone_note
phone_tweets
players
playerskins
player_contacts
player_emotes
player_houses
player_jobs
player_mails
player_outfits
player_vehicles
player_warns
properties
punchmachine
sprays
stashitems
trunkitems
user_licenses
.
select column