Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: cafe »Table: tbl_purchaser_details
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.

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 (1847 total, Query took 0.0068 seconds.) [post_date: 2025-03-14... - 2025-03-10...]
SELECT * FROM `tbl_purchaser_details` ORDER BY `post_date` DESC 
Full texts idpost_date Descending Ascending 1other_sourcestoday_billssupplier_idprevious_billpending_billsremark
1969 2025-03-14 -28403 89416 0 0 0
1970 2025-03-14 0 0 42 0 14000
1971 2025-03-14 0 0 80 0 6660
1972 2025-03-14 0 0 80 0 7600
1973 2025-03-14 0 0 80 0 4930
1974 2025-03-14 0 0 28 0 10760
1964 2025-03-13 -18874 87859 0 0 0
1965 2025-03-13 0 0 65 0 2920
1966 2025-03-13 0 0 56 0 38106
1967 2025-03-13 0 0 17 0 19820
1968 2025-03-13 0 0 37 0 3960
1961 2025-03-12 3036 21910 0 0 0
1962 2025-03-12 0 0 17 0 12814
1963 2025-03-12 0 0 9 0 28835
1953 2025-03-11 0 19584 0 0 0
1954 2025-03-11 0 0 9 0 50015
1955 2025-03-11 0 0 65 0 2900
1956 2025-03-11 0 0 80 0 7350
1957 2025-03-11 0 0 80 0 15421
1958 2025-03-11 0 0 9 0 26365
1959 2025-03-11 0 0 57 0 60740
1960 2025-03-11 0 0 64 0 221355
1950 2025-03-10 -912 49110 0 0 0
1951 2025-03-10 0 0 80 0 7160
1952 2025-03-10 0 0 17 0 16586