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 `resep_pulang`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts no_rawat kode_brng jml_barang harga total dosis tanggal jam kd_bangsal no_batch no_faktur
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000001' AND `resep_pulang`.`kode_brng` = 'IFOTABG00013' AND `resep_pulang`.`tanggal` = '2023-04-18' AND `resep_pulang`.`jam` = '10:46:48' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000001 IFOTABG00013 15 805 12075 3 X 1 SESUDAH MAKAN 2023-04-18 10:46:48 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000001' AND `resep_pulang`.`kode_brng` = 'IFOTABG00026' AND `resep_pulang`.`tanggal` = '2023-04-18' AND `resep_pulang`.`jam` = '10:46:48' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000001 IFOTABG00026 20 3956 79120 2 X 2 TABLET SESUDAH MAKAN 2023-04-18 10:46:48 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000001' AND `resep_pulang`.`kode_brng` = 'IFOTABP00004' AND `resep_pulang`.`tanggal` = '2023-04-18' AND `resep_pulang`.`jam` = '10:46:48' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000001 IFOTABP00004 10 3135 31350 2 X 1 TABLET SESUDAH  MAKAN 2023-04-18 10:46:48 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000001' AND `resep_pulang`.`kode_brng` = 'IFOTABP00074' AND `resep_pulang`.`tanggal` = '2023-04-18' AND `resep_pulang`.`jam` = '10:46:48' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000001 IFOTABP00074 10 2528 25280 1 X 1 SESUDAH MAKAN 2023-04-18 10:46:48 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000001' AND `resep_pulang`.`kode_brng` = 'TUSLAH2' AND `resep_pulang`.`tanggal` = '2023-04-18' AND `resep_pulang`.`jam` = '10:46:48' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000001 TUSLAH2 4 1000 4000 2023-04-18 10:46:48 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000012' AND `resep_pulang`.`kode_brng` = 'IFOTABG00026' AND `resep_pulang`.`tanggal` = '2023-04-19' AND `resep_pulang`.`jam` = '20:17:51' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000012 IFOTABG00026 30 3956 118680 2 X 2 TABLET SESUDAH MAKAN 2023-04-19 20:17:51 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000012' AND `resep_pulang`.`kode_brng` = 'IFOTABG00040' AND `resep_pulang`.`tanggal` = '2023-04-19' AND `resep_pulang`.`jam` = '20:17:51' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000012 IFOTABG00040 20 3372 67440 3 X 1 TABLET SESUDAH MAKAN 2023-04-19 20:17:51 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000012' AND `resep_pulang`.`kode_brng` = 'IFOTABP00004' AND `resep_pulang`.`tanggal` = '2023-04-19' AND `resep_pulang`.`jam` = '20:17:51' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000012 IFOTABP00004 10 3135 31350 3 X 1 TABLET SESUDAH MAKAN 2023-04-19 20:17:51 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000012' AND `resep_pulang`.`kode_brng` = 'IFOTABP00008' AND `resep_pulang`.`tanggal` = '2023-04-19' AND `resep_pulang`.`jam` = '20:17:51' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000012 IFOTABP00008 20 1748 34960 3 X 1 TABLET SESUDAH MAKAN 2023-04-19 20:17:51 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000012' AND `resep_pulang`.`kode_brng` = 'IFOTOPP00027' AND `resep_pulang`.`tanggal` = '2023-04-19' AND `resep_pulang`.`jam` = '20:17:51' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000012 IFOTOPP00027 3 33866 101598 1 X 1 /DUBUR 2023-04-19 20:17:51 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000012' AND `resep_pulang`.`kode_brng` = 'TUSLAH2' AND `resep_pulang`.`tanggal` = '2023-04-19' AND `resep_pulang`.`jam` = '20:17:51' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000012 TUSLAH2 5 1000 5000 2023-04-19 20:17:51 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000013' AND `resep_pulang`.`kode_brng` = 'IFOSIRG00010' AND `resep_pulang`.`tanggal` = '2023-04-18' AND `resep_pulang`.`jam` = '22:44:07' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000013 IFOSIRG00010 1 103846 103846 3 X 1 SENDOK MAKAN, 1/2 JAM SEBELUM MAKAN 2023-04-18 22:44:07 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000013' AND `resep_pulang`.`kode_brng` = 'IFOSIRG00010' AND `resep_pulang`.`tanggal` = '2023-04-21' AND `resep_pulang`.`jam` = '22:44:07' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000013 IFOSIRG00010 1 103846 103846 3 X 1 SENDOK TEH SEBELUM MAKAN 2023-04-21 22:44:07 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000013' AND `resep_pulang`.`kode_brng` = 'IFOTABG00060' AND `resep_pulang`.`tanggal` = '2023-04-21' AND `resep_pulang`.`jam` = '22:44:07' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000013 IFOTABG00060 15 1798 26970 2 X 1 TABLET SEBELUM MAKAN 2023-04-21 22:44:07 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000013' AND `resep_pulang`.`kode_brng` = 'TUSLAH1' AND `resep_pulang`.`tanggal` = '2023-04-18' AND `resep_pulang`.`jam` = '22:44:07' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000013 TUSLAH1 1 5000 5000 2023-04-18 22:44:07 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000013' AND `resep_pulang`.`kode_brng` = 'TUSLAH2' AND `resep_pulang`.`tanggal` = '2023-04-18' AND `resep_pulang`.`jam` = '22:44:07' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000013 TUSLAH2 1 1000 1000 2023-04-18 22:44:07 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/17/000013' AND `resep_pulang`.`kode_brng` = 'TUSLAH2' AND `resep_pulang`.`tanggal` = '2023-04-21' AND `resep_pulang`.`jam` = '22:44:07' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/17/000013 TUSLAH2 2 1000 2000 2023-04-21 22:44:07 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/26/000001' AND `resep_pulang`.`kode_brng` = 'IFOTABG00013' AND `resep_pulang`.`tanggal` = '2023-04-28' AND `resep_pulang`.`jam` = '08:32:03' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/26/000001 IFOTABG00013 15 805 12075 3 X 1 SESUDAH MAKAN 2023-04-28 08:32:03 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/26/000001' AND `resep_pulang`.`kode_brng` = 'IFOTABG00026' AND `resep_pulang`.`tanggal` = '2023-04-28' AND `resep_pulang`.`jam` = '08:32:03' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/26/000001 IFOTABG00026 20 3956 79120 2 X 2 TABLET SESUDAH MAKAN 2023-04-28 08:32:03 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/26/000001' AND `resep_pulang`.`kode_brng` = 'IFOTABP00074' AND `resep_pulang`.`tanggal` = '2023-04-28' AND `resep_pulang`.`jam` = '08:32:03' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/26/000001 IFOTABP00074 10 4266 42660 1 X 1 SESUDAH MAKAN 2023-04-28 08:32:03 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/26/000001' AND `resep_pulang`.`kode_brng` = 'TUSLAH2' AND `resep_pulang`.`tanggal` = '2023-04-28' AND `resep_pulang`.`jam` = '08:32:03' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/26/000001 TUSLAH2 3 1000 3000 2023-04-28 08:32:03 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/28/000001' AND `resep_pulang`.`kode_brng` = 'IFOTABG00013' AND `resep_pulang`.`tanggal` = '2023-04-29' AND `resep_pulang`.`jam` = '05:45:00' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/28/000001 IFOTABG00013 15 805 12075 3 X 1 SESUDAH MAKAN 2023-04-29 05:45:00 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/28/000001' AND `resep_pulang`.`kode_brng` = 'IFOTABG00026' AND `resep_pulang`.`tanggal` = '2023-04-29' AND `resep_pulang`.`jam` = '05:45:00' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/28/000001 IFOTABG00026 20 3956 79120 2 X 2 TABLET SESUDAH MAKAN 2023-04-29 05:45:00 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/28/000001' AND `resep_pulang`.`kode_brng` = 'IFOTABP00004' AND `resep_pulang`.`tanggal` = '2023-04-29' AND `resep_pulang`.`jam` = '05:45:00' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/28/000001 IFOTABP00004 10 3135 31350 2 X 1 SESUDAH MAKAN 2023-04-29 05:45:00 IFA
Edit Edit Copy Copy Delete Delete
DELETE FROM resep_pulang WHERE `resep_pulang`.`no_rawat` = '2023/04/28/000001' AND `resep_pulang`.`kode_brng` = 'IFOTABP00074' AND `resep_pulang`.`tanggal` = '2023-04-29' AND `resep_pulang`.`jam` = '05:45:00' AND `resep_pulang`.`no_batch` = '' AND `resep_pulang`.`no_faktur` = ''
2023/04/28/000001 IFOTABP00074 10 4266 42660 1 X 1 SESUDAH MAKAN 2023-04-29 05:45:00 IFA
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