jj304 Posted November 27, 2019 Share Posted November 27, 2019 Hi, I'm using the SQL TryIt Editor but the Truncate Table command seems to fail when running. It states there is a syntax error but i cannot see any issue. Is anyone else able to truncate one of the existing tables? Thanks, Link to comment Share on other sites More sharing options...
Ingolme Posted November 28, 2019 Share Posted November 28, 2019 What code did you use? Link to comment Share on other sites More sharing options...
Funce Posted November 28, 2019 Share Posted November 28, 2019 Huh, that's interesting. It seems that even using the example code in https://www.w3schools.com/sql/sql_ref_drop_table.asp is enough to error out. Link to comment Share on other sites More sharing options...
Funce Posted November 28, 2019 Share Posted November 28, 2019 Trying it in Firefox yields a different result Error in SQL: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. I'd suggest clicking on "Report Error" at the bottom of the page I linked. That will alert the devs to fix it. Here it is again https://www.w3schools.com/sql/sql_ref_drop_table.asp Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now