这句语句:
DELETE from users;
会删除表users中的所有内容。但是我如何可以同时从三个表users, inactiveUsers, activeUsers中删除所有内容呢?
我在Firefox SQLite manager中尝试了以下查询语句:
DELETE from users, inactiveUsers, activeUsers;
结果出现了错误信息:
SQLiteManager: Likely SQL syntax error: DELETE from users, inactiveUsers, activeUsers; [ near ",": syntax error ] Exception Name: NS_ERROR_FAILURE Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]