Database, Data Engineering, Dbms, Data Modeling, Data Management.
the table. For that sake, you can create a Unique Key table for the same data, but add an auto_id field and set it as the primary key. CREATE TABLE loan_records ( `auto_id` BIGINT NOT NULL AUTO_INCREMENT, `user_id` VARCHAR(20) DEFAULT NULL COMMENT 'Customer ID', `loan_amount` DECIMAL(10, 2) DEFAULT