Menu

#555 "Incorrect column specifier for column" when duplicated "id"

Git
closed-works-for-me
nobody
mysql (7)
5
2018-01-23
2017-06-03
No

Hey, I was creating a table in MySQL and forgot a coloumn immediately after the "id". I copied it and changed values but insertion failed because of
Incorrect column specifier for column 'status'
Looking at the query it started

CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `status` varchar(15) NOT NULL AUTO_INCREMENT PRIMARY KEY,

what is absolutely senseless but I can't see a way to change it.

1 Attachments

Discussion

  • Jakub Vrána

    Jakub Vrána - 2018-01-23
    • status: open --> closed-works-for-me
     
  • Jakub Vrána

    Jakub Vrána - 2018-01-23

    Please provide steps to reproduce this. What do you mean by "copied it"?

     
  • Jakub Vrána

    Jakub Vrána - 2018-01-23

    This is similar to #566.

     
  • Otto Richter

    Otto Richter - 2018-01-23

    Hey, I will try to reproduce it this weekend to check wether it is still present in latest version of adminer.
    This database (website) is no longer in use, I'll try to find it somewhere in the backups or create a new one.

     

Log in to post a comment.

MongoDB Logo MongoDB