This page was exported from GTUTO [ https://www.gtuto.com ]

Export date:Fri Apr 26 22:28:07 2024 / +0000 GMT

___________________________________________________


Title: MYSQL modifie toutes les tables d'une base

---------------------------------------------------



USE INFORMATION_SCHEMA;
SELECT 
CONCAT("ALTER TABLE ", TABLE_SCHEMA ,".", TABLE_NAME, "ENGINE=MEMORY;") 
AS MySQLCMD FROM TABLES 
WHERE TABLE_SCHEMA = "MA_BASE";



Liste tous les champs d'une table dans un tableau PHP



USE INFORMATION_SCHEMA;
SELECT 
CONCAT('$variable["', COLUMN_NAME ,'"]') 
FROM COLUMNS 
WHERE TABLE_SCHEMA = "mabase" AND TABLE_NAME='matable';


---------------------------------------------------


Images: 

---------------------------------------------------




---------------------------------------------------


Post date: 2020-05-24 00:47:47

Post date GMT: 2020-05-24 00:47:47

Post modified date: 2021-02-08 02:15:16

Post modified date GMT: 2021-02-08 02:15:16



____________________________________________________________________________________________


Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com