Professional Web Applications Themes

How to move a column that has a primary key? - MySQL

Hi, The following query: ALTER TABLE tablename MODIFY COLUMN column1 mediumint(8) NOT NULL PRIMARY KEY AFTER column2 Gives this error message: Error query: Multiple primary key defined How should I move column1 ? Thanks!...

  1. #1

    Default How to move a column that has a primary key?

    Hi,

    The following query:

    ALTER TABLE tablename MODIFY COLUMN column1 mediumint(8) NOT NULL
    PRIMARY KEY AFTER column2

    Gives this error message:
    Error query: Multiple primary key defined

    How should I move column1 ?

    Thanks!

    sluijten@gmail.com Guest

  2. #2

    Default Re: How to move a column that has a primary key?

    > ALTER TABLE tablename MODIFY COLUMN column1 mediumint(8) NOT NULL 


    If you do not change the type of the column, but are only moving it,
    just remove the "PRIMARY KEY" keyword. There is already a primary key
    and it will still point to the same column, whatever position it has.

    Best regards
    Dikkie Guest

  3. #3

    Default Re: How to move a column that has a primary key?

    On Apr 8, 2:17 pm, Dikkie Dik <org> wrote: 


    >
    > If you do not change the type of the column, but are only moving it,
    > just remove the "PRIMARY KEY" keyword. There is already a primary key
    > and it will still point to the same column, whatever position it has.
    >
    > Best regards[/ref]

    Works, thanks!!

    sluijten@gmail.com Guest

Similar Threads

  1. Primary Scratch & Windows Primary Paging file?
    By Tommy Oberst in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 14
    Last Post: April 15th, 10:26 PM
  2. Move bound column to right of dynamic column in datagrid?
    By John E. in forum ASP.NET Data Grid Control
    Replies: 3
    Last Post: March 28th, 01:29 PM
  3. Photoshop Primary Scratch and Windows Primary Paging File Problem.
    By Kris_Kross@adobeforums.com in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 2
    Last Post: October 6th, 10:37 PM
  4. Partitioned Views: Partitioning column the only collumn in the primary key?
    By Ian Thomson in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: June 30th, 08:42 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139