Tux Machines

today's howtos

Posted by Roy Schestowitz on Feb 10, 2023

Unicode 15.0 Emoji Now Supported in Ubuntu 22.04 LTS

Proprietary Software and Clown Computing (Spied-on Server Space)

Assigning an IP address to a Linux interface

↺ 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

↺ 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

↺ 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

↺ Fixing the ‘Permission Denied’ Error on Linux

Advanced Logging and Auditing on Linux

↺ Advanced Logging and Auditing on Linux

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

↺ 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 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

↺ 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

↺ 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

↺ 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 ‘Invalid Argument’ Error on Linux

Fixing the ‘Too Many Open Files’ Error on Linux

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

Solving the ‘Command Not Found’ Error on Linux

↺ Solving the ‘Command Not Found’ Error on Linux

gemini.tuxmachines.org