today's howtos

posted by Roy Schestowitz on Feb 10, 2023

• Assigning an IP address to a Linux interface

  Introduction Linux is a popular open-source operating system used by many organizations and individuals. One of the key features of Linux is its ability to configure networking, including assigning IP addresses to interfaces.

• MySQL Stored procedures

  Introduction If you’re a database administrator, or you work with databases on a regular basis, you're likely familiar with SQL. SQL is a programming language used to manage and manipulate data in relational databases, such as MySQL. One of the features of MySQL that can make your life easier is stored procedures.

• MySQL Joining tables

  In the world of databases, joining tables is an essential aspect that plays a crucial role in data management. In MySQL, joining tables refers to the process of combining data from two or more tables into a single result set.

• Fixing the ‘Permission Denied’ Error on Linux

• Advanced Logging and Auditing on Linux

• PIR Sensor HC-SR501 Arduino Nano Tutorial – Step by Step Instruction

  Arduino Nano using PIR sensor can detect any object motion. This article covers the complete Arduino code and steps involved in detecting object movement.

• ESP32 NTP Client-Server: Get Date and Time – Arduino IDE

  ESP32 inbuilt timer is not so accurate so we can use NTP server to get real time of specific time zone and use it to execute instructions. Read more here.

• ESP32 PWM with MicroPython Using Thonny IDE

  To configure PWM signal in MicroPython we have to import PWM class from the machine module. PWM in ESP32 helps in getting analog results using digital signals.

• MySQL Loading data into a table

  When it comes to managing data in a database, one of the most important tasks is loading data into a table. This involves inserting data into a table from a file or another source. MySQL provides several options for loading data into tables, including the LOAD DATA INFILE, INSERT INTO, and UPDATE statements.

• MySQL Selecting data into a file and table

  In this article, we will explore how to select data from a MySQL database and save it into a file or table. The SELECT statement is one of the most commonly used statements in MySQL and is used to retrieve data from one or more tables in a database.

• Fixing the ‘Invalid Argument’ Error on Linux

• Fixing the ‘Too Many Open Files’ Error on Linux

• Solving the ‘Command Not Found’ Error on Linux