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:
The problem is that I want to add a new column called shortdesc of type TEXT.+---------+-------------+------+-----+---------+-------+
| 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 | |
+---------+-------------+------+-----+---------+-------+
I am using this (according to the mySQL manual this should work):
Code: Select all
ALTER TABLE tuts ADD shortdesc TEXT;According to the mySQL manual this is a permission denied error. I have checked the user table and I have alter priveleges.ERROR 7: Error on rename of '.\tutorials\#sql-720_7e.MYI' to '.\tutorials\tuts.MYI' (Errcode: 13)
Any idea why this is happening?
Thanks,
Dave