Huynh H. Dinh honghuynhit

🇻🇳

Working from home

🇻🇳 "Do, or do not. There is no try"

honghuynhit / Replace Phone Number At Middle

Last active May 6, 2019 06:30

 const numberLength = number.length;
     // tslint:disable-next-line:radix
     const numberReplace = (Math.round(parseFloat(numberLength) / 2 )) - 2;
     return  number.substr(0, numberReplace ) + '' + '' + '' + '' + number.substr(numberReplace + 3);
   }

honghuynhit / alert authorization in SQL Server

Created January 4, 2018 15:13

alter authorization on Database::your_db to [sa];

honghuynhit / How to reset AUTO_INCREMENT in MySQL?

Created January 4, 2018 15:02

	SET @num := 0;

	UPDATE your_table SET id = @num := (@num+1);

	ALTER TABLE your_table AUTO_INCREMENT =1;