Alter table 'tablename' change column 'columnname' 'new-columnname' not null
default 0
If you have any null values in that column, you will not be able to make the
change.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
Of course, I'd figure it out right after sending this. For the interested:
"alter table XYZ drop key foo;"
Take care,
--Noel
- Original Message -
Given an existing table with a field defined as:
"foo" char(60) not null unique
What would be the proper syntax for an ALTER TA
on 8/2/01 9:55 AM, Chris Malloch at [EMAIL PROTECTED] wrote:
> Hi people with far more knowledge than myself,
>
> I have recently started making use of MySQL on a virtual server provided by
> my ISP. I can telnet into the server using SSH Telnet, log in to my
> database, create tables and popul
