Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `phone_messages` ORDER BY `id` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id Descending Ascending 1 phone number messages created unreaded
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 457
457 918693544 mc2 [{"message":"{\"x\":-536.73388671875,\"y\":253.396... 2024-10-05 21:14:07 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 456
456 ChitChat 912730373 [{"created":"2024-10-03 22:32:59","owner":"ChitCha... 2024-10-03 22:33:06 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 455
455 Tweedle 912730373 [{"created":"2024-10-03 22:31:14","owner":"Tweedle... 2024-10-03 22:31:20 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 454
454 Instagraph 919506214 [{"owner":"Instagraph","created":"2024-10-03 00:43... 2024-10-03 00:43:27 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 453
453 ChitChat 919506214 [{"owner":"ChitChat","read":0,"created":"2024-10-0... 2024-10-03 00:42:57 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 452
452 918693544 ambulance [{"type":"location","message":"{\"x\":4978.3730468... 2024-10-01 14:40:55 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 451
451 ChitChat 918693544 [{"type":"message","message":"        <a class='bl... 2024-10-01 14:38:39 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 449
449 TickTock 918693544 [{"read":0,"owner":"TickTock","type":"message","cr... 2024-09-11 12:40:05 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 448
448 Instagraph 918693544 [{"read":0,"owner":"Instagraph","type":"message","... 2024-09-11 12:18:15 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 447
447 914075533 918016769 [{"created":"2024-08-06 20:06:16","message":"Boas"... 2024-08-06 20:09:03 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 446
446 Marketplace 917379872 [{"read":0,"created":"2024-08-03 19:28:30","owner"... 2024-08-03 19:28:37 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 445
445 915635901 917569882 [{"type":"message","created":"2024-08-03 17:37:35"... 2024-08-03 17:38:54 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 444
444 916827360 mechanic [{"type":"message","message":"tas pela oficina","c... 2024-08-02 20:17:26 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 443
443 915635901 919500181 [{"message":"o gajo ta a ficar impaciente","read":... 2024-08-01 01:25:54 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 442
442 917668584 ambulance [{"message":"{\"x\":1097.833740234375,\"y\":357.58... 2024-07-30 19:04:15 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 441
441 911433979 ambulance [{"read":1,"created":"2024-07-30 01:46:51","type":... 2024-07-30 01:46:51 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 440
440 919239446 912099525 [{"read":0,"message":"quanto vale 500 sementes?","... 2024-07-29 23:20:10 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 439
439 912768370 914075533 [{"created":"2024-07-26 18:13:38","message":"se ai... 2024-08-06 20:10:14 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 438
438 Instagraph 914092517 [{"message":"        <a class='blue_text cursor-po... 2024-07-23 23:00:51 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 437
437 919239446 912768370 [{"read":0,"message":"bom dia","created":"2024-07-... 2024-07-24 09:09:28 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 436
436 914075533 919500181 [{"owner":"914075533","type":"message","read":0,"c... 2024-07-22 23:27:00 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 435
435 914092517 919239446 [{"message":"tamos a chegar","owner":"914092517","... 2024-07-22 02:37:48 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 434
434 914075533 919239446 [{"message":"Boas, sou o Lucas da Yakuza, já cá es... 2024-07-22 02:37:50 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 433
433 916827360 ambulance [{"created":"2024-07-21 14:38:16","read":1,"type":... 2024-07-21 14:38:17 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM phone_messages WHERE `phone_messages`.`id` = 432
432 914075533 armeiro [{"created":"2024-07-21 14:31:44","read":1,"type":... 2024-07-21 14:31:44 NULL
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query