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 TABLE
users(
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 INDEX
phoneUni(
phone) USING BTREE, UNIQUE INDEX
autHUni(
auth_hash) USING BTREE ) COLLATE='utf8_general_ci' ENGINE=InnoDB AUTO_INCREMENT=7 ;