Code: Select all
SELECT name FROM table WHERE BINARY(name) REGEXP '^[a-z]';
Code: Select all
SELECT name FROM table WHERE BINARY(name) REGEXP '^[a-z]';
Code: Select all
memory_limit=128M
Code: Select all
tmpdir=/var/tmp
Code: Select all
/etc/init.d/mysql restart
Code: Select all
echo "${FILENAME:$((${#str}-1)):1}"
Code: Select all
REPAIR TABLE tablename
Code: Select all
group@domain.com bob@domain.com,alice@domain.com
Code: Select all
/tmp/systemd-private-9b5e7c68bxxx45faa1a812b5df02f1ab-apache2.service-5ExxRI/tmp/
Code: Select all
file_put_contents('/tmp/file.tmp',$value);