Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: smartschool3 »Table: messages
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

Customise browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (196 total, Query took 0.0391 seconds.)
SELECT * FROM `messages`
Full texts idtitlemessagesend_mailsend_smsis_groupis_individualis_classgroup_listuser_listcreated_atupdated_at
1 Remote Test <p>Test from Remote Desk Assenbly Bible College</p... 1 0 1 0 0 [] NULL 2020-04-12 20:20:35 NULL
2 Remote Test <p>WE are in testing phase</p>
1 0 1 0 0 [] NULL 2020-04-12 20:29:00 NULL
3 Remote Mail Test <p>Remote Test</p>
1 0 1 0 0 [] NULL 2020-04-12 20:53:14 NULL
4 Library Books <p>Please note All Library Books have been capture... 1 0 1 0 0 [] NULL 2020-04-12 20:57:08 NULL
5 Test Platform <p>Platform Testing</p>
1 0 1 0 0 [] NULL 2020-04-12 21:00:45 NULL
6 Remote MAil <p>Remote Mail Test on 587 sll</p>
1 0 1 0 0 [] NULL 2020-04-12 21:08:11 NULL
7 TestT <p>est</p>

<p>&nbsp;</p>

<p>587 ssl</p>
1 0 0 1 0 NULL [{"category":"staff","user_id":"1","email":"suppor... 2020-04-12 21:18:55 NULL
8 Remote Email <p>Remote Email on 587</p>

<p>Retesting on 465<...
1 0 1 0 0 [] NULL 2020-04-12 21:24:39 NULL
9 Email Rote Test <p>465 ssl outgoing working fine on different doma... 1 0 1 0 0 [] NULL 2020-04-12 21:27:27 NULL
10 Books Loaded <p>Please note that the email engine is preconfigu... 1 0 1 0 0 [] NULL 2020-04-12 21:30:59 NULL
11 Remote Testing <p><span style="font-size:26px"><span style="font-... 1 0 1 0 0 [] NULL 2020-04-12 21:44:33 NULL
12 Remote Test <p>HOPE IS ALIVE!<br />
No matter what you&rsquo;...
1 0 1 0 0 [] NULL 2020-04-12 21:56:40 NULL
13 Database Creation <p>User: &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &n... 1 0 1 0 0 [] NULL 2020-04-13 18:58:20 NULL
14 Communicate Module <h1>Communicate</h1>

<hr />
<p>This module has...
1 0 1 0 0 [] NULL 2020-04-13 19:55:23 NULL
15 Communicate  Function <h1>Communicate</h1>

<hr />
<p>This module has...
1 0 1 0 0 [] NULL 2020-04-13 20:01:09 NULL
16 Send Email Section <p><strong>Send Email</strong>- Go to <strong>Comm... 1 0 1 0 0 [] NULL 2020-04-13 20:06:41 NULL
17 Communicate <h1>Communicate</h1>

<hr />
<p>This module has...
1 0 1 0 0 [] NULL 2020-04-13 20:15:11 NULL
18 Email Sending <p><strong>Send Email</strong>- Go to <strong>Comm... 1 0 1 0 0 [] NULL 2020-04-13 20:16:26 NULL
19 Email Setup <p>Manual Settings<br />
If you do not see an aut...
1 0 1 0 0 [] NULL 2020-04-13 20:44:35 NULL
20 Test <p>Manual Settings<br />
If you do not see an aut...
1 0 1 0 0 [] NULL 2020-04-13 20:47:38 NULL
21 Remote Test <p>Server Update out going ssl</p>

<p>&nbsp;</p...
1 0 1 0 0 [] NULL 2020-04-13 20:51:23 NULL
22 New Link to External Access <p>Please recieve External Link for Production pur... 1 0 1 0 0 [] NULL 2020-04-16 18:34:52 NULL
23 Temporary Tunnel Link <p>Please note the Temporary Access link is Valid ... 1 0 1 0 0 [] NULL 2020-04-16 19:41:57 NULL
24 Connection Flux <h2 style="text-align:center">Too Many Connections... 1 0 0 1 0 NULL [{"category":"staff","user_id":"6","email":"norocm... 2020-04-16 22:00:39 NULL
25 Security Token Update <p>Please note that the currebt tunnel session exp... 1 0 1 0 0 [] NULL 2020-04-17 16:04:23 NULL