mysql - 1064 error for ALTER AUTO_INCREMENT -


please help, table 'order' auto increment starting @ 14000, no matter try, keep getting below error?

mysql> alter table order auto_increment = 14000; 

error 1064 (42000): have error in sql syntax; check manual corresponds mysql server version right syntax use near 'order auto_increment = 14000' @ line 1

i have performed number of searches , far can tell correct syntax.

any appreciated.

your table has named order. order reserved word. use ` , table name order.

in way

`order` 

Comments

Popular posts from this blog

javascript - How to name a jQuery function to make a browser's back button work? -

python - Django-easy-pdf: xhtml2pdf reporting reportlab 2.2+ is required, but 3.0 installed -

collision detection - C++ library for mesh to mesh intersection: what is available? -