The proper way of doing SQL "INSERT ON DUPLICATE UPDATE"

$sql = 'INSERT INTO table_name (column1, column2, column3, column4) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE column1=VALUES(column1), column2=VALUES(column2)';

Merge audio and video in ffmpeg

ffmpeg -i D:\Audioname.ac3 -i D:\Video.mp4 -acodec copy -vcodec copy D:\VideoFull.mp4

extensions can differ

change timezone ubuntu/debian

sudo dpkg-reconfigure tzdata

Cutting video without changing quality using ffmpeg

for example cut 5 min video from 10min  to 15 (10+5)
ffmpeg -i D:\videofile.mp4 -ss 00:10:00 -t 00:05:00 -vcodec copy -acodec copy D:\videofileSmall.mp4

Ubuntu Mysql Import file.sql into database FROM cmd

$ mysql   -u  root   -p

then enter password and

mysql> use DATABASE_NAME;

mysql> source path/to/file.sql;

Laravel fresh install ubuntu HTTP 500 Fix

sudo chmod 755 -R laravel_app

sudo chmod -R o+w laravel_blog/storage

Ubuntu remove directory

sudo rm -rf folderName