Bonjour
Je souhaiterai supprimer beaucoup de ligne d'un seul coup dans les clients,
car j'ai importé un fichier excel dans les clients et, toutes mes lignes sont vides.
Je pense que le format ne fonctionne pas et j'ai 5000 lignes a supprimer
Pouvez vous m'aider svp
Merci
:unsure:
Please post in english
Sorry,
Hello
I should cancel a lot of line at one time
Because I import a file excel with a lot of cutomers.
And my projeqtor is empty.
I have 5026 line empty
Thank you
Hi,
Customer has no specific action on insert.
So if yu're sure you did not use these elements, you can delete them in database :
delete from client;
will erase all customers.
but if you just want to target on specific range of ids :
delete from client where id>=xx and id<=yy;
will erase clients with ids from xx to yy.
Thank you 🙂
I think this solution is good:
but if you just want to target on specific range of ids :
DELETE FROM client WHERE id>=xx AND id=0001 AND id<=5065
SyntaxError: missing ; before statement
Help me please
Hi,
You need a db management tool.
Best I recommand : phpMyAdmin.
But you can also use toad for MySql or mysql line command (for advanced users)