Jerry Swanson [EMAIL PROTECTED] wrote:
I have field date type of datetime. I need to modify to timestamp.
If I alter the table and mofiy the field will this crash the data in
the field.
MySQL server will crash? Please show us the error message.
--
For technical support contracts, goto
I have field date type of datetime. I need to modify to timestamp.
If I alter the table and mofiy the field will this crash the data in
the field.
TH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 26-Oct-2001 Tim Evans wrote:
I have inherited a database built by someone else who was apparently
very
stingy. :-)
A primary key was set to 'tinyint(4)' limiting the number of records
to 128.
I've tried:
alter table my_data modify phyid mediumint unsigned DEFAULT 0;
...but
Hi,
A primary key was set to 'tinyint(4)' limiting the number of records
to 128.
I've tried:
alter table my_data modify phyid mediumint unsigned DEFAULT 0;
ERROR 1121: Column 'phyid' is used with UNIQUE or INDEX but is not
defined as NOT NULL
Try:
alter table my_data modify phyid
I have inherited a database built by someone else who was apparently
very
stingy. :-)
A primary key was set to 'tinyint(4)' limiting the number of records
to 128.
I've tried:
alter table my_data modify phyid mediumint unsigned DEFAULT 0;
...but got:
ERROR 1121: Column 'phyid' is used with