How can I create a query that subtracts a certain percentage?

Navigation
2

I have a table with a certain amount of price according to each article, I would like to know how I can subtract a percentage from the price, for example 30%.

    
asked by emmanuel gomez toledo 15.11.2018 в 01:35
source

1 answer

1

Start with the statement UPDATE 

UPDATE Tabla
SET precio = precio * 0.7
WHERE -- las filas que quieras actualizar
    
answered by 15.11.2018 / 01:43
source
Does not show the value of an XMl node Trigger to auto-insert values in a table