Suelte aquí los archivos

SQL upload ( 0 ) x-

Servidor: localhost »Base de datos: sik »Tabla: detail_pemberian_obat
Ajustes de página relacionadaPulse en la barra para deslizarse al tope de la página
Presione Ctrl+Enter para ejecutar la consulta Presione Enter para ejecutar la consulta
ascendente
descendente
Orden:
Depuración SQL
Cantidad
Orden de ejecución
Tiempo necesario
Ordenar por:
Consultas grupales
Desagrupar las consultas
Colapsar Expandir Mostrar rastro Ocultar rastro Cantidad Tiempo necesario
Favoritos
Actualizar
Agregar
Ningún favorito
Agregar favorito
Opciones
Definir predeterminado





Colapsar Expandir Reconsultar Editar Explicar Perfilando Agregar a favoritos Falló la consulta Base de datos : Fecha y hora la consulta :

Modalidad de navegación

Cambiar las opciones de la modalidad de visualización.

Documentación Use solamente íconos, solamente texto o ambos.
Documentación Use solamente íconos, solamente texto o ambos.
Documentación Si el usuario puede ver un botón "mostrar todos (los registros)" o no.
Documentación Número de filas mostradas cuando se visualiza un juego de resultados. Si el juego de resultados contiene más filas, aparecerán enlaces "Anterior" y "Siguiente".
Documentación SMART - es decir: orden descendente para columnas de tipo TIME, DATE, DATETIME y TIMESTAMP, ascendente en los demás casos.
Documentación Resaltar las filas señaladas por el cursor del ratón.
Documentación Resaltar las filas seleccionadas.
Documentación
Documentación
Documentación Repetir cabecera cada X celdas, 0 desactiva esta funcionalidad.
Documentación Cantidad máxima de caracteres a mostrar en un campo no-numérico en vista de navegación.
Documentación Estos son los enlaces para Editar, Copiar y Borrar.
Documentación Si se muestran enlaces de fila, incluso en ausencia de una clave única.
Documentación Ordenación predeterminada para tablas con una clave primaria.
Documentación Al explorar tablas, se recordará el ordenamiento de cada tabla.
Documentación Opciones de visualización
Mostrando filas 0 - 24 (total de 157624, La consulta tardó 0.0010 segundos.)
SELECT * FROM `detail_pemberian_obat`
[Editar en línea] [ Editar ] [ Explicar SQL ] [ Crear código PHP ] [ Actualizar]
|
|
|
Número de filas:
Filtrar filas:
Ordenar según la clave:
Textos completostgl_perawatanjamno_rawatkode_brngh_belibiaya_obatjmlembalasetuslahtotalstatuskd_bangsalno_batchno_faktur
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2019-12-26\' AND `detail_pemberian_obat`.`jam` = \'12:01:18\' AND `detail_pemberian_obat`.`no_rawat` = \'2019/12/26/000001\' AND `detail_pemberian_obat`.`kode_brng` = \'OPTIK00002\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2019-12-26 12:01:18 2019/12/26/000001 OPTIK00002 200000 450000 1 0 0 450000 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2019-12-26\' AND `detail_pemberian_obat`.`jam` = \'12:23:23\' AND `detail_pemberian_obat`.`no_rawat` = \'2019/12/26/000002\' AND `detail_pemberian_obat`.`kode_brng` = \'OPTIK00001\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2019-12-26 12:23:23 2019/12/26/000002 OPTIK00001 225000 500000 1 0 0 500000 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2019-12-26\' AND `detail_pemberian_obat`.`jam` = \'12:23:23\' AND `detail_pemberian_obat`.`no_rawat` = \'2019/12/26/000002\' AND `detail_pemberian_obat`.`kode_brng` = \'OPTIK00002\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2019-12-26 12:23:23 2019/12/26/000002 OPTIK00002 200000 450000 1 0 0 450000 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2019-12-26\' AND `detail_pemberian_obat`.`jam` = \'12:44:08\' AND `detail_pemberian_obat`.`no_rawat` = \'2019/12/26/000002\' AND `detail_pemberian_obat`.`kode_brng` = \'OPTIK00001\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2019-12-26 12:44:08 2019/12/26/000002 OPTIK00001 225000 500000 1 0 0 500000 Ralan B0026
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'12:52:07\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000018\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000143\' AND `detail_pemberian_obat`.`no_batch` = \'-\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 12:52:07 2020/01/02/000018 A000000143 99 400 10 500 1500 6000 Ralan AP -
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'12:57:50\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000015\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000202\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 12:57:50 2020/01/02/000015 A000000202 76175 91500 1 0 1500 93000 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'12:57:50\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000015\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000211\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 12:57:50 2020/01/02/000015 A000000211 28875 34700 1 0 1500 36200 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'12:57:50\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000015\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000241\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 12:57:50 2020/01/02/000015 A000000241 50875 61100 1 700 1500 63300 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:14:33\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000012\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000206\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:14:33 2020/01/02/000012 A000000206 24750 27300 1 0 1500 28800 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:14:33\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000012\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000241\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:14:33 2020/01/02/000012 A000000241 50875 61100 1 0 1500 62600 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:16:44\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000016\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000143\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:16:44 2020/01/02/000016 A000000143 99 400 10 0 1500 5500 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:19:29\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000010\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000231\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:19:29 2020/01/02/000010 A000000231 18329 26680 1 0 1500 28180 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:25:14\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000011\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000052\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:25:14 2020/01/02/000011 A000000052 2363 3812 10 0 1500 39620 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:25:14\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000011\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000160\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:25:14 2020/01/02/000011 A000000160 33687 40500 1 0 1500 42000 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:37:20\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000009\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000211\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:37:20 2020/01/02/000009 A000000211 28875 34700 1 0 1500 36200 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:37:20\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000009\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000241\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:37:20 2020/01/02/000009 A000000241 50875 61100 1 0 1500 62600 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:41:28\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000006\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000052\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:41:28 2020/01/02/000006 A000000052 2363 3812 10 0 1500 39620 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:41:28\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000006\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000160\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:41:28 2020/01/02/000006 A000000160 33687 40500 1 0 1500 42000 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:45:52\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000013\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000180\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:45:52 2020/01/02/000013 A000000180 33577 40300 1 0 1500 41800 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:45:52\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000013\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000210\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:45:52 2020/01/02/000013 A000000210 21862 26300 1 0 1500 27800 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:46:55\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000014\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000180\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:46:55 2020/01/02/000014 A000000180 33577 40300 1 0 1500 41800 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:46:55\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000014\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000211\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:46:55 2020/01/02/000014 A000000211 28875 34700 1 0 1500 36200 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:47:57\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000003\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000206\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:47:57 2020/01/02/000003 A000000206 24750 27300 1 0 1500 28800 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:47:57\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000003\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000241\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:47:57 2020/01/02/000003 A000000241 50875 61100 1 0 1500 62600 Ralan AP
Editar EditarCopiar CopiarBorrar Borrar
DELETE FROM `detail_pemberian_obat` WHERE `detail_pemberian_obat`.`tgl_perawatan` = \'2020-01-02\' AND `detail_pemberian_obat`.`jam` = \'13:52:20\' AND `detail_pemberian_obat`.`no_rawat` = \'2020/01/02/000008\' AND `detail_pemberian_obat`.`kode_brng` = \'A000000049\' AND `detail_pemberian_obat`.`no_batch` = \'\' AND `detail_pemberian_obat`.`no_faktur` = \'\'
2020-01-02 13:52:20 2020/01/02/000008 A000000049 2721 3266 5 0 1500 17830 Ralan AP
Para los elementos que están marcados: Para los elementos que están marcados:

|
|
|
Número de filas:
Filtrar filas:
Ordenar según la clave:
Operaciones sobre los resultados de la consultaImprimir ImprimirCopiar al portapapeles Copiar al portapapelesExportar Exportar Mostrar gráfico Mostrar gráfico Crear vista Crear vista

Guardar esta consulta en favoritos Guardar esta consulta en favoritos