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
This seems very basic to me but I can't find (though
only really looked for a little bit) the syntax for
issuing an alter table statement that will force a
field to no longer allow NULL values. I have some
fields in a MyISAM table of MySQL 3.23 and wish to
require them to contain a value.
What is
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
Hi all,
Hopefully a simple question for anyone who cares to take a swing at it:
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 statement, to remove the unique
constraint / key on this field? A "modify" doesn'
however, I get the following message -
Access denied for user: '[EMAIL PROTECTED]' to database 'chrisdb'
The query used to add some fields to an already created table called
"question" is as follows -
ALTER TABLE question ADD NumberOfStaff VARCHAR (20) , ADD
ble called
> "question" is as follows -
>
> ALTER TABLE question ADD NumberOfStaff VARCHAR (20) , ADD PortfolioProducts
> TEXT , ADD PortfolioClients TEXT , ADD AdditionalInfo TEXT
it appears that your isp needs to turn on 'alter_priv' permission for user
'[
