start by updating the release sudo apt-get update && sudo apt-get dist-upgrade
mysql -version or sudo dpkg -l | grep mysql
-- without using SET variable | |
SELECT t.id, | |
t.count, | |
(@running_total := @running_total + t.count) AS cumulative_sum | |
FROM TABLE t | |
JOIN (SELECT @running_total := 0) r | |
ORDER BY t.id | |
-- with SET variable | |
SET @running_total := 0; |
-- without using SET variable | |
SELECT t.id, | |
t.count, | |
(@running_total := @running_total + t.count) AS cumulative_sum | |
FROM TABLE t | |
JOIN (SELECT @running_total := 0) r | |
ORDER BY t.id | |
-- with SET variable | |
SET @running_total := 0; |
# MySQL Server Instance Configuration File | |
# ---------------------------------------------------------------------- | |
# Generated by the MySQL Server Instance Configuration Wizard | |
# | |
# | |
# Installation Instructions | |
# ---------------------------------------------------------------------- | |
# | |
# On Linux you can copy this file to /etc/my.cnf to set global options, | |
# mysql-data-dir/my.cnf to set server-specific options |
# *** Application-specific options follow here *** | |
# | |
# The MySQL server | |
# | |
[mysqld] | |
# The maximum amount of concurrent sessions the MySQL server will | |
# allow. One of these connections will be reserved for a user with | |
# SUPER privileges to allow the administrator to login even if the |
Summarized from https://stgraber.org/2016/03/19/lxd-2-0-your-first-lxd-container-312/.
Interestingly, the LXD command line client is named.... lxc
!
lxc image list ubuntu: # ubuntu: is officially supported image source
lxc image list images: # images: is an unsupported source
lxc image alias list images: # lists user-friendly names
#!/bin/bash | |
##this script will backup mysql and upload it to google drive | |
##directory name | |
dirname=$1; | |
##database name | |
database=$2; | |
##database username | |
dbuser=$3; | |
##database password | |
dbpass=$4; |
Angular CLI version | Angular version | Node.js version | TypeScript version | RxJS version | |
---|---|---|---|---|---|
1.0.0-beta.17 (package name: angular-cli) | 2.0.x | 6.9.x or later minor version | 2.0.x | 5.0.x or later minor version | |
1.0.0-beta.20-1 (package name: angular-cli) | 2.1.x | 6.9.x or later minor version | 2.0.x | 5.0.x or later minor version | |
1.0.0-beta.22-1 (package name: angular-cli) | 2.2.x | 6.9.x or later minor version | 2.0.x | 5.0.x or later minor version | |
1.0.0-beta.30 | 2.3.x | 6.9.x or later minor version | 2.0.x | 5.0.x or later minor version | |
1.0.0-rc.4 | 2.4.x | 6.9.x or later minor version | 2.0.x | 5.0.x or later minor version | |
1.0.6 | 4.0.x/4.1.x | 6.9.x or later minor version | 2.2.x | 5.0.x or later minor version | |
1.1.3 | 4.0.x/4.1.x | 6.9.x or later minor version | 2.3.x | 5.0.x or later minor version | |
1.2.7 | 4.0.x/4.1.x | 6.9.x or later minor version | 2.3.x | 5.0.x or later minor version | |
1.3.2 | 4.2.x/4.3.x/4.4.x | 6.9.x or later minor version | 2.4.x | 5.0.x or later minor version |