Urgent: Really Need help on this 1

[s2001]

I am trying to create database with a field name Desc.

Here's the code:

Create Table Test (FName Varchar(30), Desc Varchar(50));

But i get an error in syntax near Desc.. I guess i figured out that Desc is a reserved..but does any of you guys know a work around..

let me know thanks

Thanks

Murali Bala

 

[sleipnir214]

Sure. Rename your column. There is no good reason for naming a column after a reserved word.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[s2001]

thanx. but i can't rename the column.

Murali Bala

 

[sleipnir214]

You can't pick a better name for a column in a table named "Test"?

If by some astounding set of circumstances you are physically prevented from picking a more appropriate column name, you can use reserved words as column names by surrounding them with backticks.

However, this is an extraordinarily bad idea and may cause other problems with software.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[s2001]

thanks i did change the column name..but now i have another issue..i am creating a table called Check.

Create table Check (IssuedTo Varchar(41))

again i am getting an error..any work around would be highly appreciated.
I have to stick to this format (can't change the table name)

In Sql server you can actually put brackets around the name like [Check]..but could do it MySql.

Murali Bala

 

[sleipnir214]

"Check" is also a reserved word.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sleipnir214]

Here is the list of MySQL reserved words:

http://www.mysql.com/doc/en/Reserved_words.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[s2001]

thanx a lot..so do you know a work around for this..is it using backticks

Murali Bala

 

[s2001]

thanx a bunch everythings seems to be woking.

Murali Bala

 

[sleipnir214]

As I said in an earlier post, it is backticks.

But using backticks is not the solution. Picking good, descriptive column names is.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!