- A Clear and Compelling Vision
- Strong Leadership
- High-Quality Products or Services
- Strong Financial Management
- Effective Marketing and Sales
- Focus on Customers
- Strong Company Culture
- Innovation
- Strategic Partnerships
- Adaptability
- Add comments to existing code
- summarize long articles or document
- Ask to prepare questions (interview or test questions on specific topics)
Ideas on how to use chatGPT
- get book summary
- get top 5 tips on something. e.g. motivational tips, health tips, career, money etc.
- get best app for ___ e.g. task management, expense tracking etc
- translate articles
- refactor code
- content for your social media. give 10 topics i can write for my social media
- research on something you want to know
- help write email and article. or rewrite it to make it better/different
- suggest or recommend books, tools etc
- 10 best habits
NET::ERR_CERT_DATE_INVALID
Error when using Google Chrome on Mac OS X El Capitan (10.11.6)
To solve this issue:
- Download ISRG Root X1 cert file from http://x1.i.lencr.org/
- Open Keychain Access
- Drag the file to “System” folder
- Double click the file and set “Always Trust”
Reference: https://docs.certifytheweb.com/docs/kb/kb-202109-letsencrypt/#macos-ios-etc
Reinstall Mac OS X El Capitan
Restart the Mac, hold Command+R until the apple logo appears.
If the error message like below appear at the end of installation progress,
“OS X could not be installed on your computer. No packages were eligible for install”
- Turn off the wifi
- Open Utilities > Terminal from the menu on top
- Type the following command in terminal to set date back to 2017 (note: date format: mmddhhmmyy):
date 0115124517 - Hit restart
- After restart, repeat step 1-3 before continue with installation to ensure the date still 2017.
Reference if issue still can’t be solved
https://discussions.apple.com/thread/250793420?answerId=251511664022
Truncated incorrect DECIMAL value: ”
This error message is not helpful at all. There are similar error to this for DOUBLE etc instead of DECIMAL value.
I got this error when running a simple query like below in MySQL.
update table_1
set field_value = “value”
where field_id in (123, 345, 456);
This caused by the value in where condition compared to a non-integer value. For example, there are some empty string in field_id field.
The solution – changed the string in field_id to NULL or integer value.
IPO purchase
Check for IPO availability in Maybank2u
After log in M2u, click “Apply” and choose Investment > eIPO. Click on “Apply Now” button
Can also use this website to view IPO and background of the companies
View prospectus of the selected company
Then can also look for fair value from investment companies. Or some remisier also compiled this fair value in their facebook etc.
Cannot use ctrl+shift+v in Google sheet in Brave
The solution, install and enable this extension
https://chrome.google.com/webstore/detail/google-docs-offline/ghbmnnjooekpmoecnnnilnnbdlolhkhi
Standard fields in a table
Below are some must have’s or standard fields for a table
- id
- uuid – varchar(36). use uuid() function
- created_at
- created_by
- updated_at
- updated_by
- deleted_at
- deleted_by
example of uuid() generated value = 27764328539095040
example of uuid_short() generated value = 27764328539095040
Check directory size in Linux
To check directory size (all files under the directory) and sort by file size.
du -hs * | sort -h
How to learn effectively
First, read or watch tutorial attentively
Secondly, try to understand, relate and think where we can apply.
Third, apply what we have learnt. It may be far from perfect. But the key is we have done something with our newly learnt knowledge
Lastly, share it. Share it to the friends, write a post on your blog, write on social media. Share!
If you don’t use it. You lose it