Forgot your password?
Close
typodupeerror
This discussion has been archived. No new comments can be posted.

Altering tables in mysql More

Altering tables in mysql

Comments Filter:

  • In this particular case, I had to add an auto-incrementing primary key, which was not described in the text. Luckily, the MySQL manual [mysql.com] led me to the solution:

    ALTER TABLE gastenboek ADD COLUMN id mediumint(9) auto_increment, ADD PRIMARY KEY(id);

    Before doing this, I had to drop the previous primary key:

    ALTER TABLE gastenboek DROP PRIMARY KEY;

Slashdot Top Deals

"People should have access to the data which you have about them. There should be a process for them to challenge any inaccuracies." -- Arthur Miller

Close