Alter all tables in mysql database

Standard
USE INFORMATION_SCHEMA;
SELECT 
CONCAT("ALTER TABLE `", TABLE_SCHEMA,"`.`", TABLE_NAME, "` CONVERT TO CHARACTER SET UTF8;") 
AS MySQLCMD FROM TABLES 
WHERE TABLE_SCHEMA = "dbname";

Raspberry Pi 3にDockerをインストールする

Standard
cat /etc/issue
Raspbian GNU/Linux 9 \n \l
 
apt-get install \
    apt-transport-https \
    ca-certificates \
    curl \
    gnupg2 \
    software-properties-common
 
curl -fsSL https://download.docker.com/linux/debian/gpg | sudo apt-key add -
 
cat /etc/apt/sources.list.d/docker.list
deb [arch=armhf] https://download.docker.com/linux/debian      stretch stable
 
apt-get update
apt-get install --yes docker-ce

JLPT N2过了

Standard

居然过了,不容易啊…
对于35岁才从零开始学一门新语言的自已来说,记忆方面真是要花比90后00后们多许多倍的时间才行。
好在也算是过了,对得起自已这一年半时间的学习了。 [read more]