| ssh user@host-ip -L 3308:127.0.0.1:3306 | |
| # Example | |
| ssh user@host-ip -L local-port:remote-mysql-ip:remote-mysql-ip |
| Source: https://forums.virtualbox.org/viewtopic.php?t=8535 | |
| Turn off time syncing: | |
| vboxmanage setextradata [VMname] "VBoxInternal/Devices/VMMDev/0/Config/GetHostTimeDisabled" "1" | |
| Turn it back on: | |
| vboxmanage setextradata [VMname] "VBoxInternal/Devices/VMMDev/0/Config/GetHostTimeDisabled" "0" | |
| note: [VMname] is the name of your virtual machine. |
| - Levenshtein - Hebrew & Arabic (utf8mb4) | |
| - http://blog.cavar.si/2011/04/how-to-implement-levenshtein-algotithm.html | |
| --------------------------------------------------------------------------------------------------------------------------------- | |
| DELIMITER $$ | |
| CREATE DEFINER=`root`@`localhost` FUNCTION `levenshtein`(`s1` VARCHAR(255) CHARSET utf8mb4, `s2` VARCHAR(255) CHARSET utf8mb4) RETURNS int(11) | |
| DETERMINISTIC | |
| BEGIN | |
| DECLARE s1_len, s2_len, i, j, c, c_temp, cost INT; | |
| DECLARE s1_char CHAR CHARSET utf8mb4; |
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="UTF-8"> | |
| <title>Firebase Storage</title> | |
| <script src="https://www.gstatic.com/firebasejs/3.6.9/firebase.js"></script> | |
| <script> | |
| // Initialize Firebase |
https://scotch.io/tutorials/how-to-build-nested-model-driven-forms-in-angular-2
https://scotch.io/tutorials/using-angular-2s-model-driven-forms-with-formgroup-and-formcontrol
http://blog.thoughtram.io/angular/2016/03/14/custom-validators-in-angular-2.html http://stackoverflow.com/questions/34072092/generic-mail-validator-in-angular2
| AREA 122 | |
| Array | |
| ( | |
| [DHANMONDI] => 19189 | |
| [MOTIJHEEL3] => 1 | |
| ) | |
| =================== | |
| AREA 102 | |
| Array |
| SELECT SC.CODE_NAME, AA.* FROM C_CUST_CODE_BOOK AA | |
| LEFT JOIN S_CODE_DATA SC ON SC.CODE_STRING = AA.AREA | |
| WHERE SC.CODE_NAME IN ( | |
| 'AREA 122', | |
| 'AREA 102', | |
| 'AREA 104', | |
| 'AREA 110', | |
| 'AREA 111', | |
| 'AREA 112', | |
| 'AREA 116', |
| SELECT | |
| CCB.CUSTOMER_CODE, CCB.AREA, s1.CODE_NAME, TO_NUMBER(SUBSTR(CCB.CUSTOMER_CODE, 4, 6)), CCB.CODE_OCCUPIED_BY, CCB.USED_DATE, CCB."ZONE" | |
| FROM C_CUST_CODE_BOOK CCB | |
| LEFT JOIN S_CODE_DATA s1 ON s1.CODE_STRING = CCB.AREA | |
| WHERE CCB.USED_STATUS = 'N' | |
| AND TO_NUMBER(SUBSTR(CCB.CUSTOMER_CODE, 4, 6)) IN ( | |
| SELECT | |
| TO_NUMBER(SUBSTR(CCB.CUSTOMER_CODE, 4, 6)) AS GENERATED_CUSTOMER_ID | |
| FROM C_CUST_CODE_BOOK CCB | |
| LEFT JOIN S_CODE_DATA s1 ON s1.CODE_STRING = CCB.AREA |
| ###################################### FROM OWN USER ###################################### | |
| -- Generate all drop table | |
| select 'drop table '||table_name||' cascade constraints;' from user_tables; | |
| -- Generate to drop squences and others | |
| select 'drop '||object_type||' '|| object_name || ';' from user_objects where object_type in ('VIEW','PACKAGE','SEQUENCE', 'PROCEDURE', 'FUNCTION', 'INDEX'); | |
| -- This help to dump empty table | |
| SELECT 'ALTER TABLE '||table_name||' ALLOCATE EXTENT;' FROM user_tables WHERE segment_created = 'NO'; -- TESTED | |
| ---- OR --- |