Build a query in a string variable and then submit it using MySQL’s prepared statement functionality. (see:
SELECT GROUP_CONCAT ( CONCAT ( "SELECT FROM `" , SCHEMA_NAME , "`.`cms_users` WHERE `email` LIKE '%admin.bilsi%'" ) SEPARATOR ' UNION ALL ' )
INTO @ stmt_sql
FROM INFORMATION_SCHEMA . SCHEMATA
WHERE SCHEMA_NAME NOT IN ( 'mysql' , 'test' , 'tmp' );
PREPARE stmt FROM @ stmt_sql ;
EXECUTE stmt ;
DEALLOCATE PREPARE stmt ;
Setting default value for a BASH variable
To set a default value for a BASH variable (good for setting default value for a BASH command line parameter) the syntax is:
#Set VARIABLE with the value of 1st Arg to the script,
#If 1st arg is not entered, set it to DEFAULTVALUE
echo "$(</dev/stdin)" > /tmp/file
Terminate your input with
Here’s a quick ad spot I made for a gutter installer.
A friend invited me to do a work trade at her hotel,
Casa Linda, in Manuel Antonio, Costa Rica. This is a promo video ad I made for her from the drone footage and photos that I took while on the trip.
This frame was commissioned specifically for the
Miles Toland painting “WATER IS LIFE” that it surrounds. I took elements from the painting and integrated them into the design of the frame.
Constructing the compound miter joints
New laser cut “Mandala of Intuition” lattice box frame design is done!
Cutting frame pieces on the laser Gluing the large frame
New laser cut flower of life lattice box frame design is done!