Rearrange table columns order

MODIFY [column] column_definition [FIRST ¦ AFTER col_name]
ALTER TABLE tableName MODIFY COLUMN originalColName int(4) AFTER destinationColName

linux folder size

ls -skh folderlist folder sizes
du -skh * |sort -n -r list folder sizes
du -sh folder folder size

sshfs remote mount

sudo chmod og-rwx localFolder/
sudo sshfs user@remoteHost:remoteFolder/ localFolder/ -o allow_other

scp remote copy with port select

scp -P 22 sourceFile user@remoteHost:folder

Excel export chart to jpg png

Hi,

Requires code. Syntax: Activechart.Export ,

You can use this in the immediate window,(ALT+F11 CTRL+G)

Activechart.export "C:\mychart.jpg"

Mysql windows (xampp) case sensitive tables

Open file C:/xampp/mysql/bin/my.cnf and under [mysqld] add
lower_case_table_names=0

Evince papersize

Add the a line with
LC_PAPER="en_HR@hrnum"
in
/etc/environment
Evince will use A4 as default paper format after your next login.

What is en_HR?

en_HR is locale meant to be used by computer users whose native language is Croatian, but who are primarily used to US English based interface. Therefore en_HR features US English messages, and US style of writing numbers. US numeric style is chosen because of the decimal separator - in US style the decimal separator is `.', which is commonly used in mathematics and by SI, while Croatian decimal separator is `,'. If you would rather use Croatian numeric style, then use en_HR@hrnum instead of en_HR. Collate, ctype, monetary, paper, telephone, measurement, name and adress settings are the same ones from hr_HR locale. Date and time format conforms to ISO 8601 standard.