MySQL: There is even fake data in the table, but there is a sync error.

Hello. After completing the table and data migration using javascriptorm, I entered the mysql shell and did desc <table name> because the query did not work. But

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order' at line 1

The grammar error appears as above. Of course, if you do show tables;, the table appears in the list. Have you experienced this before? If you have any information that you want to share, please leave a comment :)

sql mysql

2022-09-22 17:55

1 Answers

desc `order`;

select * from `order`;

If you wrap it with a bag-tick (`), you can use a reserved word.

2022-09-22 17:55

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656