Query failed: syntax error at or near "*"

Learn SQL
1

I try to do this select from * "tablename"; and say:

Query failed: syntax error at or near ""
I also try to drop that table drop table if exist "tablename" and say:

Query failed: syntax error at or near “exist”

This error appears after include a new row in the table, however, I didn’t modify the table name.
What happen?

2

Welcome to the bit.io community!

You’re using invalid SQL. Try select * from "tablename" and DROP TABLE IF EXISTS "tablename".

To learn more about SQL, we recommend

3

Hi
what is invalid with?
select * from tablename the quotes?, I also did it without them, and also with the complete path…
In the example shows without quotes…
Uploading: image.png…

It didn’t work…
actually at the beginning it worked, but after inserting the rows it stopped doing it.

4

is invalid SQL

select * from "tablename" is valid