Problem with AUTO_INCREMENT default value (Mysql)

skydeex's profile image skydeex posted 4 years ago in General Permalink

Hello

  • Not selected default value AUTO_INCREMENT

  • After copy row lose null in field value but normal insert new row

scrins in attachemt

Create query CREATE TABLEusers(idINT(4) NOT NULL,nameVARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',phoneBIGINT(20) NULL DEFAULT NULL,password_hashVARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8_general_ci',auth_hashVARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8_general_ci',create_datetimeDATETIME(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) USING BTREE, UNIQUE INDEXphoneUni(phone) USING BTREE, UNIQUE INDEXautHUni(auth_hash) USING BTREE ) COLLATE='utf8_general_ci' ENGINE=InnoDB AUTO_INCREMENT=7 ;

2 attachment(s):
  • 1
  • 2
ansgar's profile image ansgar posted 4 years ago Permalink

Most probably what issue #909 describes. Will be fixed soon.

skydeex's profile image skydeex posted 4 years ago Permalink

Thanks :)

Please login to leave a reply, or register at first.