Hello,
I'm trying to use a very basic alter table command to position a column
after another column.
This is the table as it exists now:
mysql describe car_table;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
On 28-06-2014 19:11, Tim Dunphy wrote:
Hello,
I'm trying to use a very basic alter table command to position a column
after another column.
This is the table as it exists now:
mysql describe car_table;
+-+--+--+-+-++
| Field | Type | Null |
Cool guys, that did it..
ALTER TABLE car_table MODIFY COLUMN color VARCHAR(10) AFTER model;
For some reason the book I'm following doesn't specify that you have to
note the data type in moves! This helped. and thanks again.
Tim
On Sat, Jun 28, 2014 at 1:24 PM, Carsten Pedersen
Hey guys,
Sorry to hit you with one more. But I'm trying to use a positional
statement in a column move based on what you all just taught me:
mysql alter table modify column color varchar(10) sixth;
But I am getting this error:
ERROR 1064 (42000): You have an error in your SQL syntax; check
Hi Tim,
-Original Message-
From: Tim Dunphy [mailto:bluethu...@gmail.com]
Sent: Sunday, 29 June 2014 03:45
Cc: mysql@lists.mysql.com
Subject: Re: alter table modify syntax error
Hey guys,
Sorry to hit you with one more. But I'm trying to use a positional statement
in a column
Tim,
-Original Message-
From: Tim Dunphy [mailto:bluethu...@gmail.com]
Sent: Sunday, 29 June 2014 03:45
Cc: mysql@lists.mysql.com
Subject: Re: alter table modify syntax error
Hey guys,
Sorry to hit you with one more. But I'm trying to use a positional
statement
Hi Tim,
-Original Message-
From: Tim Dunphy [mailto:bluethu...@gmail.com]
Sent: Sunday, 29 June 2014 10:09
To: Jesper Wisborg Krogh
Cc: mysql@lists.mysql.com
Subject: Re: alter table modify syntax error
The syntax sixth is not a supported syntax. You should use the
syntax
Wisborg Krogh
Cc: mysql@lists.mysql.com
Subject: Re: alter table modify syntax error
The syntax sixth is not a supported syntax. You should use the
syntax AFTER column_name where you replace column_name with
the
column name you want to position the modified column after.
Oh