Professional Web Applications Themes

setting PRIMARY KEY for table - MySQL

Hi I have a table that has no PRIMARY KEY. I'd like to use "id" as PRIMARY KEY *without loosing the content of the table*. How is this done? -- peace, love & harmony Atte [url]http://www.atte.dk[/url]...

  1. #1

    Default setting PRIMARY KEY for table

    Hi

    I have a table that has no PRIMARY KEY. I'd like to use "id" as PRIMARY
    KEY *without loosing the content of the table*. How is this done?

    --
    peace, love & harmony
    Atte

    [url]http://www.atte.dk[/url]
    Atte André Jensen Guest

  2. #2

    Default Re: setting PRIMARY KEY for table

    "Atte André Jensen" <atteballbreaker.dk> ha scritto nel messaggio
    news:43ff0f8b$0$15790$14726298news.sunsite.dk...
    > Hi
    >
    > I have a table that has no PRIMARY KEY. I'd like to use "id" as PRIMARY
    > KEY *without loosing the content of the table*. How is this done?
    alter table <table_name> add primary key(column_name);


    Regards,
    Dimitre


    DR Guest

  3. #3

    Default Re: setting PRIMARY KEY for table

    DR wrote:
    > alter table <table_name> add primary key(column_name);
    Thanks!

    --
    peace, love & harmony
    Atte

    [url]http://www.atte.dk[/url]
    Atte André Jensen Guest

Similar Threads

  1. Question Remove Duplicate Rows in MySQL Table Having No Primary Key or Unique Index
    By deltaforce in forum Brainstorming Area
    Replies: 0
    Last Post: July 25th, 10:14 AM
  2. 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
  3. default index for primary key of a table
    By Greg Stark in forum PostgreSQL / PGSQL
    Replies: 0
    Last Post: December 24th, 08:15 PM
  4. Replies: 2
    Last Post: August 12th, 07:55 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