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 if
Whenever I try to do anything with a specific table in my db, I get an
error. Here's the list of tables:
mysql show tables;
++
| Tables_in_acv2 |
++
| company|
| group |
| internet |
| knowing|
| person |
| personality|
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
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, Alpha
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_table_name
No
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 not
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 wrote:
group is a reserved word, use groups