Article ID: 113380, created on Feb 27, 2012, last review on Apr 25, 2014

  • Applies to:
  • Plesk 10.x for Linux
  • Plesk 10.x for Windows

Resolución

Para anular la suspensión de clientes a la vez, siga los pasos detallados a continuación.

1. Compruebe cuántos clientes están suspendidos:
mysql> select count(*) from clients where status=1;
+----------+
| count(*) |
+----------+
|       88 |
+----------+
1 row in set (0.00 sec)

2. Ejecute la consulta para la actualización masiva de los detalles de estado del cliente:
 
mysql> update clients set status=0 where status=1;  
Query OK, 88 rows affected (0.01 sec)
Rows matched: 88  Changed: 88  Warnings: 0

dd0611b6086474193d9bf78e2b293040 a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 c796c01d6951fa24ed54c7f1111667c6 85a92ca67f2200d36506862eaa6ed6b8 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF