Skip to main content

Notes on daily bash Dec-07 2020

 https://unix.stackexchange.com/questions/42898/find-any-lines-exceeding-a-certain-length

Get lines exceeding a certain length.

grep '.\{80\}' file

perl -nle 'print if length$_>79' file

awk 'length>79' file

sed -n '/.\{80\}/p' file


Get the max length line

wc -L brake_input.model.dat


Get nth line:

sed 'NUMq;d' file

If you have NUM in a variable, you will want to use double quotes instead of single:

sed "${NUM}q;d" file

https://stackoverflow.com/questions/6022384/bash-tool-to-get-nth-line-from-a-file


Assuming you need lines 20 to 40,

sed -n '20,40p;41q' file_name => not work as expected

or

awk 'FNR>=20 && FNR<=40' file_name


This one work:

sed -n -e '10,100p' input.txt > output.txt


https://gist.github.com/simofacc/061aaf189a559a0817bf

https://stackoverflow.com/questions/13294341/create-slug-to-include-id-and-title-when-insert-record-php-mysql

CREATE TRIGGER trigger_name BEFORE INSERT ON table

FOR EACH ROW SET slug = CONCAT(NEW.title, "-", NEW.id);


CREATE DEFINER=`[USER_NAME]`@`%` TRIGGER `[DATABASE_NAME]`.`Slug` BEFORE INSERT ON `[TABLE_NAME]`.`games` FOR EACH ROW 

BEGIN

IF NEW.slug IS NULL THEN

    SET NEW.slug = LOWER(TRIM(NEW.name));

    SET NEW.slug = REPLACE(NEW.slug, ':', '');

    SET NEW.slug = REPLACE(NEW.slug, ')', '');

    SET NEW.slug = REPLACE(NEW.slug, '(', '');

    SET NEW.slug = REPLACE(NEW.slug, ',', '');

    SET NEW.slug = REPLACE(NEW.slug, '\\', '');

    SET NEW.slug = REPLACE(NEW.slug, '?', '');

    SET NEW.slug = REPLACE(NEW.slug, '\'', '');

    SET NEW.slug = REPLACE(NEW.slug, '&', '');

    SET NEW.slug = REPLACE(NEW.slug, '!', '');

    SET NEW.slug = REPLACE(NEW.slug, '.', '');

    SET NEW.slug = REPLACE(NEW.slug, '&euro;', '');

    SET NEW.slug = REPLACE(NEW.slug, 'euro;', '');

    SET NEW.slug = REPLACE(NEW.slug, ' ', '-');

    SET NEW.slug = REPLACE(NEW.slug, '--', '-');

    END IF;

END;


https://stackoverflow.com/questions/8295131/best-practices-for-sql-varchar-column-length

Some cool desc on varchar length


https://stackoverflow.com/questions/13476029/multiple-table-select-vs-join-performance

Some CI model get column, p-key...

https://stackoverflow.com/questions/10258128/how-to-get-field-names-of-mysql-table-in-codeigniter


Good point

https://stackoverflow.com/questions/54379695/delete-large-amount-of-rows-from-mysql-table-is-very-slow


Comments

  1. Việc cuối cùng cần chuẩn bị trước cho chuyến đi đến nước Mỹ đó chính là đặt phòng khách sạn. Thông thường, vào mùa hoa Anh đào nở, du khách đến với nước Mỹ đều rất đông. Tham khảo: vé máy bay đi Richmond giá rẻ .

    Bạn sẽ rất dễ rơi vào hoàn cảnh không đặt được phòng khách sạn trực tiếp. Bởi vậy, trước khi đi, hãy lên kế hoạch cho cả việc đặt phòng khách sạn. Điều này sẽ giúp bạn an tâm hơn với điểm dừng chân đầu tiên tại Mỹ.

    Vé máy bay đi Mỹ: https://unitedairlines-vn.com/ve-may-bay-di-my .

    ReplyDelete

Post a Comment

Popular posts from this blog

AWS Elasticache Memcached connection

https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/accessing-elasticache.html#access-from-outside-aws http://hourlyapps.blogspot.com/2010/06/examples-of-memcached-commands.html Access memcached https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/GettingStarted.AuthorizeAccess.html Zip include hidden file https://stackoverflow.com/questions/12493206/zip-including-hidden-files phpmemcachedadmin ~ phpMyAdmin or phpPgAdmin ... telnet mycachecluster.eaogs8.0001.usw2.cache.amazonaws.com 11211 stats items stats cachedump 27 100 https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/VPCs.EC.html https://lzone.de/cheat-sheet/memcached VPC ID Security Group ID (sg-...) Cluster: The identifier for the cluster memcached1 Creation Time: The time (UTC) when the cluster was created January 9, 2019 at 11:47:16 AM UTC+7 Configuration Endpoint: The configuration endpoint of the cluster memcached1.ahgofe.cfg.usw1.cache.amazonaws.com:11211 St...

Simulate Fail2ban on Apache request spam with mod_evasive limitipconn ...

https://en.wikipedia.org/wiki/Manchu_alphabet https://en.wikipedia.org/wiki/Sweet_potato https://en.wikipedia.org/wiki/New_World_crops https://www.mdpi.com/journal/energies http://www.cired.net/publications/cired2007/pdfs/CIRED2007_0342_paper.pdf https://www.davidpashley.com/articles/writing-robust-shell-scripts/ trap command https://en.wikipedia.org/wiki/Race_condition https://unix.stackexchange.com/questions/172541/why-does-exit-1-not-exit-the-script exit 1 not work it seem { } brace bound fixed it. cat access_log | cut -d ' ' -f 1 > ip1 sort -n -t. -k1,1 -k2,2 -k3,3 -k4,4 | uniq -c | sort -n -r -s https://unix.stackexchange.com/questions/246104/unix-count-unique-ip-addresses-sort-them-by-most-frequent-and-also-sort-them https://stackoverflow.com/questions/20164696/how-to-block-spam-and-spam-bots-for-good-with-htaccess  Code: ------------------------------------------------------------------- #Block Spam Bots and Spam on your website #Block proxies...

Notes Windows 10 Virtualbox config, PHP Storm Japanese, custom PHP, Apache build, Postgresql

 cmd => Ctrl + Shift + Enter mklink "C:\Users\HauNT\Videos\host3" "C:\Windows\System32\drivers\etc\hosts" https://www.quora.com/How-to-create-a-router-in-php https://serverfault.com/questions/225155/virtualbox-how-to-set-up-networking-so-both-host-and-guest-can-access-internet 1 NAT + 1 host only config https://unix.stackexchange.com/questions/115464/how-to-properly-set-up-2-network-interfaces-in-centos-running-in-virtualbox DEVICE=eth0 TYPE=Ethernet #BOOTPROTO=dhcp BOOTPROTO=none #IPADDR=10.9.11.246 #PREFIX=24 #GATEWAY=10.9.11.1 #IPV4_FAILURE_FATAL=yes #HWADDR=08:00:27:CC:AC:AC ONBOOT=yes NAME="System eth0" [root@localhost www]# cat /etc/sysconfig/network-scripts/ifcfg-eth1 # Advanced Micro Devices, Inc. [AMD] 79c970 [PCnet32 LANCE] DEVICE=eth1 IPADDR=192.168.56.28 <= no eff => auto like DHCP #GATEWAY=192.168.56.1 #BOOTPROTO=dhcp BOOTPROTO=static <= no eff ONBOOT=yes HWADDR=08:00:27:b4:20:10 [root@localhost www]# ...