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 the manual that corresponds to your MySQL server version for the right syntax to use near 'column color varchar(10) sixth' at line 1 Here's my table one more time for reference: mysql> describe car_table; +--------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+--------------+------+-----+---------+----------------+ | car_id | int(11) | NO | PRI | NULL | auto_increment | | vin | varchar(17) | YES | | NULL | | | year | decimal(4,0) | YES | | NULL | | | make | varchar(10) | YES | | NULL | | | model | varchar(20) | YES | | NULL | | | color | varchar(10) | YES | | NULL | | | price | decimal(7,2) | YES | | NULL | | +--------+--------------+------+-----+---------+----------------+ 7 rows in set (0.01 sec) I appreciate your suggestions so far and it would be great if I could get some help with this one too. Thanks Tim On Sat, Jun 28, 2014 at 1:34 PM, Tim Dunphy <bluethu...@gmail.com> wrote: > 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 <cars...@bitbybit.dk> > wrote: > >> 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 | Key | Default | Extra | >>> +---------+--------------+------+-----+---------+----------------+ >>> | car_id | int(11) | NO | PRI | NULL | auto_increment | >>> | vin | varchar(17) | YES | | NULL | | >>> | color | varchar(10) | YES | | NULL | | >>> | year | decimal(4,0) | YES | | NULL | | >>> | make | varchar(10) | YES | | NULL | | >>> | model | varchar(20) | YES | | NULL | | >>> | howmuch | decimal(5,2) | YES | | NULL | | >>> +---------+--------------+------+-----+---------+----------------+ >>> 7 rows in set (0.03 sec) >>> >>> I am trying to position the 'color' column after the 'model' column with >>> the following command: >>> >>> mysql> alter table car_table modify column color after model; >>> >>> And I'm getting the following error: >>> >>> ERROR 1064 (42000): You have an error in your SQL syntax; check the >>> manual >>> that corresponds to your MySQL server version for the right syntax to use >>> near 'after model' at line 1 >>> >> >> Try: >> alter table car_table modify column color varchar(10) after model; >> >> / Carsten >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql >> >> > > > -- > GPG me!! > > gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B > > -- GPG me!! gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
