an extreme solution is to delete the dir
Code: Select all
rm -fr /var/spool/postfix
Code: Select all
apt-get reinstall postfix
Code: Select all
rm -fr /var/spool/postfix
Code: Select all
apt-get reinstall postfix
Code: Select all
chown -R postfix /var/spool/postfix
Code: Select all
postfix set-permissions
Code: Select all
UPDATE table_name SET text_field=CONCAT(text_field,'string to add') WHERE id='1';
Code: Select all
#Set the IP
case $VALUE in
1)
IP=192.168.1.160
NAME='a';
;;
2)
IP=192.168.1.161
NAME='B';
;;
*)
IP=192.168.1.1
NAME='Default';
;;
esac
Code: Select all
echo ${STRING: -1}
Code: Select all
SELECT table1.id,union_table.name FROM table1 LEFT JOIN
(SELECT id,name FROM table2 UNION SELECT id,title AS name FROM table3)
AS union_table ON table1.other_id=union_table.id;
Code: Select all
ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUsernamePassword';