Login

Blog

MySQL – Drop all Tables from Command Line

person
LogixTree Networks
folder_openCoding, Snippets
commentNo Comments
DROP PROCEDURE IF EXISTS `drop_all_tables`; DELIMITER $$ CREATE PROCEDURE `drop_all_tables`() BEGIN DECLARE _done INT DEFAULT FALSE; DECLARE _tableName VARCHAR(255); DECLARE _cursor CURSOR FOR SELECT table_name FROM information_schema.TABLES WHERE table_schema = SCHEMA(); DECLARE CONTINUE HANDLER FOR NOT FOUND SET _done =…
Click Me

Check available RAM in Linux

person
LogixTree Networks
folder_openCoding, Snippets
commentNo Comments
This will convert any kB lines to MB: awk '$3=="kB"{$2=$2/1024;$3="MB"} 1' /proc/meminfo | column -t 1 awk '$3=="kB"{$2=$2/1024;$3="MB"} 1' /proc/meminfo | column -t This version converts to gigabytes: awk '$3=="kB"{$2=$2/1024^2;$3="GB";} 1' /proc/meminfo | column -t 1 awk '$3=="kB"{$2=$2/1024^2;$3="GB";} 1' /proc/meminfo | column -t…
Click Me

Has word in String? – PHP

person
LogixTree Networks
folder_openSnippets
commentNo Comments
function hasWord($word, $txt) { $patt = "/(?:^|[^a-zA-Z])" . preg_quote($word, '/') . "(?:$|[^a-zA-Z])/i"; return preg_match($patt, $txt); } $string = 'This is my own paragraph.'; echo hasWord('no', $string); 123456 function hasWord($word, $txt) {    $patt = "/(?:^|[^a-zA-Z])" . preg_quote($word, '/') . "(?:$|[^a-zA-Z])/i";    return preg_match($patt, $txt);}$string…
Click Me
Menu
This website uses cookies to improve your experience. If you continue to use this site, you agree with it. Privacy Policy
Ok