Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: cafelahore »Table: tbl_stock_dairy
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 (11697 total, Query took 0.0009 seconds.)
SELECT * FROM `tbl_stock_dairy`
Full texts idtypeproduct_idin_idout_idin_quantityin_costout_quantityout_costbalance_quantitybalance_costpost_datepost_timestatusdescriptionlast_updated
1 0 394 6189 0 4.000 550.00 0.000 0.00 4.000 550.00 2024-06-26 02:20:24 1 Purchase: 6189
2 0 450 6190 0 25.000 15.00 0.000 0.00 25.000 15.00 2024-06-27 10:17:39 1 Purchase: 6190
3 0 467 6191 0 3.000 800.00 0.000 0.00 3.000 800.00 2024-06-27 10:21:53 1 Purchase: 6191
4 0 120 6192 0 2.000 3722.50 0.000 0.00 2.000 3722.50 2024-06-27 10:24:01 1 Purchase: 6192
5 0 357 6193 0 6.000 616.67 0.000 0.00 6.000 616.67 2024-06-27 10:25:52 1 Purchase: 6193
6 0 5 6194 0 18.000 200.00 0.000 0.00 18.000 200.00 2024-06-27 10:28:14 1 Purchase: 6194
7 0 307 6195 0 240.000 25.00 0.000 0.00 240.000 25.00 2024-06-27 10:30:12 1 Purchase: 6195
8 0 402 6196 0 1.000 4609.00 0.000 0.00 1.000 4609.00 2024-06-27 10:34:36 1 Purchase: 6196
9 0 499 6197 0 500.000 3.20 0.000 0.00 500.000 3.20 2024-06-27 10:35:12 1 Purchase: 6197
10 0 120 6198 0 4.000 1360.50 0.000 0.00 6.000 2147.83 2024-06-27 10:37:06 1 Purchase : 6198
11 0 142 6199 0 500.000 2.10 0.000 0.00 500.000 2.10 2024-06-27 10:37:55 1 Purchase: 6199
12 0 475 6200 0 1.000 1020.00 0.000 0.00 1.000 1020.00 2024-06-27 10:40:11 1 Purchase: 6200
13 0 104 6200 0 5.000 380.00 0.000 0.00 5.000 380.00 2024-06-27 10:40:11 1 Purchase: 6200
14 0 310 6201 0 4.000 11900.00 0.000 0.00 4.000 11900.00 2024-06-27 12:11:02 1 Purchase: 6201
15 0 8 6202 0 1.000 13500.00 0.000 0.00 1.000 13500.00 2024-06-27 12:13:23 1 Purchase: 6202
16 0 450 6203 0 58.000 15.00 0.000 0.00 83.000 15.00 2024-06-27 12:14:12 1 Purchase : 6203
17 0 319 6204 0 3.000 2250.00 0.000 0.00 3.000 2250.00 2024-06-27 12:19:01 1 Purchase: 6204
18 0 229 6204 0 5.000 2200.00 0.000 0.00 5.000 2200.00 2024-06-27 12:19:01 1 Purchase: 6204
19 0 507 6205 0 8.000 180.00 0.000 0.00 8.000 180.00 2024-06-27 12:20:19 1 Purchase: 6205
20 0 296 6206 0 1.500 853.33 0.000 0.00 1.500 853.33 2024-06-27 12:23:28 1 Purchase: 6206
21 0 450 6206 0 14.000 25.00 0.000 0.00 97.000 16.44 2024-06-27 12:23:28 1 Purchase : 6206
22 0 450 6207 0 7.000 48.57 0.000 0.00 104.000 18.60 2024-06-27 12:24:37 1 Purchase : 6207
23 0 366 6208 0 1.000 500.00 0.000 0.00 1.000 500.00 2024-06-27 12:25:30 1 Purchase: 6208
24 0 407 6209 0 10.000 400.00 0.000 0.00 10.000 400.00 2024-06-27 12:27:21 1 Purchase: 6209
25 0 450 6210 0 50.000 20.00 0.000 0.00 154.000 19.05 2024-06-27 12:38:25 1 Purchase : 6210