thesuhu

# save in your home directory
set smtp-use-starttls
set ssl-verify=ignore
set nss-config-dir=/etc/pki/nssdb
set smtp=smtp.yourdomain.com:465
set smtp-auth=login
set smtp-auth-user=thesuhu@yourdomain.com
set smtp-auth-password=yourpassword
set from="thesuhu@yourdomain.com (The Suhu)"

thesuhu

DELIMITER $$

CREATE FUNCTION extract_digits (string_mixed VARCHAR(100)) RETURNS VARCHAR(100) NO SQL
BEGIN
    DECLARE find_digit_position VARCHAR(100);
    DECLARE string_digits VARCHAR(100) DEFAULT '';
    DECLARE search_char VARCHAR(1);
    DECLARE i INTEGER DEFAULT 1;

    IF LENGTH(string_mixed) > 0 THEN

thesuhu

#! /bin/bash

# Already tested on Ubuntu 20.04
# Check the latest version at https://curl.se/download/
VERSION=7.80.0

cd ~
sudo apt-get update -y
sudo apt-get install -y nghttp2 libnghttp2-dev libssl-dev build-essential wget
wget https://curl.haxx.se/download/curl-${VERSION}.tar.gz

thesuhu

Work With Oracle Tablespace

# Written by The Suhu (2021).

# Tested on Oracle 12c

Short description

thesuhu

Getting Digits from String in MySQL or Oracle

# Written by The Suhu (2021).

# Tested on MySQL 5.7.24, MySQL 8.0.23 and Oracle 12c

As an illustration I want to get data like this from a table.

thesuhu

Build Oracle 18c XE Docker image

# Written by The Suhu (2021).

# Tested on Ubuntu Server 20.04
# Make sure you have enough disk space

Build image

thesuhu

#! /bin/bash

# Tested on CentOS 7 and CentOS 8
# Check the latest version at https://curl.se/download/
VERSION=7.80.0

cd ~
sudo yum update -y
sudo yum install wget gcc openssl-devel make -y
wget https://curl.haxx.se/download/curl-${VERSION}.tar.gz

thesuhu

// You can simply use response.data.pipe and fs.createWriteStream to pipe response to file
const axios = require('axios')

// Example 1:
axios({
    method: "get",
    url: "https://xxx/my.pdf",
    responseType: "stream"
}).then(function (response) {
    response.data.pipe(fs.createWriteStream("/temp/my.pdf"))

thesuhu

# Make sure MySQL is not running
sudo systemctl stop mysql

# Then purge all of the MySQL packages
sudo apt purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-*

# Then delete all of the MySQL files 
sudo rm -rf /etc/mysql /var/lib/mysql /var/log/mysql

# Finally clean all packages that are not needed:

thesuhu

How to Install MySQL on Ubuntu

This tutorial has been tested on Ubuntu 20.04 LTS.

Install latest version

Before install, don't forget to update package index in your server.

sudo apt update