SQLite删除与表别名[重复]-SQLitedeletewithtablealias[duplicate]

I am trying to alias a table in SQLite, for example by the following command: (it is from the book i am reading"Database Management Systems by Ramakrishnan")

我试图在SQLite中对表进行别名,例如通过以下命令:(它来自我正在阅读的书“Ramakrishnan的数据库管理系统”)

DELETE FROM Students S WHERE S.sid=12546

This code gives a syntax error. Without aliasing, the following code works:

此代码提供语法错误。如果没有别名,以下代码可以正常工作:

DELETE FROM Students WHERE sid=12546

But, if i want to alias the table, what should i do? Can anyone help?

但是,如果我想对表格进行别名,我该怎么办?有人可以帮忙吗?

Thanks

1 个解决方案

DELETE FROM Students WHERE sid=12546