DEV Community: Simon O. Injiri

.sh

Simon O. Injiri — Thu, 15 Jul 2021 13:11:23 +0000

Need some help in making this simple script work. Check out here LINK

MySQL INTERSECT

Simon O. Injiri — Thu, 26 Nov 2020 13:07:45 +0000

Returns distinct rows between two or more queries i.e
(SELECT column_list FROM tabel1 ) INTERSECT (SELECT column_list table2)
For this, to work both columns must have the dame data types,
columns in both queries, have to match

MSQL Subquery

Simon O. Injiri — Fri, 20 Nov 2020 07:16:59 +0000

Find customers whose payments are above a certain value :

SELECT
      customer_number,
      check_number,
      ammount
FROM
      payments
 WHERE
       amount >(SELECT
                  AVG(amount)
               FROM
                    payments);

simple ubuntu hacks

Simon O. Injiri — Sat, 27 Jun 2020 13:34:59 +0000

to make a custom ubuntu service restart on boot , just create a system service link by running:
Sudo systemctl enable service-name.service;
To check if service is enabled run:
Sudo systemctl is-enabled service-name.service;