|
|
Edit
|
Copy
|
Delete
DELETE FROM proc WHERE `proc`.`db` = 'articulos' AND `proc`.`name` = 'stpInsert' AND `proc`.`type` = 'PROCEDURE'
|
articulos |
stpInsert |
PROCEDURE |
stpInsert |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
C integer, D varchar(1), DL VARCHAR(1)
|
|
BEGIN
UPDATE PARTIDAS set CODIGO = C, DESCRIPCION = D, DESCRIPCIONL = DL where codigo = 1;
END
|
hsi@% |
2026-10-22 10:48:20 |
2026-10-22 10:48:20 |
NO_AUTO_VALUE_ON_ZERO |
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
UPDATE PARTIDAS set CODIGO = C, DESCRIPCION = D, DESCRIPCIONL = DL where codigo = 1;
END
|
NONE |
|
|
Edit
|
Copy
|
Delete
DELETE FROM proc WHERE `proc`.`db` = 'articulos' AND `proc`.`name` = 'stpFactuDeud4' AND `proc`.`type` = 'PROCEDURE'
|
articulos |
stpFactuDeud4 |
PROCEDURE |
stpFactuDeud4 |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
Loc Varchar(10), Cal Varchar(10), Fed date, Feh date
|
|
BEGIN
select * from vfactvdeud4 where(Localidad like Loc and Dom like Cal and FeUltPago between Fed and feh);
END
|
hsi@% |
2026-10-22 10:48:20 |
2026-10-22 10:48:20 |
NO_AUTO_VALUE_ON_ZERO |
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
select * from vfactvdeud4 where(Localidad like Loc and Dom like Cal and FeUltPago between Fed and feh);
END
|
NONE |
|
|
Edit
|
Copy
|
Delete
DELETE FROM proc WHERE `proc`.`db` = 'articulos' AND `proc`.`name` = 'stpCodigosParm2' AND `proc`.`type` = 'PROCEDURE'
|
articulos |
stpCodigosParm2 |
PROCEDURE |
stpCodigosParm2 |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
I VARCHAR(1), C VARCHAR(2)
|
|
BEGIN
select * from codigos
where(id > I and Codigo > C);
END
|
hsi@% |
2026-10-22 10:48:20 |
2026-10-22 10:48:20 |
NO_AUTO_VALUE_ON_ZERO |
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
select * from codigos
where(id > I and Codigo > C);
END
|
NONE |
|
|
Edit
|
Copy
|
Delete
DELETE FROM proc WHERE `proc`.`db` = 'articulos' AND `proc`.`name` = 'stpcodigosParm' AND `proc`.`type` = 'PROCEDURE'
|
articulos |
stpcodigosParm |
PROCEDURE |
stpcodigosParm |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
W integer
|
|
BEGIN
select CODIGO, DESCRIPCION from codigos where ( id > W );
END
|
hsi@% |
2026-10-22 10:48:20 |
2026-10-22 10:48:20 |
NO_AUTO_VALUE_ON_ZERO |
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
select CODIGO, DESCRIPCION from codigos where ( id > W );
END
|
NONE |
|
|
Edit
|
Copy
|
Delete
DELETE FROM proc WHERE `proc`.`db` = 'articulos' AND `proc`.`name` = 'stpcodigos' AND `proc`.`type` = 'PROCEDURE'
|
articulos |
stpcodigos |
PROCEDURE |
stpcodigos |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
|
|
BEGIN
SELECT * FROM CODIGOS;
END
|
hsi@% |
2026-10-22 10:48:20 |
2026-10-22 10:48:20 |
NO_AUTO_VALUE_ON_ZERO |
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
SELECT * FROM CODIGOS;
END
|
NONE |
|
|
Edit
|
Copy
|
Delete
DELETE FROM proc WHERE `proc`.`db` = 'factzt2' AND `proc`.`name` = 'stpcodigos' AND `proc`.`type` = 'PROCEDURE'
|
factzt2 |
stpcodigos |
PROCEDURE |
stpcodigos |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
|
|
BEGIN
SELECT * FROM CODIGOS;
END
|
hsi@% |
2026-10-22 10:57:23 |
2026-10-22 10:57:23 |
NO_AUTO_VALUE_ON_ZERO |
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
SELECT * FROM CODIGOS;
END
|
NONE |
|
|
Edit
|
Copy
|
Delete
DELETE FROM proc WHERE `proc`.`db` = 'factzt2' AND `proc`.`name` = 'stpcodigosParm' AND `proc`.`type` = 'PROCEDURE'
|
factzt2 |
stpcodigosParm |
PROCEDURE |
stpcodigosParm |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
W integer
|
|
BEGIN
select CODIGO, DESCRIPCION from codigos where ( id > W );
END
|
hsi@% |
2026-10-22 10:57:23 |
2026-10-22 10:57:23 |
NO_AUTO_VALUE_ON_ZERO |
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
select CODIGO, DESCRIPCION from codigos where ( id > W );
END
|
NONE |
|
|
Edit
|
Copy
|
Delete
DELETE FROM proc WHERE `proc`.`db` = 'factzt2' AND `proc`.`name` = 'stpCodigosParm2' AND `proc`.`type` = 'PROCEDURE'
|
factzt2 |
stpCodigosParm2 |
PROCEDURE |
stpCodigosParm2 |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
I VARCHAR(1), C VARCHAR(2)
|
|
BEGIN
select * from codigos
where(id > I and Codigo > C);
END
|
hsi@% |
2026-10-22 10:57:23 |
2026-10-22 10:57:23 |
NO_AUTO_VALUE_ON_ZERO |
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
select * from codigos
where(id > I and Codigo > C);
END
|
NONE |
|
|
Edit
|
Copy
|
Delete
DELETE FROM proc WHERE `proc`.`db` = 'factzt2' AND `proc`.`name` = 'stpFactuDeud4' AND `proc`.`type` = 'PROCEDURE'
|
factzt2 |
stpFactuDeud4 |
PROCEDURE |
stpFactuDeud4 |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
Loc Varchar(10), Cal Varchar(10), Fed date, Feh date
|
|
BEGIN
select * from vfactvdeud4 where(Localidad like Loc and Dom like Cal and FeUltPago between Fed and feh);
END
|
hsi@% |
2026-10-22 10:57:23 |
2026-10-22 10:57:23 |
NO_AUTO_VALUE_ON_ZERO |
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
select * from vfactvdeud4 where(Localidad like Loc and Dom like Cal and FeUltPago between Fed and feh);
END
|
NONE |
|
|
Edit
|
Copy
|
Delete
DELETE FROM proc WHERE `proc`.`db` = 'factzt2' AND `proc`.`name` = 'stpInsert' AND `proc`.`type` = 'PROCEDURE'
|
factzt2 |
stpInsert |
PROCEDURE |
stpInsert |
SQL |
CONTAINS_SQL |
NO |
DEFINER |
C integer, D varchar(1), DL VARCHAR(1)
|
|
BEGIN
UPDATE PARTIDAS set CODIGO = C, DESCRIPCION = D, DESCRIPCIONL = DL where codigo = 1;
END
|
hsi@% |
2026-10-22 10:57:23 |
2026-10-22 10:57:23 |
NO_AUTO_VALUE_ON_ZERO |
|
utf8mb4 |
utf8mb4_general_ci |
utf8mb4_general_ci |
BEGIN
UPDATE PARTIDAS set CODIGO = C, DESCRIPCION = D, DESCRIPCIONL = DL where codigo = 1;
END
|
NONE |