将文件拖动至此

SQL 上传 ( 0 ) x -

页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 用时
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :
浏览模式
自定义浏览模式。
浏览模式
文档 仅使用图标、文字或都使用。 还原为默认值
文档 仅使用图标、文字或都使用。 还原为默认值
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。 还原为默认值
文档 浏览结果集时显示的行数。若结果集总行数超过该值,将会显示 "上一页" 和 "下一页" 的链接。 还原为默认值
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序,其它字段递增。 还原为默认值
文档 高亮鼠标指针所在的行。 还原为默认值
文档 高亮选中的行。 还原为默认值
文档 还原为默认值
文档 还原为默认值
文档 每 X 单元格重复表头,要禁止此功能请设为 0 还原为默认值
文档 浏览非数字字段时最多显示的字数。 还原为默认值
文档 这些是编辑、复制和删除链接。 还原为默认值
文档 缺少唯一键时是否显示行链接。 还原为默认值
文档 默认用主键为表排序。 还原为默认值
文档 当浏览表时使用上次的排序方式。 还原为默认值
文档 显示选项 还原为默认值
SELECT * FROM `berkas_digital_perawatan`
编辑内嵌 ] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新 ]
完整内容 no_rawat kode lokasi_file
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2022/10/20/000169' AND `berkas_digital_perawatan`.`kode` = '005' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/'
2022/10/20/000169 005 pages/upload/
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2023/02/07/000063' AND `berkas_digital_perawatan`.`kode` = '003' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20230207000063_16757689450.png'
2023/02/07/000063 003 pages/upload/20230207000063_16757689450.png
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2023/06/08/000012' AND `berkas_digital_perawatan`.`kode` = '005' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/'
2023/06/08/000012 005 pages/upload/
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2023/06/08/000012' AND `berkas_digital_perawatan`.`kode` = '006' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/WhatsApp_Image_2023-05-25_at_10.21.00.jpeg'
2023/06/08/000012 006 pages/upload/WhatsApp_Image_2023-05-25_at_10.21.00...
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2023/06/09/000199' AND `berkas_digital_perawatan`.`kode` = '006' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/WhatsApp_Image_2023-06-09_at_23.38.23_(1).jpeg'
2023/06/09/000199 006 pages/upload/WhatsApp_Image_2023-06-09_at_23.38.23...
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2023/11/10/000100' AND `berkas_digital_perawatan`.`kode` = '006' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/WhatsApp_Image_2023-11-10_at_20.26.19.jpeg'
2023/11/10/000100 006 pages/upload/WhatsApp_Image_2023-11-10_at_20.26.19...
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/05/17/000367' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240517000367001D0000038.pdf'
2024/05/17/000367 001 pages/upload/20240517000367001D0000038.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/06/05/000158' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240605000158001D0000038.pdf'
2024/06/05/000158 001 pages/upload/20240605000158001D0000038.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/06/29/000074' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240629000074001D0000073.pdf'
2024/06/29/000074 001 pages/upload/20240629000074001D0000073.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/01/000217' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240701000217001D0000038.pdf'
2024/07/01/000217 001 pages/upload/20240701000217001D0000038.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/05/000070' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240705000070001D0000014.pdf'
2024/07/05/000070 001 pages/upload/20240705000070001D0000014.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/09/000092' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240709000092001D0000014.pdf'
2024/07/09/000092 001 pages/upload/20240709000092001D0000014.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/09/000107' AND `berkas_digital_perawatan`.`kode` = '008' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240709000107008D0000014.pdf'
2024/07/09/000107 008 pages/upload/20240709000107008D0000014.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/10/000215' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240710000215001D0000014.pdf'
2024/07/10/000215 001 pages/upload/20240710000215001D0000014.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/10/000228' AND `berkas_digital_perawatan`.`kode` = 'DIG001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/TN_SYADDAM_RAFAEL.pdf'
2024/07/10/000228 DIG001 pages/upload/TN_SYADDAM_RAFAEL.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/11/000005' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240711000005001D0000041.pdf'
2024/07/11/000005 001 pages/upload/20240711000005001D0000041.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/11/000149' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240711000149001D0000041.pdf'
2024/07/11/000149 001 pages/upload/20240711000149001D0000041.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/12/000219' AND `berkas_digital_perawatan`.`kode` = '006' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240712000219006D0000009.pdf'
2024/07/12/000219 006 pages/upload/20240712000219006D0000009.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/14/000033' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240714000033001D0000016.pdf'
2024/07/14/000033 001 pages/upload/20240714000033001D0000016.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/15/000147' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240715000147001D0000041.pdf'
2024/07/15/000147 001 pages/upload/20240715000147001D0000041.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/16/000114' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240716000114001D0000074.pdf'
2024/07/16/000114 001 pages/upload/20240716000114001D0000074.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/17/000079' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240717000079001D0000060.pdf'
2024/07/17/000079 001 pages/upload/20240717000079001D0000060.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/17/000102' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240717000102001D0000060.pdf'
2024/07/17/000102 001 pages/upload/20240717000102001D0000060.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/17/000121' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240717000121001D0000016.pdf'
2024/07/17/000121 001 pages/upload/20240717000121001D0000016.pdf
编辑 编辑 复制 复制 删除 删除
DELETE FROM berkas_digital_perawatan WHERE `berkas_digital_perawatan`.`no_rawat` = '2024/07/17/000122' AND `berkas_digital_perawatan`.`kode` = '001' AND `berkas_digital_perawatan`.`lokasi_file` = 'pages/upload/20240717000122001D0000016.pdf'
2024/07/17/000122 001 pages/upload/20240717000122001D0000016.pdf
选中项: 选中项:
查询结果操作 复制到剪贴板 复制到剪贴板 导出 导出 显示图表 显示图表 新建视图 新建视图
将此 SQL 查询加为书签 将此 SQL 查询加为书签