How can I make a table in MySQL called “order”?
up vote
8
down vote
favorite
When I make a MySQL table order, it is created successfully but, when I execute any query against it, it says "error 1064 , syntax error".
When I change the name to orders, it works fine.
But I don't want to change the name. How can I execute our query against the order table?
mysql
edited Jun 29 '10 at 5:24
paxdiablo
624k16812361657
add a comment |
up vote
8
down vote
favorite
When I make a MySQL table order, it is created successfully but, when I execute any query against it, it says "error 1064 , syntax error".
When I change the name to orders, it works fine.
But I don't want to change the name. How can I execute our query against the order table?
mysql
edited Jun 29 '10 at 5:24
paxdiablo
624k16812361657
add a comment |
up vote
8
down vote
favorite
up vote
8
down vote
favorite
When I make a MySQL table order, it is created successfully but, when I execute any query against it, it says "error 1064 , syntax error".
When I change the name to orders, it works fine.
But I don't want to change the name. How can I execute our query against the order table?
mysql
edited Jun 29 '10 at 5:24
paxdiablo
624k16812361657
When I make a MySQL table order, it is created successfully but, when I execute any query against it, it says "error 1064 , syntax error".
When I change the name to orders, it works fine.
But I don't want to change the name. How can I execute our query against the order table?
mysql
mysql
edited Jun 29 '10 at 5:24
paxdiablo
624k16812361657
edited Jun 29 '10 at 5:24
paxdiablo
624k16812361657
edited Jun 29 '10 at 5:24
paxdiablo
624k16812361657
edited Jun 29 '10 at 5:24
paxdiablo
624k16812361657
edited Jun 29 '10 at 5:24
paxdiablo
624k16812361657
624k16812361657
asked Jun 29 '10 at 4:43
DELETE me
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
up vote
17
down vote
accepted
can you use something like?
select * from `order`
answered Jun 29 '10 at 4:46
Preet Sangha
54.1k15111183
add a comment |
up vote
13
down vote
The word order is actually an SQL keyword. You would have the same problem if you tried to use a table called group or select. You can fix it is MySQL by using quotes around it, along the lines of:
select f1, f2 from `order` where blah blah blah ...
However, unless your table will only ever hold a single order (in which case it won't do so for long since the underlying business will soon be bankrupt), you should probably call your table orders.
That solves both your problems, the one you found and the one you didn't :-)
answered Jun 29 '10 at 5:18
paxdiablo
624k16812361657
The SQL standard recomandation is to use singular for tables names
– Ben
Nov 19 at 13:30
@Ben, if you'd like to point to the actual section of the standard that recommends this, I'll take it more seriously :-) Or did you just mean that it was common convention ? If the latter, I consider it a silly convention since you're not selecting things from a single order, you're seleting them from a tables of orders. That's the case even if you're selecting only items from one row.
– paxdiablo
Nov 20 at 11:04
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
17
down vote
accepted
can you use something like?
select * from `order`
answered Jun 29 '10 at 4:46
Preet Sangha
54.1k15111183
add a comment |
up vote
17
down vote
accepted
can you use something like?
select * from `order`
answered Jun 29 '10 at 4:46
Preet Sangha
54.1k15111183
add a comment |
up vote
17
down vote
accepted
up vote
17
down vote
accepted
can you use something like?
select * from `order`
answered Jun 29 '10 at 4:46
Preet Sangha
54.1k15111183
can you use something like?
select * from `order`
answered Jun 29 '10 at 4:46
Preet Sangha
54.1k15111183
answered Jun 29 '10 at 4:46
Preet Sangha
54.1k15111183
answered Jun 29 '10 at 4:46
Preet Sangha
54.1k15111183
answered Jun 29 '10 at 4:46
Preet Sangha
54.1k15111183
54.1k15111183
add a comment |
add a comment |
up vote
13
down vote
The word order is actually an SQL keyword. You would have the same problem if you tried to use a table called group or select. You can fix it is MySQL by using quotes around it, along the lines of:
select f1, f2 from `order` where blah blah blah ...
However, unless your table will only ever hold a single order (in which case it won't do so for long since the underlying business will soon be bankrupt), you should probably call your table orders.
That solves both your problems, the one you found and the one you didn't :-)
answered Jun 29 '10 at 5:18
paxdiablo
624k16812361657
The SQL standard recomandation is to use singular for tables names
– Ben
Nov 19 at 13:30
@Ben, if you'd like to point to the actual section of the standard that recommends this, I'll take it more seriously :-) Or did you just mean that it was common convention ? If the latter, I consider it a silly convention since you're not selecting things from a single order, you're seleting them from a tables of orders. That's the case even if you're selecting only items from one row.
– paxdiablo
Nov 20 at 11:04
add a comment |
up vote
13
down vote
The word order is actually an SQL keyword. You would have the same problem if you tried to use a table called group or select. You can fix it is MySQL by using quotes around it, along the lines of:
select f1, f2 from `order` where blah blah blah ...
However, unless your table will only ever hold a single order (in which case it won't do so for long since the underlying business will soon be bankrupt), you should probably call your table orders.
That solves both your problems, the one you found and the one you didn't :-)
answered Jun 29 '10 at 5:18
paxdiablo
624k16812361657
The SQL standard recomandation is to use singular for tables names
– Ben
Nov 19 at 13:30
@Ben, if you'd like to point to the actual section of the standard that recommends this, I'll take it more seriously :-) Or did you just mean that it was common convention ? If the latter, I consider it a silly convention since you're not selecting things from a single order, you're seleting them from a tables of orders. That's the case even if you're selecting only items from one row.
– paxdiablo
Nov 20 at 11:04
add a comment |
up vote
13
down vote
up vote
13
down vote
The word order is actually an SQL keyword. You would have the same problem if you tried to use a table called group or select. You can fix it is MySQL by using quotes around it, along the lines of:
select f1, f2 from `order` where blah blah blah ...
However, unless your table will only ever hold a single order (in which case it won't do so for long since the underlying business will soon be bankrupt), you should probably call your table orders.
That solves both your problems, the one you found and the one you didn't :-)
answered Jun 29 '10 at 5:18
paxdiablo
624k16812361657
The word order is actually an SQL keyword. You would have the same problem if you tried to use a table called group or select. You can fix it is MySQL by using quotes around it, along the lines of:
select f1, f2 from `order` where blah blah blah ...
However, unless your table will only ever hold a single order (in which case it won't do so for long since the underlying business will soon be bankrupt), you should probably call your table orders.
That solves both your problems, the one you found and the one you didn't :-)
answered Jun 29 '10 at 5:18
paxdiablo
624k16812361657
answered Jun 29 '10 at 5:18
paxdiablo
624k16812361657
answered Jun 29 '10 at 5:18
paxdiablo
624k16812361657
answered Jun 29 '10 at 5:18
paxdiablo
624k16812361657
624k16812361657
The SQL standard recomandation is to use singular for tables names
– Ben
Nov 19 at 13:30
@Ben, if you'd like to point to the actual section of the standard that recommends this, I'll take it more seriously :-) Or did you just mean that it was common convention ? If the latter, I consider it a silly convention since you're not selecting things from a single order, you're seleting them from a tables of orders. That's the case even if you're selecting only items from one row.
– paxdiablo
Nov 20 at 11:04
add a comment |
The SQL standard recomandation is to use singular for tables names
– Ben
Nov 19 at 13:30
@Ben, if you'd like to point to the actual section of the standard that recommends this, I'll take it more seriously :-) Or did you just mean that it was common convention ? If the latter, I consider it a silly convention since you're not selecting things from a single order, you're seleting them from a tables of orders. That's the case even if you're selecting only items from one row.
– paxdiablo
Nov 20 at 11:04
The SQL standard recomandation is to use singular for tables names
– Ben
Nov 19 at 13:30
The SQL standard recomandation is to use singular for tables names
– Ben
Nov 19 at 13:30
@Ben, if you'd like to point to the actual section of the standard that recommends this, I'll take it more seriously :-) Or did you just mean that it was common convention ? If the latter, I consider it a silly convention since you're not selecting things from a single order, you're seleting them from a tables of orders. That's the case even if you're selecting only items from one row.
– paxdiablo
Nov 20 at 11:04
@Ben, if you'd like to point to the actual section of the standard that recommends this, I'll take it more seriously :-) Or did you just mean that it was common convention ? If the latter, I consider it a silly convention since you're not selecting things from a single order, you're seleting them from a tables of orders. That's the case even if you're selecting only items from one row.
– paxdiablo
Nov 20 at 11:04
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f3137910%2fhow-can-i-make-a-table-in-mysql-called-order%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
