-3

Well, i have on my database, a field call int, and i made a program on C# thats update 'int' and some other fields, all went good till the int field says error in syntax. and i want SQL to mean int as just a name of a field and not a keyword. Thanks you very much.

Tim Lloyd
  • 37,954
  • 10
  • 100
  • 130
user895450
  • 1

1 Answers1

7

INT is a reserved word. You can use reserved words in MySQL by enclosing them in back-ticks:

SELECT `int` FROM mytable ...

But it's honestly easier if you refrain from using reserved words as identifiers. That is, name your column something else when you define the table.

It's also recommended to name columns something that more clearly describes their content or purpose. int is pretty over-generic and so it can be confusing; it's like naming a C# function thefunction(). :-)

See http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords.html for lists of reserved words by version of MySQL.

Re your comment:

Be careful to use the correct type of quote symbols. Use single-quotes to delimit string and date literals. In MySQL, use back-ticks to delimit identifiers for columns, tables, etc.

SELECT ... WHERE `column` = 'string'

On a US keyboard, the back-ticks are on the same key with the tilde (~).

I apologize for assuming that you're using MySQL. You might be using Microsoft SQL Server or some other brand of RDBMS. Microsoft SQL Server doesn't use back-ticks; instead you need to enclose identifiers in square brackets.

See also Do different databases use different name quote?

Community
  • 1
  • 1
Bill Karwin
  • 538,548
  • 86
  • 673
  • 828
  • Thank you very much guys , but its still not working , thats the code im trying to exceute : update characters SET 'int' = '5' WHERE name= 'myname' and im still get :You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''int' = '5' WHERE name= 'myname'' at line 1 Thanks guys, – user895450 Aug 15 '11 at 18:50