Categories
Mastering Development

Mysql query loop, resulting row of one query in where statement of next query

I have a read only table to calculate relationship between people DROP TABLE IF EXISTS `reference`; CREATE TABLE IF NOT EXISTS `reference` ( `self` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `brother` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `mom` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `wife` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, PRIMARY KEY […]

Categories
Development

¿It is possible to change command length limits in plesk scheduled task?

I have this command line which already runs into a cpanel hosting mysql -hlocalhost -e “use xxx_xx; update xxx_jshopping_manufacturers set manufacturer_publish = 0 where \`name_es-ES\` NOT IN (‘BULL SOUND’, ‘ROYAL’, ‘BLACK + DECKER (ELECTROD)’, ‘SAMSUNG’, ‘DAEWOO’, ‘OSTER’, ‘WAHL’, ‘REMINGTON’, ‘BROTHER’, ‘CORELLE’, ‘SINGER’, ‘PANASONIC’, ‘FRIGIDAIRE’, ‘LG’, ‘PHILIPS ELECTRONICA’, ‘PIONEER’, ‘SONY’, ‘MOTOROLA’, ‘DEWALT’, ‘APPLE’, ‘JVC’, ‘MAXELL’, ‘WELL’, […]

Categories
Development

Background picture using only about 66% width on Outlook 365

Good day, i have to create a HTML template for an email, where a logo and headline are shown over a picture. In general i was able to get it to work on almost every client, including most of the Microsoft Office, but in Office 365 ProPlus, it shrinks down to about 66% of the […]