Hello, as mentioned in the title, I have this message ( Duplicate of field '0' for key 1 ) that appears after executing my query, but I can't see where the error is coming from because I don't believe there is a duplicate, and especially what key 1 refers to.. Thank you for your help

Hello, you must NOT set the auto_increment field... so -> either you set it to NULL -> or you use the syntax: INSERT INTO Clients SET nom="$nom", prenom="$prenom", ... WITHOUT setting the Id... PS Also be careful to properly escape quotes and others if you are in php: see mysql_real_escape_string, mysql_escape_string, addslashes, ... Good luck!

It was displayed correctly, I went to "show" in phpMyAdmin and I found my client, I'm proud of myself^^ Thank you for your help :) Now all I have left to do is display the list of clients...

View original (French)

[SQL] Duplicate field '0' for key 1 - Page 2

Solved

Answer 21 / 21
Absot Posted messages 819 Status Member 44

It was displayed correctly, I went to "show" in phpMyAdmin and I found my client, I'm proud of myself^^

Thank you for your help :)

Now all I have left to do is display the list of clients...
0

Latest Discussions

More details

at 21:09
Canon mg5150 printer installation on windows 11

at 21:08
How to install a hard drive on my wi-fi router

at 21:05
My pc boots into bios with windows 11

at 20:38
No tone on my redmi note 13 pro 5g

at 19:19
Trojan horse

at 19:13
Vba macro repeat action until end of document

at 18:40
Message about "new ways to communicate"

at 18:26
Problem with directx 12 - steam game launch

at 17:30
Rakuten plans to close its operations in france by the end of 2026

at 17:16

Other languages

🇪🇸 Español
🇫🇷 Français