Need a little newbie help with altering a table in mysql. I created a
varchar(255) column that is no longer suitable for my needs and I wan to change
it to a memo field. I have constructed the following query to change the column
type but it doesn't work. Any help greatly appreciated.
$query1="ALTER TABLE Format CHANGE ptext memo";
// execute query
$result = mysql_query($query1) or die ("Error in query $query1" .
// close connection
This is the error message I get
Error in query ALTER TABLE Format CHANGE ptext memoYou have an error in your ...