hi,
I have a table with a 'priority' field defined as an ENUM:
priority enum('SOMEDAY','NOW','SOON') NOT NULL
I would like to change it to the following so the sort order is more
intuitive/desirable.
priority enum('NOW','SOON', 'SOMEDAY') NOT NULL
I am guessing that some form of ALTER TABLE t
I am new to MySQL and have encountered a problem that probably happens
to everyone, yet I have searched for a solution online and elsewhere
without success. I created a database and table. Then I populated the
table. Everything worked perfectly. Then I shutdown MySQL and rebooted
my
..
On Wednesday, September 24, 2003, at 06:58 AM, Victor Pendleton wrote:
Are the frm, myd and myi files located in the data directory? What is
the
data directory?
-Original Message-
From: Avram Aelony [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 8:43 AM
To: [EMAIL
23 18:46 tasks.MYI
-rw-rw 1 mysql wheel 8819 Sep 23 00:56 tasks.frm
On Wednesday, September 24, 2003, at 07:15 AM, Victor Pendleton wrote:
Can you post the contents from the todo directory?
-Original Message-
From: Avram Aelony [mailto:[EMAIL PROTECTED]
Sent: Wednesday
-
From: Avram Aelony [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 9:37 AM
To: Victor Pendleton
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL newbie: table gone after reboot
Okay, I had to log in as root to do so. The data seems to be still
extant in tasks.MYD .
The other 2 files
selected needs to own the directory and
files in
the todo directory.
chown -R mysql todo
chgrp -R mysql todo
...
Error 13 means that the user that started the MySQL server does not
have
permission to access the todo directory.
-Original Message-
From: Avram Aelony [mailto:[EMAIL PROTECTED