List:General Discussion« Previous MessageNext Message »
From:Tim Dunphy Date:June 28 2014 5:44pm
Subject:Re: alter table modify syntax error
View as plain text  
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 <bluethundr@stripped> 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 <carsten@stripped>
> 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

Thread
alter table modify syntax errorTim Dunphy28 Jun 2014
  • Re: alter table modify syntax errorCarsten Pedersen28 Jun 2014
    • Re: alter table modify syntax errorTim Dunphy28 Jun 2014
      • Re: alter table modify syntax errorTim Dunphy28 Jun 2014
        • RE: alter table modify syntax errorJesper Wisborg Krogh28 Jun 2014
          • Re: alter table modify syntax errorTim Dunphy29 Jun 2014
            • RE: alter table modify syntax errorJesper Wisborg Krogh29 Jun 2014
              • Re: alter table modify syntax errorTim Dunphy29 Jun 2014