kdevtmpfsi kinsing docker php-fpm

docker ps
docker exec -it nom_de_la_vm /bin/bash
cd /tmp
ls  #-> vérifier si kdevtmpfsi et kinsing
kill -9 $(pidof kdevtmpfsi)
kill -9 $(pidof kinsing)
rm -f /tmp/kdevtmpfsi ; echo "prend_la_place" > /tmp/kdevtmpfsi
rm -f /var/tmp/kinsing ; echo "prend_la_place" > /var/tmp/kinsing
rm -f /tmp/zzz ; echo "prend_la_place" > /tmp/zzz
rm -f /tmp/zzz.sh ; echo "prend_la_place" > /tmp/zzz.sh

# nouvelles variantes solution provisoire
#*******************************************
docker exec -it nom_de_la_vm /bin/bash
apt-get update
apt-get remove curl
dans  /home/tt.sh
pkill kdevtmpfsi
pkill kinsing
rm /tmp/kdevtmpfsi*
rm /tmp/kinsing*
rm /var/tmp/kdevtmpfsi*
rm /var/tmp/kinsing*

chmod 0744 /home/tt.sh

crontab -e
0 */5 * * * /home/tt.sh

#************************************

TVA <--> TTC <--> HT

TVA TAUX
HT
TVA
TTC

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';