{"id":90603,"date":"2022-06-19T19:28:28","date_gmt":"2022-06-19T17:28:28","guid":{"rendered":"https:\/\/rmarketingdigital.com\/wordpress\/consultas-sql-que-ahorran-tiempo-para-wordpress\/"},"modified":"2021-03-03T13:22:47","modified_gmt":"2021-03-03T16:22:47","slug":"consultas-sql-que-ahorran-tiempo-para-wordpress","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/fr\/wordpress\/consultas-sql-que-ahorran-tiempo-para-wordpress\/","title":{"rendered":"Requ\u00eates SQL rapides pour WordPress"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table des mati\u00e8res<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Basculer la table des mati\u00e8res\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Basculer<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/rmarketingdigital.com\/fr\/wordpress\/consultas-sql-que-ahorran-tiempo-para-wordpress\/#Primeros-pasos\" >Premiers pas<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/rmarketingdigital.com\/fr\/wordpress\/consultas-sql-que-ahorran-tiempo-para-wordpress\/#Reemplazar-URL\" >Remplacer l&#039;URL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/rmarketingdigital.com\/fr\/wordpress\/consultas-sql-que-ahorran-tiempo-para-wordpress\/#Crear-nuevo-usuario-administrador\" >Cr\u00e9er un nouvel utilisateur administrateur<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/rmarketingdigital.com\/fr\/wordpress\/consultas-sql-que-ahorran-tiempo-para-wordpress\/#Cambiar-nombre-de-usuario-de-inicio-de-sesion-de-administrador\" >Changer le nom d&#039;utilisateur de connexion administrateur<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/rmarketingdigital.com\/fr\/wordpress\/consultas-sql-que-ahorran-tiempo-para-wordpress\/#Cambiar-contrasena-de-administrador\" >Changer le mot de passe administrateur<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/rmarketingdigital.com\/fr\/wordpress\/consultas-sql-que-ahorran-tiempo-para-wordpress\/#Borrar-spam\" >Effacer le spam<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/rmarketingdigital.com\/fr\/wordpress\/consultas-sql-que-ahorran-tiempo-para-wordpress\/#Borrar-todos-los-comentarios-de-publicaciones-no-aprobados\" >Supprimer tous les commentaires sur les messages non approuv\u00e9s<\/a><\/li><\/ul><\/nav><\/div>\n<div class=\"container-med\">\n<div class=\"entry atype\">\n<p>Si vous \u00eates propri\u00e9taire d&#039;un site Web WordPress, il y a beaucoup de choses \u00e0 prendre en compte.<\/p>\n<p>Mettre \u00e0 jour constamment le contenu de votre blog, ajouter de nouveaux produits, changer les prix, et nous n&#039;avons m\u00eame pas mentionn\u00e9 les mises \u00e0 jour r\u00e9guli\u00e8res des plugins, donner acc\u00e8s \u00e0 un d\u00e9veloppeur et faire beaucoup plus dans le cadre de votre routine quotidienne WordPress.<\/p>\n<p>Parfois, si vous avez besoin de modifier les param\u00e8tres, vous trouverez un long didacticiel de page Web avec de nombreuses instructions pour effectuer une seule action. Mais que se passe-t-il si vous saviez que la plupart de ces changements peuvent \u00eatre modifi\u00e9s avec une simple requ\u00eate SQL, une commande que vous ex\u00e9cutez \u00e0 partir du menu de l&#039;administrateur de votre base de donn\u00e9es?<\/p>\n<p>Puisque vous \u00eates une personne occup\u00e9e et que gagner du temps est une priorit\u00e9, voici les requ\u00eates SQL de base qui vous aideront \u00e0 atteindre les r\u00e9sultats en quelques minutes.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Primeros-pasos\"><\/span>Premiers pas<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Lorsqu&#039;il y a plus d&#039;un site Web sur votre compte d&#039;h\u00e9bergement, avant d&#039;ex\u00e9cuter des requ\u00eates SQL, vous devez vous assurer que vous modifiez la base de donn\u00e9es correcte. Vous pouvez trouver le nom de la base de donn\u00e9es attribu\u00e9 \u00e0 une installation WordPress sp\u00e9cifique dans votre <em>wp-config.php<\/em> fichier en cha\u00eene:<\/p>\n<pre>define (&quot;DB_NAME&quot;, &quot;votre nomdb&quot;)<\/pre>\n<p><img alt='sql-define-db-name-6873583' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-define-db-name-6873583.png' width=\"737\" height=\"260\"><\/p>\n<p>Dans le m\u00eame temps, faites attention au pr\u00e9fixe de la table, car vous devrez le sp\u00e9cifier une fois que vous aurez ex\u00e9cut\u00e9 les commandes SQL. C&#039;est dans le m\u00eame fichier au bas des param\u00e8tres de la page.<\/p>\n<p><img alt='table-sql-refix-4670415' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-table-refix-4670415.png' width=\"657\" height=\"67\"><\/p>\n<p>Dans cet exemple ci-dessus, le nom de la base de donn\u00e9es est _wp622. Le pr\u00e9fixe de table est wpc7_. Maintenant que nous savons, passons \u00e0 l&#039;administrateur de la base de donn\u00e9es. La plupart des panneaux de contr\u00f4le utilisent PHPMyAdmin pour la gestion de la base de donn\u00e9es.<\/p>\n<p><img alt='sql-phpmyadmin-5270821' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-phpmyadmin-5270821.png' width=\"892\" height=\"215\"><\/p>\n<p>Une fois l\u00e0-bas, trouvez le nom de votre base de donn\u00e9es dans la liste et cliquez dessus:<\/p>\n<p><img alt='sql-phpmyadmin-select-db-2454817' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-phpmyadmin-select-db-2454817.png' width=\"1306\" height=\"625\"><\/p>\n<p>Avant d&#039;apporter des modifications, assurez-vous de cr\u00e9er une sauvegarde pour cette base de donn\u00e9es, afin de pouvoir la restaurer rapidement en cas de probl\u00e8me.<\/p>\n<p>Nous expliquons comment sauvegarder WordPress en d\u00e9tail dans notre guide de sauvegarde g\u00e9n\u00e9ral. Mais pour vous donner un petit tour d&#039;horizon, choisissez le <em>Exporter<\/em> option, choisissez la m\u00e9thode et le format en fonction de vos besoins et appuyez sur <em>Va<\/em> (ici nous avons configur\u00e9 toutes les options par d\u00e9faut):<\/p>\n<p><img alt='sql-phpmyadmin-export-db-2882786' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-phpmyadmin-export-db-2882786.png' width=\"910\" height=\"562\"><\/p>\n<p>Une fois que cela est fait, vous pouvez continuer. Appuyez sur le menu <em>SQL<\/em> et commen\u00e7ons:<\/p>\n<p><img alt='sql-db-menu-4391261' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-db-menu-4391261.jpg' width=\"1000\" height=\"285\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Reemplazar-URL\"><\/span>Remplacer l&#039;URL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Si vous pr\u00e9voyez de mettre \u00e0 jour l&#039;URL de votre site Web en ajoutant le certificat SSL \u00e0 votre site Web ou en apportant d&#039;autres modifications, veillez \u00e0 utiliser la commande suivante:<\/p>\n<pre class=\"prism-pre line-numbers language-sql\"><code class=\"language-sql\">UPDATE wp_options SET valeur_option = replace (valeur_option, &#039;http:\/\/www.oldurlofthewebsite.com&#039;, &#039;http:\/\/www.newurlofthewebsite.com&#039;) WHERE nom_option = &#039;home&#039; OU nom_option = &#039;siteurl&#039;;<\/code><\/pre>\n<p>Disons que je veux que mon URL soit https \/\/: et que mon nom de domaine soit example.com. Dans ce cas, je dois modifier le nom de la table wp_options et la m\u00eame URL:<\/p>\n<pre class=\"prism-pre line-numbers language-sql\"><code class=\"language-sql\">UPDATE wpc7_options SET option_value = replace (option_value, &#039;http:\/\/www.example.com&#039;, &#039;https:\/\/www.example.com&#039;) WHERE nom_option = &#039;home&#039; OU nom_option = &#039;siteurl&#039;;<\/code><\/pre>\n<p><img alt='sql-replace-sitename-7368149' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-replace-sitename-7368149.jpg' width=\"1000\" height=\"291\"><\/p>\n<p>Et attendez un message de r\u00e9ussite.<\/p>\n<p><img alt='sql-success-message-9588188' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-success-message-9588188.png' width=\"1199\" height=\"97\"><\/p>\n<p>Pourquoi est-ce si important de le voir? Si vous appuyez sur <em>Va<\/em> Mais il y a des erreurs dans la requ\u00eate, le syst\u00e8me ne sera pas en mesure de r\u00e9pondre \u00e0 la demande et vous obtiendrez des erreurs qui signifient que l&#039;ex\u00e9cution a \u00e9chou\u00e9. L&#039;erreur ressemblera \u00e0 ceci et indiquera la raison pour laquelle le processus a \u00e9chou\u00e9.<\/p>\n<p><img alt='message-d&#039;erreur-sql-9853633' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-error-message-9853633.png' width=\"1237\" height=\"248\"><\/p>\n<p>Notez que cette commande est basique et ne remplacera que l&#039;URL principale de votre site Web, donc si vous pr\u00e9voyez de changer le nom de domaine de votre site Web de example.com \u00e0 test.net, vous devrez le modifier en incluant toutes les tables o\u00f9 il se trouve l&#039;url de votre site Web comme wp-posts, wp-postmeta et en m\u00eame temps soyez prudent avec les tableaux avec des lignes contenant des URL g\u00e9n\u00e9r\u00e9es par le plugin (par exemple WooCommerce).<\/p>\n<p>Pour ce faire, vous aurez besoin d&#039;au moins <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/www.udemy.com\/topic\/sql\">formation SQL de base<\/a>. Une autre option serait d&#039;ouvrir la base de donn\u00e9es que vous avez export\u00e9e dans n&#039;importe quel \u00e9diteur de texte et avec Ctrl + H remplacer toutes les mentions de votre ancien domaine par le nouveau. Si cela semble trop compliqu\u00e9, il existe une gamme d&#039;autres outils qui aident \u00e0 automatiser cette op\u00e9ration (comme le <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/interconnectit.com\/products\/search-and-replace-for-wordpress-databases\/\">interconnecter \/ rechercher et remplacer la base de donn\u00e9es<\/a> script, ou le <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/wordpress.org\/plugins\/better-search-replace\/\">Meilleur plugin de recherche et de remplacement<\/a> bas\u00e9 sur le m\u00eame script) tout en t\u00e9l\u00e9chargeant simplement le fichier dans le dossier de votre site Web pour le site d&#039;emploi et en l&#039;ouvrant dans un navigateur.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Crear-nuevo-usuario-administrador\"><\/span>Cr\u00e9er un nouvel utilisateur administrateur<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Si vous devez ajouter un nouvel utilisateur avec un r\u00f4le d&#039;administrateur \u00e0 votre installation, vous devrez utiliser la commande suivante et la modifier selon vos pr\u00e9f\u00e9rences:<\/p>\n<pre class=\"prism-pre line-numbers language-sql\"><code class=\"language-sql\">INSERT INTO `wp_users` (` user_login`, `user_pass`,` user_nicename`, `user_email`,` user_status`) VALUES (&#039;yourlogin&#039;, MD5 (&#039;yourpassword&#039;), &#039;firstname lastname&#039;, &#039;email@example.com &#039;,&#039; 0 &#039;); INSERT INTO `wp_usermeta` (` umeta_id`, `user_id`,` meta_key`, `meta_value`) VALUES (NULL, (Select max (id) FROM wp_users), &#039;wp_capabilities&#039;, &#039;a: 1: {s: 13: &quot;administrateur&quot;; s: 1: &quot;1&quot;;} &#039;); INSERT INTO `wp_usermeta` (` umeta_id`, `user_id`,` meta_key`, `meta_value`) VALUES (NULL, (S\u00e9lectionnez max (id) FROM wp_users), &#039;wp_user_level&#039;, &#039;10&#039;);<\/code><\/pre>\n<p>Notez que vous devrez modifier les tables et les valeurs de connexion en fonction de votre <strong>nom d&#039;utilisateur<\/strong> y <strong>base de donn\u00e9es<\/strong>.<\/p>\n<p>Je veux cr\u00e9er un utilisateur <em>mon d\u00e9veloppeur<\/em> avec le mot de passe <em>mon mot de passe<\/em>, le nom de mon d\u00e9veloppeur est <em>John Doe<\/em> et l&#039;e-mail est <em>test@test.com<\/em>. Ma requ\u00eate ressemblera donc \u00e0 ceci:<\/p>\n<pre class=\"prism-pre line-numbers language-sql\"><code class=\"language-sql\">INS\u00c9RER DANS `wpc7_users` (` user_login`, `user_pass`,` user_nicename`, `user_email`,` user_status`) VALUES (&#039;Mydev&#039;, MD5 (&#039;mypassword&#039;), &#039;John Doe&#039;, &#039;test@test.com &#039;,&#039; 0 &#039;); INSERT INTO `wpc7_usermeta` (` umeta_id`, `user_id`,` meta_key`, `meta_value`) VALUES (NULL, (Select max (id) FROM wp_users), &#039;wp_capabilities&#039;, &#039;a: 1: {s: 13: &quot;administrateur&quot;; s: 1: &quot;1&quot;;} &#039;); INS\u00c9RER DANS `wpc7_usermeta` (` umeta_id`, `user_id`,` meta_key`, `meta_value`) VALUES (NULL, (Select max (id) FROM wpc7_users), &#039;wp_user_level&#039;, &#039;10&#039;<\/code><\/pre>\n<p><img alt='sql-create-new-user-1388785' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-create-new-user-1388785.png' width=\"1600\" height=\"414\"><\/p>\n<p>Notez que je n&#039;ai pas besoin de modifier les noms de lignes (en d&#039;autres termes, <em>wp_user_level<\/em> ou jouer avec les nombres <em>0, 10, 13<\/em> puisqu&#039;ils font r\u00e9f\u00e9rence au r\u00f4le d&#039;utilisateur et aux droits correspondants. Une fois termin\u00e9, j&#039;appuie sur <em>Va<\/em>.<\/p>\n<p>La sortie doit afficher des r\u00e9sultats r\u00e9ussis comme suit:<\/p>\n<p><img alt='sql-create-new-user-results-1263047' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-create-new-user-results-1263047.png' width=\"1600\" height=\"466\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cambiar-nombre-de-usuario-de-inicio-de-sesion-de-administrador\"><\/span>Changer le nom d&#039;utilisateur de connexion administrateur<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Pour changer le nom de connexion du nom d&#039;utilisateur, revenez dans l&#039;onglet MySQL et ex\u00e9cutez la commande suivante:<\/p>\n<pre class=\"prism-pre line-numbers language-sql\"><code class=\"language-sql\">UPDATE wp_users SET user_login = &#039;newlogin&#039; WHERE user_login = &#039;admin&#039;;<\/code><\/pre>\n<p>Disons que votre nom d&#039;utilisateur par d\u00e9faut est <em>mon d\u00e9veloppeur<\/em>, celui que vous avez cr\u00e9\u00e9 avant et que vous souhaitez configurer <em>utilisateur s\u00fbr<\/em> plut\u00f4t. Dans notre cas particulier, nous ex\u00e9cutons la commande suivante, car en m\u00eame temps nous avons le pr\u00e9fixe par d\u00e9faut wp7c_:<\/p>\n<pre class=\"prism-pre line-numbers language-sql\"><code class=\"language-sql\">UPDATE wpc7_users_users SET user_login = &#039;secureuser&#039; WHERE user_login = &#039;mydeveloper&#039;;<\/code><\/pre>\n<p><img alt='sql-change-wp-username-2210462' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-change-wp-username-2210462.png' width=\"1600\" height=\"413\"><\/p>\n<p>Le r\u00e9sultat r\u00e9ussi se pr\u00e9sente comme suit:<\/p>\n<p><img alt='sql-change-wp-username-success-9370193' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-change-wp-username-success-9370193.png' width=\"847\" height=\"205\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cambiar-contrasena-de-administrador\"><\/span>Changer le mot de passe administrateur<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>En suivant les r\u00e8gles de s\u00e9curit\u00e9 des changements de mot de passe r\u00e9guliers, vous pouvez en m\u00eame temps vouloir changer le mot de passe de votre <em>utilisateur s\u00fbr<\/em>. Voici la requ\u00eate pour cela:<\/p>\n<pre class=\"prism-pre line-numbers language-sql\"><code class=\"language-sql\">UPDATE wp_users SET user_pass = MD5 (&#039;new_password&#039;) WHERE user_login = &#039;youruser&#039;;<\/code><\/pre>\n<p>Pour cette commande de changement de mot de passe particuli\u00e8re, notre commande est la suivante:<\/p>\n<pre class=\"prism-pre line-numbers language-sql\"><code class=\"language-sql\">UPDATE wpc7_users SET user_pass = MD5 (&#039;$tR0ngP @ s$w03D&#039;) WHERE user_login = &#039;secureuser&#039;;<\/code><\/pre>\n<p><img alt='sql-change-admin-pw-7050022' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-change-admin-pw-7050022.png' width=\"1600\" height=\"415\"><\/p>\n<p>presse <em>Va<\/em> et attendez le message de r\u00e9ussite:<\/p>\n<p><img alt='sql-change-admin-pw-success-3161969' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-change-admin-pw-success-3161969.png' width=\"833\" height=\"162\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Borrar-spam\"><\/span>Effacer le spam<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Pour les utilisateurs qui publient beaucoup de messages et laissent les commentaires ouverts \u00e0 l&#039;interaction, le probl\u00e8me des commentaires de spam peut devenir vraiment douloureux. M\u00eame si vous pouvez filtrer les commentaires par approbation manuelle, vous souhaitez probablement trouver un moyen de supprimer rapidement tout ce que vous n&#039;avez pas approuv\u00e9. Voil\u00e0 comment:<\/p>\n<pre class=\"prism-pre line-numbers language-sql\"><code class=\"language-sql\">SUPPRIMER DE wp_comments WHERE wp_comments.comment_approved = &#039;spam&#039;;<\/code><\/pre>\n<p>Lorsqu&#039;il est personnalis\u00e9 pour le cas particulier, nous discutons ici:<\/p>\n<pre class=\"prism-pre line-numbers language-sql\"><code class=\"language-sql\">SUPPRIMER DE wpc7_comments WHERE wpc7_comments.comment_approved = &#039;spam&#039;;<\/code><\/pre>\n<p><img alt='sql-delete-spam-9071402' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-delete-spam-9071402.png' width=\"1600\" height=\"433\"><\/p>\n<p><strong>Noter<\/strong>: le pr\u00e9fixe doit \u00eatre modifi\u00e9 aux deux endroits o\u00f9 il se trouve, car <em>wp_comments.comment_approved<\/em> est le champ s\u00e9par\u00e9 du tableau.<\/p>\n<p>Voici le r\u00e9sultat r\u00e9ussi:<\/p>\n<p><img alt='sql-delete-spam-success-4936391' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-delete-spam-sucess-4936391.png' width=\"815\" height=\"110\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Borrar-todos-los-comentarios-de-publicaciones-no-aprobados\"><\/span>Supprimer tous les commentaires sur les messages non approuv\u00e9s<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u00c0 un moment donn\u00e9, vous constaterez peut-\u00eatre que vous \u00eates fatigu\u00e9 de filtrer et de lire les commentaires sur les articles avant de prendre la d\u00e9cision finale de les publier, vous souhaitez donc les supprimer. Il existe une commande pour cela:<\/p>\n<pre class=\"prism-pre line-numbers language-sql\"><code class=\"language-sql\">SUPPRIMER DE wp_comments WHERE comment_approved = 0<\/code><\/pre>\n<p>Notez que le <em>comment_approved<\/em> La section n&#039;a pas besoin de modification car cet onglet repr\u00e9sente la fonction par d\u00e9faut dans la table qui est immuable.<\/p>\n<p>La commande modifi\u00e9e ressemble \u00e0 ceci:<\/p>\n<pre class=\"prism-pre line-numbers language-sql\"><code class=\"language-sql\">SUPPRIMER DE wpc7_comments WHERE comment_approved = 0<\/code><\/pre>\n<p><img alt='sql-delete-comments-8243094' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-delete-comments-8243094.png' width=\"1600\" height=\"407\"><\/p>\n<p>Une fois cela fait, vous pouvez voir la sortie habituelle des commandes ex\u00e9cut\u00e9es avec succ\u00e8s:<\/p>\n<p><img alt='sql-delete-comments-success-4521332' loading=\"lazy\" class=\"alignnone\" src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-delete-comments-success-4521332.png' width=\"789\" height=\"91\"><\/p>\n<hr>\n<p>Bien qu&#039;il puisse sembler que suivre les instructions peut prendre plus de temps que de simplement faire les choses manuellement, ce n&#039;est pas le cas. Plus votre site Web est grand, plus vous avez de temps \u00e0 y consacrer. Une seule action effectu\u00e9e s\u00e9par\u00e9ment pour 10 messages et vous vous retrouvez avec 10 fois plus de temps pass\u00e9 \u00e0 ex\u00e9cuter.<\/p>\n<p>En fait, vous \u00e9conomisez une tonne de votre temps pr\u00e9cieux en ex\u00e9cutant ces commandes, et vous pouvez utiliser ce temps sur des choses plus importantes, comme la planification de contenu ou la recherche d&#039;id\u00e9es inspirantes.<\/p>\n<p>Bon blogging!<\/p>\n<\/div>\n<p><script type=\"application\/ld+json\">{\n    \"@context\": \"http:\\\/\\\/schema.org\",\n    \"@type\": \"BlogPosting\",\n    \"mainEntityOfPage\": {\n        \"@type\": \"WebPage\",\n        \"@id\": \"https:\\\/\\\/www.wpexplorer.com\\\/sql-queries-wordpress\\\/\"\n    },\n    \"headline\": \"Time Saving SQL Queries for WordPress\",\n    \"image\": {\n        \"@type\": \"ImageObject\",\n        \"url\": \"https:\\\/\\\/www.wpexplorer.com\\\/wp-content\\\/uploads\\\/sql-wordpress-queries-tips.jpg\",\n        \"width\": 1000,\n        \"height\": 503\n    },\n    \"datePublished\": \"2020-05-05T14:47:01-06:00\",\n    \"dateModified\": \"2020-05-05T14:47:01-06:00\",\n    \"author\": {\n        \"type\": \"Person\",\n        \"name\": \"StewartDunlop\"\n    },\n    \"publisher\": {\n        \"@type\": \"Organization\",\n        \"name\": \"R Marketing Digital\",\n        \"logo\": {\n            \"@type\": \"ImageObject\",\n            \"url\": \"https:\\\/\\\/www.wpexplorer.com\\\/wp-content\\\/themes\\\/wpexplorer\\\/images\\\/wpexplorer-organization-logo.png\",\n            \"width\": 400,\n            \"height\": 60\n        }\n    },\n    \"description\": \"Save time with these SQL queries for WordPress. The commands can help you manage your website efficiently freeing up time for other important tasks.\"\n}<\/script><\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Si es propietario de un sitio web de WordPress, hay muchas cosas de las que ocuparse. Actualizando constantemente el contenido de su blog, agregando nuevos productos, cambiando los precios, y&#8230;<\/p>","protected":false},"author":1,"featured_media":90604,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1351],"tags":[],"class_list":["post-90603","post","type-post","status-publish","format-standard","has-post-thumbnail","category-wordpress"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.0 (Yoast SEO v28.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Consultas SQL que ahorran tiempo para WordPress - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"Si es propietario de un sitio web de WordPress, hay muchas cosas de las que ocuparse. Actualizando constantemente el contenido de su blog, agregando\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/rmarketingdigital.com\/fr\/wordpress\/time-saving-sql-queries-for-wordpress\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Consultas SQL que ahorran tiempo para WordPress\" \/>\n<meta property=\"og:description\" content=\"Si es propietario de un sitio web de WordPress, hay muchas cosas de las que ocuparse. Actualizando constantemente el contenido de su blog, agregando\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/fr\/wordpress\/time-saving-sql-queries-for-wordpress\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-19T17:28:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-wordpress-queries-tips-8889502.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"503\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"R Marketing Digital\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/wordpress\\\/time-saving-sql-queries-for-wordpress\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/wordpress\\\/time-saving-sql-queries-for-wordpress\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Consultas SQL que ahorran tiempo para WordPress\",\"datePublished\":\"2022-06-19T17:28:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/wordpress\\\/time-saving-sql-queries-for-wordpress\\\/\"},\"wordCount\":1312,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/wordpress\\\/time-saving-sql-queries-for-wordpress\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/sql-wordpress-queries-tips-8889502.jpg\",\"articleSection\":[\"Wordpress\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/wordpress\\\/time-saving-sql-queries-for-wordpress\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/wordpress\\\/time-saving-sql-queries-for-wordpress\\\/\",\"name\":\"Consultas SQL que ahorran tiempo para WordPress - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/wordpress\\\/time-saving-sql-queries-for-wordpress\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/wordpress\\\/time-saving-sql-queries-for-wordpress\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/sql-wordpress-queries-tips-8889502.jpg\",\"datePublished\":\"2022-06-19T17:28:28+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"Si es propietario de un sitio web de WordPress, hay muchas cosas de las que ocuparse. Actualizando constantemente el contenido de su blog, agregando\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/wordpress\\\/time-saving-sql-queries-for-wordpress\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/en\\\/wordpress\\\/time-saving-sql-queries-for-wordpress\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/sql-wordpress-queries-tips-8889502.jpg\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/sql-wordpress-queries-tips-8889502.jpg\",\"width\":1000,\"height\":503,\"caption\":\"sql-wordpress-queries-tips-8889502-4351895-jpg\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/\",\"name\":\"R Marketing Digital\",\"description\":\"Agencia SEO | Publicidad redes sociales | Community Management\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/rmarketingdigital.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\",\"name\":\"R Marketing Digital\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"caption\":\"R Marketing Digital\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Consultas SQL que ahorran tiempo para WordPress - R Marketing Digital","description":"Si vous \u00eates propri\u00e9taire d&#039;un site Web WordPress, il y a beaucoup de choses \u00e0 prendre en compte. Mettre \u00e0 jour constamment le contenu de votre blog, en ajoutant","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/rmarketingdigital.com\/fr\/wordpress\/time-saving-sql-queries-for-wordpress\/","og_locale":"fr_FR","og_type":"article","og_title":"Consultas SQL que ahorran tiempo para WordPress","og_description":"Si es propietario de un sitio web de WordPress, hay muchas cosas de las que ocuparse. Actualizando constantemente el contenido de su blog, agregando","og_url":"https:\/\/rmarketingdigital.com\/fr\/wordpress\/time-saving-sql-queries-for-wordpress\/","og_site_name":"R Marketing Digital","article_published_time":"2022-06-19T17:28:28+00:00","og_image":[{"width":1000,"height":503,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-wordpress-queries-tips-8889502.jpg","type":"image\/jpeg"}],"author":"R Marketing Digital","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/rmarketingdigital.com\/en\/wordpress\/time-saving-sql-queries-for-wordpress\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/en\/wordpress\/time-saving-sql-queries-for-wordpress\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Consultas SQL que ahorran tiempo para WordPress","datePublished":"2022-06-19T17:28:28+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/en\/wordpress\/time-saving-sql-queries-for-wordpress\/"},"wordCount":1312,"image":{"@id":"https:\/\/rmarketingdigital.com\/en\/wordpress\/time-saving-sql-queries-for-wordpress\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-wordpress-queries-tips-8889502.jpg","articleSection":["Wordpress"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/en\/wordpress\/time-saving-sql-queries-for-wordpress\/","url":"https:\/\/rmarketingdigital.com\/en\/wordpress\/time-saving-sql-queries-for-wordpress\/","name":"Consultas SQL que ahorran tiempo para WordPress - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/en\/wordpress\/time-saving-sql-queries-for-wordpress\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/en\/wordpress\/time-saving-sql-queries-for-wordpress\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-wordpress-queries-tips-8889502.jpg","datePublished":"2022-06-19T17:28:28+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"Si vous \u00eates propri\u00e9taire d&#039;un site Web WordPress, il y a beaucoup de choses \u00e0 prendre en compte. Mettre \u00e0 jour constamment le contenu de votre blog, en ajoutant","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/en\/wordpress\/time-saving-sql-queries-for-wordpress\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/rmarketingdigital.com\/en\/wordpress\/time-saving-sql-queries-for-wordpress\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-wordpress-queries-tips-8889502.jpg","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/sql-wordpress-queries-tips-8889502.jpg","width":1000,"height":503,"caption":"sql-wordpress-queries-tips-8889502-4351895-jpg"},{"@type":"WebSite","@id":"https:\/\/rmarketingdigital.com\/#website","url":"https:\/\/rmarketingdigital.com\/","name":"Marketing num\u00e9rique","description":"Agence de r\u00e9f\u00e9rencement | Publicit\u00e9 sur les r\u00e9seaux sociaux | Gestion de communaut\u00e9","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/rmarketingdigital.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e","name":"Marketing num\u00e9rique","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","caption":"R Marketing Digital"}}]}},"_links":{"self":[{"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/posts\/90603","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/comments?post=90603"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/posts\/90603\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/media\/90604"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/media?parent=90603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/categories?post=90603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/fr\/wp-json\/wp\/v2\/tags?post=90603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}