How can i create table in sql whose table name is order inspite it is a pre defined clause for sql ! | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

How can i create table in sql whose table name is order inspite it is a pre defined clause for sql !

23rd Nov 2018, 4:42 AM
vishal Raj
vishal Raj - avatar
3 Answers
+ 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`
23rd Nov 2018, 7:28 AM
Kuba SiekierzyƄski
Kuba SiekierzyƄski - avatar
+ 3
Try setting the options of your SQL client accordingly: https://stackoverflow.com/questions/2901453/sql-standard-to-escape-column-names
23rd Nov 2018, 7:56 AM
Kuba SiekierzyƄski
Kuba SiekierzyƄski - avatar
0
It's not working!
23rd Nov 2018, 7:35 AM
vishal Raj
vishal Raj - avatar