1
When I add a new row to the table I can delete using the command:
DELETE
FROM
ebdb.tb_categoria as tc
WHERE
id = 790;
However, the lines that already exist cannot delete and returns the error:
check the manual that Corresponds to your Mysql server version for the right syntax to use near 'as Tc WHERE id = 790' at line 3
I find it strange because, changes like UPDATE I can run on these lines. I am using Dbeaver 6.2.2
Thanks in advance.
your table must be related to another, and it is deleting a record from which the other one depends
– Ricardo Pontual
Take this "the Tc"
– Motta
the item in this table was actually related to another table. thanks :)
– IsadoraOliv