View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Supprimer de nombreux clients - ProjeQtOr
 
 

Supprimer de nombreux clients

More
22 Feb 2016 17:08 #1 by Christophe37
Supprimer de nombreux clients was created by Christophe37
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 Log in or Create an account to join the conversation.

More
22 Feb 2016 17:09 #2 by babynus
Replied by babynus on topic Supprimer de nombreux clients
Please post in english
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
23 Feb 2016 09:04 #3 by Christophe37
Replied by Christophe37 on topic Supprimer de nombreux clients
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

Please Log in or Create an account to join the conversation.

More
23 Feb 2016 09:30 #4 by babynus
Replied by babynus on topic Supprimer de nombreux clients
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.
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
23 Feb 2016 12:22 - 23 Feb 2016 17:59 #5 by Christophe37
Replied by Christophe37 on topic Supprimer de nombreux clients
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<=yy;
will erase clients with ids from xx to yy.

But i don't know to write this text.

Can you telle me a solution please?


I think a solution in a console.
I write this message and an error arrive
DELETE FROM client WHERE id>=0001 AND id<=5065
SyntaxError: missing ; before statement


Help me please
Last edit: 23 Feb 2016 17:59 by Christophe37. Reason: modification

Please Log in or Create an account to join the conversation.

More
24 Feb 2016 18:34 #6 by babynus
Replied by babynus on topic Supprimer de nombreux clients
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)
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.053 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form