If you need to convert pdf to jpg I was working with php but it might be slow, obviously. But if you are using linux shell then it’s easier and faster.
72 dpi (web) = 595 X 842 pixels
300 dpi (print) = 2480 X 3508 pixels
600 dpi (print) = 4960 X 7016 pixelsCool stuff
UPDATE tableName SET columnName = FLOOR( 1 + RAND( ) *3 );https://stackoverflow.com/questions/14865632/update-all-records-with-a-random-number-from-a-range
Poppler has one command to merge all pdfs from folder:
pdfunite *.pdf out.pdfhttps://stackoverflow.com/questions/2507766/merge-convert-multiple-pdf-files-into-one-pdf
Very simple.
Always check here:
mysql -u root -p -e "SELECT * FROM employees" my_database > employees.csv
mysql -u posao_statistike -p -e "SELECT d.*, s.grad FROM daljincinecitani d LEFT JOIN sap_maticna_nis_copy_nova_copy s ON d.SER_BR like concat('%',s.fab_broj)" posao_statistike > ~/rezultat.csv
https://www.geeksforgeeks.org/how-to-export-query-result-in-mysql/
SELECT ShortURL, l.LongURL, tag
FROM Links l LEFT JOIN
Domain d
ON l.LongURL LIKE concat('%', d.url, '%');
https://stackoverflow.com/questions/42026673/join-mysql-tables-based-on-partial-match-of-stringsWhen exporting mysql db to different server and have datetime or timestamp fields then it is very important what the time zone is the other server is.
Check mysql for time zone. For phpmyadmin go to variables and there check time zone variable and then go to the server where you need to import db and check time zone on the linux server itself.
You need to make sure both time zones are the same.
https://linuxize.com/post/how-to-set-or-change-timezone-on-ubuntu-20-04
Or just add --skip-tz-utc to mysqldump. But this is ok for one db but most likely with backup/restore and tar it’s going to be problem. So just use time zone on linux server and restart mysql/mariadb.
https://stackoverflow.com/questions/14886427/mysql-data-export-changes-times
SHOW COLUMNS FROM tablenamehttps://stackoverflow.com/questions/4165195/mysql-query-to-get-column-names
You cannot copy from remote to remote. You need to first copy locally and then copy to remote, or vice versa.
If you need to copy from local to s3 you need to setup public ACL then or add policy to allow public access to uploaded files.
https://s3tools.org/s3cmd-sync
## You may choose to remove --recursive if is required only for the bucket or folder and not for objects within.
s3cmd setacl --acl-private --recursive s3://mybucket-name
s3cmd setacl --acl-private --recursive s3://mybucket-name/folder-name
s3cmd setacl --acl-private --recursive s3://mybucket-name/folder-name/object-name
s3cmd setacl --acl-public --recursive s3://mybucket-name
s3cmd setacl --acl-public --recursive s3://mybucket-name/folder-name
s3cmd setacl --acl-public --recursive s3://mybucket-name/folder-name/object-name
For example:
s3cmd sync --skip-existing . s3://sonic/rs/ -c ~/.s3cfg-digitalocean
s3cmd info s3://sonic/ -c ~/.s3cfg-digitalocean
s3cmd setpolicy ~/polisa.json s3://sonic/ -c ~/.s3cfg-digitalocean
s3cmd setpolicy ~/polisa.json s3://sonic/ -c ~/.s3cfg-digitalocean
s3cmd sync --skip-existing s3://leaflets/rs/ ./
cat ~/polisa.json
{"Id":"PublicSharePolicy","Version":"2012-10-17","Statement":[{"Action":["s3:*"],"Effect":"Allow","Resource":["arn:aws:s3:::sonic","arn:aws:s3:::sonic/*"],"Principal":"*"}]}To remove leading zeros use value() function. Also lookup can be used with value function.
You cannot compare it with = sign.
You need to use:
For partial recognition:
=ISNUMBER(SEARCH(B1,A1))For exact recognition:
=EXACT(C2,F2)Make sure to trim cell before comparing if you are using EXACT function or otherwise you are going to get bad results.