Create a table or field with keywords in sql

Sometimes when we name a table or a field, we accidentally select a keyword in SQL to name it, and then we get an error:

Error:syntax error at or near "limit"

MySQL workaround: In MySQL you need to add '

CREATE TABLE  intint);   # because both order and limit are keywords in mysql, you must add ' to use

PostgreSQL Workaround: You need to add "" in PostgreSQL

Create table  " Order int int);   # because both order and limit are keywords in PostgreSQL, you must add "" to use

However, when naming tables or fields, it is best to consider using non-reserved names

Create a table or field with keywords in sql