Sorry about that. You are correct using AFTER or FIRST with ALTER TABLE ...
MODIFY is not supported until version 4.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
Hi,
RE:
> I believe this is what you are looking for:
> ALTER TABLE Images MODIFY I
Hi,
RE:
> I believe this is what you are looking for:
> ALTER TABLE Images MODIFY Imcreatedat datetime NOT NULL default '-00-00
> 00:00:00' AFTER Imccdtemp;
Thanks, Tom for the clue.
Yes, this is what I tried, but it did not work. Seems like modify does
not accept the "AFTER" part.
I tried
TED]
Sent: Wednesday, December 29, 2004 9:36 PM
To: mysqllist
Subject: move column position
Hi,
Is there a solution for "moving" a column in a table from a position to
another?
I tried various "alter table" configurations.
The only solution i found was (trying to "move&quo
Hi,
Is there a solution for "moving" a column in a table from a position to
another?
I tried various "alter table" configurations.
The only solution i found was (trying to "move" IMcreatedat):
# Add temporary column:
Alter table Images add column
temp datetime NOT NULL default '-00-00 0
