Wednesday, December 19, 2018

imap.sfu.ca can not be verified message in iphone




"imap.sfu.ca can not be verified message" message popups in iPhone,
Remove those accounts using imap.sfu.ca, add accounts using mail.sfu.ca instead.
To remove email accounts in iphone 8.
1) Go to settings
2) Passwords & accounts
3) Click those accounts using imap.sfu.ca
4) Click "Delete Accounts"

To add accounts using mail.sfu.ca:
https://www.sfu.ca/sfumail/using-sfu-mail/getting-started/mobile-devices/ios.html

Monday, December 17, 2018

Maximum Ei weekly rate for 2019 (Canada)




Maximum insurable earnings (MIE) for 2019 is $53100.
For most people, the basic rate for calculating benefits is 55% of the weekly
average insurable earnings. Maximum EI weekly pay rate for 2019 = 53100*0.55/52=$562

Thursday, December 13, 2018

Export excel in PHPMyADmin




Click Export,
Under Format,  from dropdown menu select
OpenDocument Spreadsheet
and click go button

Tuesday, December 11, 2018

view saved password in iphone




In Settings->Passwords & Accounts
click Website & App Passwords

Thursday, December 6, 2018

MySQL max characters in GROUP_CONCAT




MySQL max characters in GROUP_CONCAT is 1024 characters by default. To increases the size,
in MySQL script run
SET SESSION group_concat_max_len = 10000;
first.