« FAQ:PB DEFINER MySQL MARIADB » : différence entre les versions
Page créée avec « Requête de génération de l'ordre (à adapter au besoin) : SELECT CONCAT("ALTER DEFINER='dbsqware_user'@'localhost' VIEW ", table_name, " AS ", view_definition, ";") F... » |
mAucun résumé des modifications |
||
| Ligne 4 : | Ligne 4 : | ||
SELECT CONCAT("ALTER DEFINER='dbsqware_user'@'localhost' VIEW ", table_name, " AS ", view_definition, ";") FROM information_schema.views WHERE table_schema='dbsqware_db'; | SELECT CONCAT("ALTER DEFINER='dbsqware_user'@'localhost' VIEW ", table_name, " AS ", view_definition, ";") FROM information_schema.views WHERE table_schema='dbsqware_db'; | ||
Exemple de requête générée | Exemple de requête générée | ||
ALTER DEFINER='dbsqware_user'@'localhost' VIEW ` | ALTER DEFINER='dbsqware_user'@'localhost' VIEW `v_StorageType` AS select `dbsqware_db`.`tsqwora_Datafiles`.`dbalias` AS `dbalias`,sum(case when locate('+',`dbsqware_db`.`tsqwora_Datafiles`.`file_name`) <> 0 then `dbsqware_db`.`tsqwora_Datafiles`.`size_dbf` else 0 end) AS `sizeAsm`,sum(case when locate('/ZDATA/',`dbsqware_db`.`tsqwora_Datafiles`.`file_name`) <> 0 then `dbsqware_db`.`tsqwora_Datafiles`.`size_dbf` else 0 end) AS `sizeZfs`,sum(`dbsqware_db`.`tsqwora_Datafiles`.`size_dbf`) AS `size_dbf`,max(`dbsqware_db`.`tsqwora_Datafiles`.`gather_date`) AS `gather_date` from `tsqwora_Datafiles` group by `dbsqware_db`.`tsqwora_Datafiles`.`dbalias`; | ||
Version du 18 février 2025 à 10:33
Requête de génération de l'ordre (à adapter au besoin) :
SELECT CONCAT("ALTER DEFINER='dbsqware_user'@'localhost' VIEW ", table_name, " AS ", view_definition, ";") FROM information_schema.views WHERE table_schema='dbsqware_db';
Exemple de requête générée ALTER DEFINER='dbsqware_user'@'localhost' VIEW `v_StorageType` AS select `dbsqware_db`.`tsqwora_Datafiles`.`dbalias` AS `dbalias`,sum(case when locate('+',`dbsqware_db`.`tsqwora_Datafiles`.`file_name`) <> 0 then `dbsqware_db`.`tsqwora_Datafiles`.`size_dbf` else 0 end) AS `sizeAsm`,sum(case when locate('/ZDATA/',`dbsqware_db`.`tsqwora_Datafiles`.`file_name`) <> 0 then `dbsqware_db`.`tsqwora_Datafiles`.`size_dbf` else 0 end) AS `sizeZfs`,sum(`dbsqware_db`.`tsqwora_Datafiles`.`size_dbf`) AS `size_dbf`,max(`dbsqware_db`.`tsqwora_Datafiles`.`gather_date`) AS `gather_date` from `tsqwora_Datafiles` group by `dbsqware_db`.`tsqwora_Datafiles`.`dbalias`;