Problems using ALTER in mySQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
metal_dragen
Forum Newbie
Posts: 1
Joined: Fri Nov 29, 2002 9:15 pm
Location: Indianapolis, IN, USA

Problems using ALTER in mySQL

Post by metal_dragen »

Hello,

I am new to PHP and mySQL. I have been reading the PHP manuals and mySQL manuals about 12 times a day trying to learn this stuff.

I created a table called tuts:
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| id | int(3) | YES | | NULL | |
| name | varchar(60) | YES | | NULL | |
| thumb | varchar(20) | YES | | NULL | |
| content | text | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
The problem is that I want to add a new column called shortdesc of type TEXT.

I am using this (according to the mySQL manual this should work):

Code: Select all

ALTER TABLE tuts ADD shortdesc TEXT;
I an getting this error:
ERROR 7: Error on rename of '.\tutorials\#sql-720_7e.MYI' to '.\tutorials\tuts.MYI' (Errcode: 13)
According to the mySQL manual this is a permission denied error. I have checked the user table and I have alter priveleges.

Any idea why this is happening?

Thanks,
Dave
Post Reply