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:
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 TABLE
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 populate