List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 1 2002 4:16am
Subject:Re: Can I create a table name 'INT'?
View as plain text  
In the last episode (Apr 30), Tim Johnson said:
> Hello All:
>   using mysql  Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
> 
>     I'm attempting to build a database with programming code. I get
>     an error when I attempt to execute the following: 'DROP TABLE IF
>     EXISTS INT'
> 
>     Is there any way around this, or must I use a different table
>     name than 'INT'

You can use reserved words as table and field names by putting them
inside backtics ` `.

http://www.mysql.com/doc/L/e/Legal_names.html

-- 
	Dan Nelson
	dnelson@stripped
Thread
• Can I create a table name 'INT'?Tim Johnson1 May
  • Re: Can I create a table name 'INT'?Dan Nelson1 May