Recent
`information_schema`.`VIEWS`
`mysql`.`proc`
`performance_schema`.`socket_instances`
`performance_schema`.`users`
`performance_schema`.`setup_instruments`
`performance_schema`.`setup_objects`
`performance_schema`.`socket_summary_by_instance`
`information_schema`.`SQL_FUNCTIONS`
`performance_schema`.`host_cache`
`information_schema`.`SCHEMATA`
Favorites
There are no favorite tables.
New
family_guard
information_schema
mysql
one
performance_schema
phpmyadmin
social
social_app
social_nexus
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: social_app
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
admin_id
action
target_type
target_id
details
ip_address
created_at
*
id
ad_type
image_path
html_code
caption
link_url
position
video_position
target_creator_id
target_post_id
created_by_user_id
is_active
clicks_count
created_at
*
id
user_id
target_type
target_id
title
budget
price_per_1000
impressions_target
impressions_delivered
clicks_count
duration_days
target_countries
target_devices
payment_method
payment_sender
payment_ref
payment_screenshot
status
admin_reason
reviewed_by
reviewed_at
submit_count
starts_at
ends_at
created_at
updated_at
ad_kind
description
link_url
creative_path
whatsapp
chat_enabled
cta_text
scan_note
*
id
ad_id
event_type
user_id
ip_address
device_type
creator_id
post_id
is_suspicious
created_at
*
ad_id
visitor_key
impressions
window_start
*
id
user_id
post_id
created_at
*
id
room_id
user_id
status
invited_at
joined_at
left_at
last_ping
*
id
room_id
rater_id
rated_user_id
rating
created_at
*
id
host_id
call_type
status
created_at
ended_at
*
id
room_id
from_user
to_user
signal_type
payload
created_at
*
id
caller_id
callee_id
call_type
status
started_at
ended_at
*
id
call_id
sender_id
signal_type
payload
created_at
*
id
campaign_id
admin_id
action
reason
created_at
*
campaign_id
stat_date
country
device
impressions
clicks
*
id
name
emoji
created_at
*
id
post_id
user_id
content
created_at
parent_id
edited_at
*
user_id
h
created_at
*
id
user_id
other_id
archived_at
*
user_low
user_high
version
*
id
user_id
post_id
ad_event_id
amount
reason
created_at
*
id
severity
message
file_path
line_number
trace
request_url
user_id
is_resolved
created_at
*
id
user_id
friend_id
status
created_at
*
id
owner_id
friend_id
category
*
user_id
other_id
created_at
*
id
tag
uses_count
last_used_at
*
id
post_id
user_id
reaction_type
created_at
*
id
stream_id
user_id
body
created_at
*
id
user_id
title
description
category
audience
stream_key
path_name
status
status_note
sexual
checks_done
viewers
peak_viewers
scheduled_at
started_at
ended_at
last_check_at
created_at
*
id
identifier
success
created_at
*
id
sender_id
receiver_id
content
attachment_path
attachment_type
is_read
created_at
deleted_at
shared_post_id
call_room_id
call_type
call_outcome
call_duration
*
id
message_id
user_id
emoji
*
id
post_id
upload_url
user_id
engine
sexual
violence
text_score
verdict
reason
frames_json
created_at
*
id
user_id
post_id
status
created_at
*
id
user_id
actor_id
type
post_id
extra_text
is_read
created_at
*
user_id
notif_type
enabled
*
id
owner_id
name
category
description
avatar_path
cover_path
avatar_color
is_verified
created_at
*
id
page_id
user_id
created_at
*
id
visitor_key
user_id
ip_address
user_agent
device_type
page_url
page_label
duration_seconds
created_at
*
id
user_id
token_hash
expires_at
used_at
delivery
status
requested_ip
created_at
*
id
code
label
details
holder_name
icon
is_active
sort_order
*
id
post_id
option_text
position
*
id
post_id
option_id
user_id
created_at
*
id
user_id
content
media_type
media_url
visibility
views_count
shares_count
ad_placement
video_title
category
tags
thumbnail_path
ad_enabled
ad_positions
is_short
deletion_status
created_at
is_pinned
edited_at
page_id
moderation_status
moderation_score
moderation_note
max_quality
allow_download
audience
*
id
post_id
user_id
cost
impressions_target
impressions_delivered
status
created_at
*
id
user_id
content
media_type
media_url
visibility
extra_json
status
scheduled_at
created_at
updated_at
*
id
post_id
old_content
old_video_title
old_category
old_tags
old_thumbnail
edited_at
*
post_id
hashtag_id
created_at
*
id
profile_id
visitor_id
visit_date
*
bucket_key
hits
window_start
*
id
reporter_id
post_id
reason
details
screenshot_path
status
created_at
*
setting_key
setting_value
*
id
ticket_id
sender_id
is_admin_reply
content
attachment_path
attachment_type
created_at
*
id
user_id
subject
status
created_at
*
user_id
to_user_id
updated_at
*
media_url
user_id
frames_count
skin_score
ai_score
note
created_at
gore_score
source
engine
details
*
id
name
contact
password
age
avatar_color
cover_gradient
cover_image_path
avatar_path
bio
privacy_default
message_privacy
monetization_enabled
default_ad_enabled
preview_sound_enabled
is_admin
created_at
is_verified
is_disabled
suspended_until
social_links
show_profile_visits
google_id
call_privacy
vp_duration_limit
vp_quota_mb
is_hidden
hidden_at
phone_hash
email_hash
country
city
*
id
blocker_id
blocked_id
created_at
*
id
user_id
report_id
post_id
reason
consumed
created_at
source
note
created_by
*
id
url
user_id
folder
size
created_at
*
id
post_id
language
language_label
vtt_path
created_at
*
post_id
view_date
views
*
id
upload_id
user_id
level
message
created_at
*
id
post_id
quality
file_path
file_size
source
created_at
*
id
user_id
post_id
fingerprint
original_name
ext
size
chunk_size
chunks_total
status
progress
stage
attempts
priority
error
original_url
media_url
thumb_url
duration
width
height
vcodec
bitrate_kbps
result_json
audience
locked_at
finished_at
created_at
updated_at
kind
scan_done
*
id
user_id
post_id
category
watch_seconds
updated_at
*
id
user_id
amount
method
account_details
status
admin_note
created_at
processed_at
select table
admin_activity_log
ads
ad_campaigns
ad_events
ad_impressions
bookmarks
call_participants
call_ratings
call_rooms
call_room_signals
call_sessions
call_signals
campaign_reviews
campaign_stats_daily
categories
comments
contact_hashes
conversation_archives
conversation_versions
earnings_ledger
error_logs
friends
friend_categories
friend_dismissed
hashtags
likes
live_messages
live_streams
login_attempts
messages
message_reactions
moderation_results
monetization_requests
notifications
notification_prefs
pages
page_followers
page_views
password_resets
payment_methods
poll_options
poll_votes
posts
post_boosts
post_drafts
post_edits
post_hashtags
profile_visits
rate_limits
reports
settings
support_messages
support_tickets
typing_status
upload_scans
users
user_blocks
user_strikes
user_uploads
video_captions
video_daily_views
video_events
video_renditions
video_uploads
video_watch_history
withdrawal_requests
.
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
admin_activity_log
ads
ad_campaigns
ad_events
ad_impressions
bookmarks
call_participants
call_ratings
call_rooms
call_room_signals
call_sessions
call_signals
campaign_reviews
campaign_stats_daily
categories
comments
contact_hashes
conversation_archives
conversation_versions
earnings_ledger
error_logs
friends
friend_categories
friend_dismissed
hashtags
likes
live_messages
live_streams
login_attempts
messages
message_reactions
moderation_results
monetization_requests
notifications
notification_prefs
pages
page_followers
page_views
password_resets
payment_methods
poll_options
poll_votes
posts
post_boosts
post_drafts
post_edits
post_hashtags
profile_visits
rate_limits
reports
settings
support_messages
support_tickets
typing_status
upload_scans
users
user_blocks
user_strikes
user_uploads
video_captions
video_daily_views
video_events
video_renditions
video_uploads
video_watch_history
withdrawal_requests
.
select column
select table
admin_activity_log
ads
ad_campaigns
ad_events
ad_impressions
bookmarks
call_participants
call_ratings
call_rooms
call_room_signals
call_sessions
call_signals
campaign_reviews
campaign_stats_daily
categories
comments
contact_hashes
conversation_archives
conversation_versions
earnings_ledger
error_logs
friends
friend_categories
friend_dismissed
hashtags
likes
live_messages
live_streams
login_attempts
messages
message_reactions
moderation_results
monetization_requests
notifications
notification_prefs
pages
page_followers
page_views
password_resets
payment_methods
poll_options
poll_votes
posts
post_boosts
post_drafts
post_edits
post_hashtags
profile_visits
rate_limits
reports
settings
support_messages
support_tickets
typing_status
upload_scans
users
user_blocks
user_strikes
user_uploads
video_captions
video_daily_views
video_events
video_renditions
video_uploads
video_watch_history
withdrawal_requests
.
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
admin_activity_log
ads
ad_campaigns
ad_events
ad_impressions
bookmarks
call_participants
call_ratings
call_rooms
call_room_signals
call_sessions
call_signals
campaign_reviews
campaign_stats_daily
categories
comments
contact_hashes
conversation_archives
conversation_versions
earnings_ledger
error_logs
friends
friend_categories
friend_dismissed
hashtags
likes
live_messages
live_streams
login_attempts
messages
message_reactions
moderation_results
monetization_requests
notifications
notification_prefs
pages
page_followers
page_views
password_resets
payment_methods
poll_options
poll_votes
posts
post_boosts
post_drafts
post_edits
post_hashtags
profile_visits
rate_limits
reports
settings
support_messages
support_tickets
typing_status
upload_scans
users
user_blocks
user_strikes
user_uploads
video_captions
video_daily_views
video_events
video_renditions
video_uploads
video_watch_history
withdrawal_requests
.
select column
select table
admin_activity_log
ads
ad_campaigns
ad_events
ad_impressions
bookmarks
call_participants
call_ratings
call_rooms
call_room_signals
call_sessions
call_signals
campaign_reviews
campaign_stats_daily
categories
comments
contact_hashes
conversation_archives
conversation_versions
earnings_ledger
error_logs
friends
friend_categories
friend_dismissed
hashtags
likes
live_messages
live_streams
login_attempts
messages
message_reactions
moderation_results
monetization_requests
notifications
notification_prefs
pages
page_followers
page_views
password_resets
payment_methods
poll_options
poll_votes
posts
post_boosts
post_drafts
post_edits
post_hashtags
profile_visits
rate_limits
reports
settings
support_messages
support_tickets
typing_status
upload_scans
users
user_blocks
user_strikes
user_uploads
video_captions
video_daily_views
video_events
video_renditions
video_uploads
video_watch_history
withdrawal_requests
.
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
admin_activity_log
ads
ad_campaigns
ad_events
ad_impressions
bookmarks
call_participants
call_ratings
call_rooms
call_room_signals
call_sessions
call_signals
campaign_reviews
campaign_stats_daily
categories
comments
contact_hashes
conversation_archives
conversation_versions
earnings_ledger
error_logs
friends
friend_categories
friend_dismissed
hashtags
likes
live_messages
live_streams
login_attempts
messages
message_reactions
moderation_results
monetization_requests
notifications
notification_prefs
pages
page_followers
page_views
password_resets
payment_methods
poll_options
poll_votes
posts
post_boosts
post_drafts
post_edits
post_hashtags
profile_visits
rate_limits
reports
settings
support_messages
support_tickets
typing_status
upload_scans
users
user_blocks
user_strikes
user_uploads
video_captions
video_daily_views
video_events
video_renditions
video_uploads
video_watch_history
withdrawal_requests
.
select column
select table
admin_activity_log
ads
ad_campaigns
ad_events
ad_impressions
bookmarks
call_participants
call_ratings
call_rooms
call_room_signals
call_sessions
call_signals
campaign_reviews
campaign_stats_daily
categories
comments
contact_hashes
conversation_archives
conversation_versions
earnings_ledger
error_logs
friends
friend_categories
friend_dismissed
hashtags
likes
live_messages
live_streams
login_attempts
messages
message_reactions
moderation_results
monetization_requests
notifications
notification_prefs
pages
page_followers
page_views
password_resets
payment_methods
poll_options
poll_votes
posts
post_boosts
post_drafts
post_edits
post_hashtags
profile_visits
rate_limits
reports
settings
support_messages
support_tickets
typing_status
upload_scans
users
user_blocks
user_strikes
user_uploads
video_captions
video_daily_views
video_events
video_renditions
video_uploads
video_watch_history
withdrawal_requests
.
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
admin_activity_log
ads
ad_campaigns
ad_events
ad_impressions
bookmarks
call_participants
call_ratings
call_rooms
call_room_signals
call_sessions
call_signals
campaign_reviews
campaign_stats_daily
categories
comments
contact_hashes
conversation_archives
conversation_versions
earnings_ledger
error_logs
friends
friend_categories
friend_dismissed
hashtags
likes
live_messages
live_streams
login_attempts
messages
message_reactions
moderation_results
monetization_requests
notifications
notification_prefs
pages
page_followers
page_views
password_resets
payment_methods
poll_options
poll_votes
posts
post_boosts
post_drafts
post_edits
post_hashtags
profile_visits
rate_limits
reports
settings
support_messages
support_tickets
typing_status
upload_scans
users
user_blocks
user_strikes
user_uploads
video_captions
video_daily_views
video_events
video_renditions
video_uploads
video_watch_history
withdrawal_requests
.
select column