I spent a dozens of minutes today to learn, how to enable ssh to Raspberry Pi without a monitor. SSH is disable by default after October 2016. Here is a one minute solution.
Attach the sd card to your computer and add an empty file SSH on the root of the sd card partition.
It means you are running another instance of dev server. Stop that and rerun this one.
Click the ellipses (…) near button Share and then click Edit Group Settings. Scroll down to Web and Email address.
No need to have any likes or followers or days since created.
Today I spent a couple of hours to figure out that ONLY the following configuration works. It is not covered in any video/tutorial.
This is the settings that MUST be added to all the files:
xdebug.remote_autostart = on
xdebug.remote_start = on
The files are :
If you have a table with column that contains eg file names with extension and want to replace the extension of all those file names.
Eg we have a table named menu with column icon. The icon column contains image file names with extension .png eg dress.png , shoes.png and we want to replace only .png by .svg leaving the filename (without extension) intact. we can use the following command in SQL:
UPDATE menus SET icon = replace(icon, RIGHT(icon, 3), ‘svg’)
WHERE id > 0 AND icon <> ”;