how to create a table with column name 'key'?

2002-01-20 Thread Dominique Plante
I hope you can answer the following question. I am wondering how to create a table with a column named key. I have RTFMed and that didn't help. I'm using 3.23.47-max-debug. The following fails (after selecting a database): mysql create table test (key varchar(255), value varchar(255));

Re: how to create a table with column name 'key'?

2002-01-20 Thread Fred van Engen
Dominique, On Sun, Jan 20, 2002 at 12:18:45PM -0800, Dominique Plante wrote: The following fails (after selecting a database): mysql create table test (key varchar(255), value varchar(255)); You should be able to do this by using back-quotes around the column name: create table test

Re: how to create a table with column name 'key'?

2002-01-20 Thread Doug Thompson
Perhaps you read the wrong part(s) of the manual: http://www.mysql.com/doc/R/e/Reserved_words.html On Sun, 20 Jan 2002 12:18:45 -0800 (PST), Dominique Plante wrote: I hope you can answer the following question. I am wondering how to create a table with a column named key. I have RTFMed and