Capitalize first letter in SQL

-
concat(ucase(left(column_name, 1)), substring(column_name, 2))
Total page views:

Comments

Post a Comment

Popular posts from this blog

Check Change Files in Git

-
You can compare only the files that differ between your current local branch and another branch on the remote using Git. Here are the most common and useful ways, from simplest to more detailed. 1. List only the changed files (most common) git fetch origin git diff --name-only origin/other-branch If you want to be explicit about your current branch: git diff --name-only origin/other-branch..HEAD ➡️ Shows only file paths that are different. 2. List changed files with change type (added / modified / deleted) git diff --name-status origin/other-branch..HEAD Example output: M src/app.js A src/new-file.ts D src/old-file.css 3. Compare against the common ancestor (recommended for PR-style comparison) This avoids noise from changes made in the target branch after you branched. git diff --name-only origin/other-branch...HEAD ... (three dots) means: changes on your branch since it diverged from the other branch This is usually what you want when prepari...
Read more

Run termux script using macrodroid

-
Running a Termux script from MacroDroid is best done using the Termux:Tasker plugin. Despite the name, this plugin works perfectly with MacroDroid. Prerequisite: The "F-Droid" Rule Critical: You must install both Termux and the Termux:Tasker plugin from F-Droid . If you installed Termux from the Google Play Store, it will not work because the Play Store version is outdated. Action: Uninstall the Play Store version and install the latest versions from F-Droid. Step 1: Set up the Termux Environment Open Termux. Create the mandatory folder for external scripts: mkdir -p ~/.termux/tasker Move your script to this folder (or create a new one there). Example: nano ~/.termux/tasker/myscript.sh Important: Make the script executable. chmod +x ~/.termux/ta...
Read more

Create rish shortcut on Home Screen

-
Install  Shizuku  from GitHub (not playstore vesion) Install Termux (Terminal emulator with packages) from F-Droid Install Termux:Widget (Launch Termux commands from the homescreen) from F-Droid  Make sure your Shizuku can be run on boot using Wireless ADB (look up for it) In Shizuku, click "Use Shizuku in terminal apps" Click "Export files" Export anywhere, like in Download/rish  Run Termux Type "termux-setup-storage" Copy both files exported from Shizuku mkdir ~/rish  cp ~/storage/shared/Download/rish/* ~/rish  Edit rish as instruction on Shizuku nano ~/rish/rish Press CTRL + \  Type PKG Press Enter Type com.termux Press Ctrl + O Press Enter Press Ctrl + X Change rish permission chmod +x ~/rish/rish Create shortcuts folder mkdir ~/.shortcuts Create your shortcut file in  .shortcuts folder Example:  To archive and unarchive Macrodroid nano ~/.shortcuts/archive_macrodorid.sh ~/rish/rish -c 'pm archive --user 0 com.arlosoft.macrodroid' Sa...
Read more