Archive for August, 2018

August 30, 2018 | In: Programovanie

mysql natural sort

Natural sort in mysql

select alphanum ORDER BY LENGTH(alphanum), alphanum

result:
a1
a2
a9
a10
a11

  • Comments Off on mysql natural sort

How to remove svn needs-lock in all files in folders and subfolders Use the check-for-modifications dialog, show all files (including not modified ones). Select all files, right-click, choose "properties". Then remove the svn:needs-lock...

  • Comments Off on svn:needs-lock disable

August 20, 2018 | In: Správa linuxu, Video-Audio

mp3 gain

Increase the volume of an mp3 on linux

aptitude install easymp3gain-gtk

nacitate mp3 zmenite z 89db na trebars 100

public.webperfection.net/ringtone.mp3 original
public.webperfection.net/ringtone2.mp3

  • Comments Off on mp3 gain

August 18, 2018 | In: Správa linuxu, Video-Audio

mp3 cut

How to cut mp3 on linux? simple:

aptitude install mpgtx

public.webperfection.net/ringtone3.mp3

mpgsplit ringtone2.mp3 [00:00:10.60-00:01:00] -o ringtone3.mp3

  • Comments Off on mp3 cut

August 18, 2018 | In: Programovanie

pocet riadkov kodu

Ak chceme pocet riadkov v kode find . -name '*.php' | xargs wc -l

  • Comments Off on pocet riadkov kodu