Any documentation on using mysql on docket?

|
Hardisk97 2022-05-28 12:21:20
even I try to alter the where clause it will always show me that error message
Hardisk97 2022-05-28 12:22:11
but I can make a delete on other tables that I had made
Swapnil 2022-05-28 12:22:48
Hardisk97 2022-05-28 12:20:27
😭nothing changes

Rename the column

Piyu9999 2022-05-28 12:33:19
Any documentation on using mysql on docket?
Amrendra_Singh1 2022-05-28 16:35:43
Hardisk97 2022-05-28 10:30:12
Good afternoon.I am a newbie of MySql. Two hours ago while I was testing my database I got a problem and I cannot find the reason.I create a table and added some rows in that table. I want to delete one of them which have been written in the table and I got an error message but when I try to delete the row that not recorded the DBMS didn’t show me any error message. I have tried to find out at google but I got nothing.Could anybody tell me the reason ? My English is poor , sorry for that.

Your p_no data type is number or varchar?

Amrendra_Singh1 2022-05-28 16:37:59
If No then remove inverted comma
IsBackAgain 2022-05-28 18:41:58
Hello, Only in english???
IsBackAgain 2022-05-28 19:10:48
DELIMITER |

CREATE TRIGGER UpdateIFV AFTER UPDATE ON Factura
FOR EACH ROW
BEGIN
UPDATE IvaFacturaVenta IFV SET IDGeneracion = NEW.IDGeneracion WHERE (IDFactura = Factura.IDFactura);
END;

|
DELIMITER ;

IsBackAgain 2022-05-28 19:11:13
Anyone can help me with Trigger (Before Update)
Swapnil 2022-05-28 19:17:00
IsBackAgain 2022-05-28 19:11:13
Anyone can help me with Trigger (Before Update)

What is the requirement here ?

IsBackAgain 2022-05-28 19:17:29
Update IDGeneracion (FIELD) only in 1 row
IsBackAgain 2022-05-28 19:17:42
Only in IDFactura
IsBackAgain 2022-05-28 19:18:16
‘idIvaFacturaVenta’, ‘int(10)’, ‘NO’, ‘PRI’, ”, ‘auto_increment’
‘idFactura’, ‘int(10) unsigned’, ‘NO’, ‘PRI’, ”, ”
‘IDGeneracion’, ‘int(10) unsigned’, ‘YES’, ”, ”, ”
‘Remito’, ‘int(11)’, ‘YES’, ”, ”, ”
‘Iva105’, ‘double(15,3)’, ‘YES’, ”, ‘0.000’, ”
‘Iva210’, ‘double(15,3)’, ‘YES’, ”, ‘0.000’, ”
‘Iva270’, ‘double(15,3)’, ‘YES’, ”, ‘0.000’, ”
‘Retenciones’, ‘double(15,3)’, ‘YES’, ”, ”, ”
‘Percepciones’, ‘double(15,3)’, ‘YES’, ”, ”, ”
‘NoGravado’, ‘double(15,3)’, ‘YES’, ”, ”, ”
‘ITC’, ‘double(15,3)’, ‘YES’, ”, ”, ”
‘TasaHidrica’, ‘double(15,3)’, ‘YES’, ”, ”, ”
‘ImpExento’, ‘double(15,3)’, ‘YES’, ”, ”, ”
‘Redondeo’, ‘double(15,3)’, ‘YES’, ”, ”, ”
Swapnil 2022-05-28 19:18:20
IsBackAgain 2022-05-28 19:10:48
DELIMITER |

CREATE TRIGGER UpdateIFV AFTER UPDATE ON Factura
FOR EACH ROW
BEGIN
UPDATE IvaFacturaVenta IFV SET IDGeneracion = NEW.IDGeneracion WHERE (IDFactura = Factura.IDFactura);
END;

|
DELIMITER ;

what is factura.IDFactura here ?

IsBackAgain 2022-05-28 19:18:34
Factura (Table)
Swapnil 2022-05-28 19:19:07
IsBackAgain 2022-05-28 19:10:48
DELIMITER |

CREATE TRIGGER UpdateIFV AFTER UPDATE ON Factura
FOR EACH ROW
BEGIN
UPDATE IvaFacturaVenta IFV SET IDGeneracion = NEW.IDGeneracion WHERE (IDFactura = Factura.IDFactura);
END;

|
DELIMITER ;

There is no join with factura table here

IsBackAgain 2022-05-28 19:19:16
‘idFactura’, ‘int(10) unsigned’, ‘NO’, ‘PRI’, ”, ‘auto_increment’
‘IDGeneracion’, ‘int(10) unsigned’, ‘NO’, ”, ”, ”
‘idClientes’, ‘int(10) unsigned’, ‘NO’, ‘MUL’, ”, ”
‘IDEmpresas’, ‘int(10)’, ‘NO’, ‘MUL’, ”, ”
‘idTipoDocumentos’, ‘int(10) unsigned’, ‘NO’, ‘MUL’, ”, ”
‘idEmpleados’, ‘int(10) unsigned’, ‘YES’, ”, ”, ”
‘IDTipoDetalle’, ‘varchar(2)’, ‘YES’, ”, ”, ”
‘NroComprobante’, ‘varchar(8)’, ‘YES’, ”, ”, ”
‘PuntoDeVenta’, ‘varchar(4)’, ‘YES’, ”, ”, ”
‘Letra’, ‘varchar(1)’, ‘YES’, ”, ”, ”
‘Fecha’, ‘date’, ‘YES’, ”, ”, ”
‘Hora’, ‘time’, ‘YES’, ”, ”, ”
‘NombreParaImprimir’, ‘varchar(255)’, ‘YES’, ”, ”, ”
‘Remito’, ‘int(10) unsigned’, ‘YES’, ”, ”, ”
‘Comentario’, ‘varchar(150)’, ‘YES’, ”, ”, ”
‘BienesServicios’, ‘varchar(1)’, ‘YES’, ”, ”, ”
‘FechaVencimiento’, ‘date’, ‘YES’, ”, ”, ”
‘Subtotal’, ‘double(15,5)’, ‘YES’, ”, ”, ”
‘Descuento’, ‘double(15,5)’, ‘YES’, ”, ”, ”
‘Total’, ‘double(15,5)’, ‘YES’, ”, ”, ”
‘SuPago’, ‘double(15,5)’, ‘YES’, ”, ”, ”
‘Vuelto’, ‘double(15,5)’, ‘YES’, ”, ”, ”
‘Timestamp’, ‘timestamp’, ‘NO’, ”, ‘CURRENT_TIMESTAMP’, ”
IsBackAgain 2022-05-28 19:19:23
IsBackAgain 2022-05-28 19:19:16
‘idFactura’, ‘int(10) unsigned’, ‘NO’, ‘PRI’, ”, ‘auto_increment’
‘IDGeneracion’, ‘int(10) unsigned’, ‘NO’, ”, ”, ”
‘idClientes’, ‘int(10) unsigned’, ‘NO’, ‘MUL’, ”, ”
‘IDEmpresas’, ‘int(10)’, ‘NO’, ‘MUL’, ”, ”
‘idTipoDocumentos’, ‘int(10) unsigned’, ‘NO’, ‘MUL’, ”, ”
‘idEmpleados’, ‘int(10) unsigned’, ‘YES’, ”, ”, ”
‘IDTipoDetalle’, ‘varchar(2)’, ‘YES’, ”, ”, ”
‘NroComprobante’, ‘varchar(8)’, ‘YES’, ”, ”, ”
‘PuntoDeVenta’, ‘varchar(4)’, ‘YES’, ”, ”, ”
‘Letra’, ‘varchar(1)’, ‘YES’, ”, ”, ”
‘Fecha’, ‘date’, ‘YES’, ”, ”, ”
‘Hora’, ‘time’, ‘YES’, ”, ”, ”
‘NombreParaImprimir’, ‘varchar(255)’, ‘YES’, ”, ”, ”
‘Remito’, ‘int(10) unsigned’, ‘YES’, ”, ”, ”
‘Comentario’, ‘varchar(150)’, ‘YES’, ”, ”, ”
‘BienesServicios’, ‘varchar(1)’, ‘YES’, ”, ”, ”
‘FechaVencimiento’, ‘date’, ‘YES’, ”, ”, ”
‘Subtotal’, ‘double(15,5)’, ‘YES’, ”, ”, ”
‘Descuento’, ‘double(15,5)’, ‘YES’, ”, ”, ”
‘Total’, ‘double(15,5)’, ‘YES’, ”, ”, ”
‘SuPago’, ‘double(15,5)’, ‘YES’, ”, ”, ”
‘Vuelto’, ‘double(15,5)’, ‘YES’, ”, ”, ”
‘Timestamp’, ‘timestamp’, ‘NO’, ”, ‘CURRENT_TIMESTAMP’, ”

Factura (Table)

IsBackAgain 2022-05-28 19:20:01
Factura.IDFactura=IvaFacturaVenta.IDFactura relationship
Swapnil 2022-05-28 19:20:12
IsBackAgain 2022-05-28 19:10:48
DELIMITER |

CREATE TRIGGER UpdateIFV AFTER UPDATE ON Factura
FOR EACH ROW
BEGIN
UPDATE IvaFacturaVenta IFV SET IDGeneracion = NEW.IDGeneracion WHERE (IDFactura = Factura.IDFactura);
END;

|
DELIMITER ;

Join is required here of IvaFacturaVenta table with Factura table

IsBackAgain 2022-05-28 19:20:39
Join?
snehakshaylata 2022-05-28 19:20:44
any expert on mysql database
Swapnil 2022-05-28 19:22:38
IsBackAgain 2022-05-28 19:20:39
Join?

Update IvaFacturaVenta a
inner join Factuta b on
a.IDFactura = b.IDFactura
set idgeneracion = new.idgeneracion

Swapnil 2022-05-28 19:22:49
snehakshaylata 2022-05-28 19:20:44
any expert on mysql database

Yes please tell me

IsBackAgain 2022-05-28 19:22:53
ahhhhhhhhhhh only with inner join
IsBackAgain 2022-05-28 19:22:57
perfect!! Thanks
snehakshaylata 2022-05-28 19:24:45
this is not working
snehakshaylata 2022-05-28 19:24:48
query
Abbici 2022-05-28 19:25:40
Swapnil 2022-05-28 00:34:12
tell me how should ur output look like.

Good evening.
Basically I should make a calendar with weekly appointments as if they were school hours.

Abbici 2022-05-29 08:27:47
bye bye
piyush 2022-05-29 18:39:32
Need paid Help
30 question
30 min

Please need help for tomm.

Manoj Kumar 2022-05-29 20:17:54
mysql_en-21075.jpg
Photo from Manoj Kumar
Manoj Kumar 2022-05-29 20:18:21
mysql_en-21076.jpg
Error Code : 1822 vastundi ???
Manoj Kumar 2022-05-29 20:18:56
I got 1822 error while trying to give a foreign key
Manoj Kumar 2022-05-29 20:19:16
Can any one help me out please??
|