On Wed, Dec 05, 2001 at 04:57:42PM -0700, Jon Gardiner wrote:
>
> I can't speak for other table formats but in MyIsam tables you can
> take your database down, rename the table's files (.frm .MYI .MYD),
> and restart the server. I'd make a backup if you are going to try
> it, though.
Watch out i
inskis [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 05, 2001 4:16 PM
> To: [EMAIL PROTECTED]
> Subject: Re: queries on particular table produce errors
>
>
> On Wednesday, December 5, 2001, at 04:08 PM, Robert Alexander wrote:
>
> > At 15:55 -0700 2001/12/05,
Alex Pukinskis writes:
> mysql> ALTER TABLE 'group' RENAME groups;
> ERROR 1064: You have an error in your SQL syntax near ''group' RENAME
> groups' at line 1
It should be ` (backtick) rather than ' (apostrophe/single quote). This
is explained i the manual section on table/column names if I'm
On Wednesday, December 5, 2001, at 04:08 PM, Robert Alexander wrote:
> At 15:55 -0700 2001/12/05, Alex Pukinskis wrote:
>>> group is a reserved word, use groups as table name
>>
>> That being the case, how do I drop or rename a table called "group"?
>
> Try:
>
> ALTER TABLE 'group' RENAME new_ta
At 15:55 -0700 2001/12/05, Alex Pukinskis wrote:
>> group is a reserved word, use groups as table name
>
>That being the case, how do I drop or rename a table called "group"?
Try:
ALTER TABLE 'group' RENAME new_table_name
HTH,
/Rob
~
Robert Alexander, A
On Wednesday, December 5, 2001, at 03:44 PM, Philippe Parmentier wrote:
> group is a reserved word, use groups as table name
That being the case, how do I drop or rename a table called "group"?
-Alex
--
Alex Pukinskis
Internet Consultant
aboutChange
http://aboutchange.com
http://aboutcreati
Yes, group is a reserved word (think GROUP BY). See
http://www.mysql.com/doc/R/e/Reserved_words.html
I believe you can make this work by putting the table name in quotes, e.g.
Select * FROM 'group';
but you will probably find it easioer to rename your table.
Michael
On Wed, 5 Dec 2001, A
group is a reserved word, use groups as table name
-Original Message-
From: Alex Pukinskis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 11:39 PM
To: [EMAIL PROTECTED]
Subject: queries on particular table produce errors
Whenever I try to do anything with a specific table
