Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Problem with AUTO_INCREMENT default value (Mysql)

skydeex's profile image skydeex posted 1 month 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 1 month ago Permalink

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

skydeex's profile image skydeex posted 1 month ago Permalink

Thanks :)

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