Commands Get unique values SELECT DISTINCT report_date FROM daily; How many records? SELECT count(*) from vanall WHERE Shipped_Date="2021-01-12"; Last Shipped Date -- Current max date in the table SELECT max(Shipped_Date) from vanall; Insert Or Update INSERT or replace INTO daily (date,name_id,testing_hour,sellable,liquidation,quality,concession) VALUES ("2021-02-01",5,1.
Installation How to install Caddy in Ubunbu? Commands list sudo apt install -y debian-keyring debian-archive-keyring apt-transport-https curl -1sLf 'https://dl.cloudsmith.io/public/caddy/stable/gpg.key' | sudo tee /etc/apt/trusted.gpg.d/caddy-stable.asc curl -1sLf…
Tips Regular expression is not a const There are boolean, rune, integer, floating-point, complex, and string constants. Rune, integer, floating-point, and complex constants are collectively…
reCAPTCHA is a free google service that protects your website from spam and abuse. reCAPTCHA uses an advanced risk analysis engine and adaptive challenges to keep automated software from engaging in abusive activities on your site.
Linux Notes Common Commands How to show file permission? ls /var/www -al How to add a user? sudo adduser new_username // or sudo useradd new_username How to remove a user?
Tips To insert current date: Ctrl+; To insert current time: Ctrl+Shift+; To add today’s date in such a way that it updates when you recalculate or reopen your spreadsheet: =Today() Usage XLOOKUP Customer send asset list asking for status.
Models What’s the difference between GK420d and GK420t? GK420d = direct thermal (no printer ribbon facility), requires labels to be made from a direct thermal material in order to create print.
Netlify is a web developer platform that multiplies productivity.
Netlify provides continuous deployment services, global CDN, atomic deploys, instant cache invalidation, one-click SSL, a browser-based interface, and many other features for managing our Hugo website.
Startup Open all PowerPoints Worship PowerPoint Message PowerPoint Downloading the songs beforehand if any. Start OBS and VirtualCam Start VoiceMeter Login to Zoom Settings PowerPoint Settings NOTE:
1. Intro Python Crash Course 2E Study Notes
Interpreter C:\Users\Andrew>python Python 3.8.2 (tags/v3.8.2:7b3ab59, Feb 25 2020, 23:03:10) [MSC v.1916 64 bit (AMD64)] on win32 Type "help", "copyright", "credits" or "license" for more information.
In this COVID-19 pandemic season, to comply with new social distancing measures, churches around the world have sent their congregants home. The COVID-19 will stir…