MySQL has an undocumented syntax to sort nulls last. Place a minus sign (-) before the column name and switch the ASC to DESC:
SELECT * FROM tablename WHERE visible=1 ORDER BY -position DESC, id DESC
It is essentially the inverse of position DESC placing the NULL values last but otherwise the same as position ASC.
Works with GROUP BY and allows to create subtotals and totals automatically as long as you group something.
UPDATE `table` SET `filed1` = replace(`filed1`,’xyz’,’abc’);
This will replace partial string, for example: “My xyz friend is here” -> “My abc friend is here”
Article ID: 427
Last Review: Jul, 5 2011
Parallels Plesk Panel renames ‘root’ mysql account to ‘admin’
when the Panel is installed.
To get root privileges in mysql simply login with the ‘admin’ username instead. The password is the same as the admin password in Parallels Plesk Panel.
On server with Parallels Plesk Panel versions 8.x, 9.x and above admin password is stored in file /etc/psa/.psa.shadow. Use the following command to get the
~# cat /etc/psa/.psa.shadow
Since version 10 admin password stored in file /etc/psa/.psa.shadow is encrypted. Use the following command to get admin password in plain text:
~# /usr/local/psa/bin/admin --show-password
Despite version of Parallels Plesk Panel you may use the following command to login to mysql with root privileges:
~# mysql -uadmin -p`cat/etc/psa/.psa.shadow`