SQL Error [1064] [42000]: You have an error in your SQL syntax

Asked

Viewed 1,256 times

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.

  • 1

    your table must be related to another, and it is deleting a record from which the other one depends

  • Take this "the Tc"

  • the item in this table was actually related to another table. thanks :)

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.