Sql使用重复键插入

Question

Ok so, im still a beginner in databases. i have this code

$sql="INSERT INTO complaints_members(password, complaint) VALUES ('$mypassword','$submit') ON DUPLICATE KEY UPDATE complaint='$submit' ; ";

This simply updates my complaint in the existing entry. How can i insert a new entry with the same key, instead of updating the old one?

Im thinking of it like this.

1st entry is like

Password : 123

Complaint : abc

2nd would be like

Password : 123

Complaint : def

Im not very familiar with the terms of SQL, so i'm sorry in advance, and thanks for your time.

EDIT: This is how the tables are

Answer 1

You can't have duplicate primary keys in a database. This is intentional.

Instead, consider re-designing your database so that each complaint has a unique ID (AKA a Primary Key). You should set it as something like complaint_id or simply id, and make it a PK (Primary Key) and AI (Auto-Increment). That way, when you do inserts you won't have to worry about updating the same row.