# 1089 Error while creating table in phpMyAdmin
While creating the table, I get the error # 1089 - Invalid prefix key.
My sql code:
CREATE TABLE `buildblockz`.`db_user_info` ( `BBZUID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'User' Id' , `username` VARCHAR(255) NOT NULL COMMENT 'User' username' , `password` VARCHAR(255) NOT NULL COMMENT 'User' password' , `fname` VARCHAR(255) NOT NULL COMMENT 'User' First Name' , `mname` VARCHAR(255) NULL COMMENT 'User' Middle Name' , `lname` VARCHAR(255) NOT NULL COMMENT 'User' Last Name' , `line1` VARCHAR(255) NOT NULL COMMENT 'User' Address Line 1' , `line2` VARCHAR(255) NULL COMMENT 'User' Address Line 2' , `city` VARCHAR(255) NOT NULL COMMENT 'User' Address City' , `state` VARCHAR(255) NOT NULL COMMENT 'User' Address State' , `pincode` INT(11) UNSIGNED NOT NULL COMMENT 'User' Address Pincode' , `email` VARCHAR(255) NOT NULL COMMENT 'User' Contact Email' , `mobile` INT(11) UNSIGNED NULL COMMENT 'User' Contact Mobile' , `phone` INT(11) UNSIGNED NULL COMMENT 'User' Contact Phone' , `sex` ENUM('M','F','NS') NOT NULL COMMENT 'User' Sex' , `dateOfBirth` DATE NOT NULL COMMENT 'User' Date of Birth' , `designation` VARCHAR(255) NULL COMMENT 'User' Designation' , `dateOfEntry` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'User' Date of Entry' , PRIMARY KEY (`BBZUID`(9)) , UNIQUE (`username`(30)) ) ENGINE = InnoDB COMMENT = 'User' Database';
+3
source to share