+ 1
How can i create table in sql whose table name is order inspite it is a pre defined clause for sql !
3 Antworten
+ 6
Try using double quotes when specifying the name
CREATE TABLE "ORDER" (...)
(or could be the inverted tick for MySQL maybe, depending on your ANSI settings)
CREATE TABLE `ORDER`
+ 3
Try setting the options of your SQL client accordingly:
https://stackoverflow.com/questions/2901453/sql-standard-to-escape-column-names
0
It's not working!