Question: (I am learning MySQL and PHP) I want to create a MySQL table with repetitive primary keys on mac system.
I have CSV file like following with over 1000 rows;
and I tried following commands:
create table new ( P VARCHAR(8) int NOT NULL AUTO_INCREMENT primary key, P VARCHAR(8), Pposition VARCHAR(30), Ptype VARCHAR(30)) ENGINE=InnoDB;
load data local infile '/Users/admin/Desktop/ab.csv' INTO TABLE new COLUMNS TERMINATED BY';';
Query OK, 1 row affected, 1 warning (0.03 sec)
Records: 1 Deleted: 0 Skipped: 0 Warnings: 1
Can you please suggest me the right and efficient way to solve this problem. Thanks !