Error deleting data in phpmyadmin

Question

Error deleting data in phpmyadmin

Navigation

#1 by (1 votes)
#2 by (0 votes)

0

I am trying to delete a data in a table in phpmyadmin, when I enter the table and I give it to delete, it does not erase the data. If I try Delete as a query from the console I get the following message:

1054 the column in where clause is unknown

This is what I execute:

DELETE FROM 'encabezadocotizacion' WHERE 'encabezadocotizacion'.'idCotizacion' = COQ-69318

mysql phpmyadmin

asked by Ronald López 01.06.2018 в 16:53

source

2 answers

Cancel input event redirect to a PHP page with header

score 1 · Answer 1

1

The DELETE statement is like this:

DELETE FROM encabezadocotizacion WHERE idCotizacion='COQ-69318'

can also be used like this:

DELETE FROM encabezadocotizacion WHERE encabezadocotizacion.idCotizacion='COQ-69318'

answered by 01.06.2018 в 17:01

score 0 · Answer 2

I think the problem is that the WHERE element is separated because of the quotes. Try with:

DELETE FROM encabezadocotizacion WHERE encabezadocotizacion.idCotizacion = 'COQ-69318'

This other statement should also work:

DELETE FROM encabezadocotizacion WHERE idCotizacion = 'COQ-69318'