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!
Neuer Kurs! Jeder Programmierer sollte generative KI lernen!
Kostenlose Lektion ausprobieren
+ 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 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`
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