Skip to content

Instantly share code, notes, and snippets.

View yamagucci's full-sized avatar

takashiyamaguchi yamagucci

3 followers · 1 following
  • Tokyo/Asia
View GitHub Profile
@yamagucci
yamagucci / file0.txt
Last active February 19, 2017 13:44
【エンジニア教材】MySQL編(4) GROUP BY,HAVINGについて ref: http://qiita.com/yamaguchi_takashi/items/7e53336d323672fc8031
CREATE TABLE `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`name_kana` varchar(100) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`gender` varchar(10) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`blood_type` varchar(10) DEFAULT NULL,
`birthday` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
@yamagucci
yamagucci / file0.txt
Last active February 19, 2017 13:46
【エンジニア教材】MySQL編(3) 集合関数について (SUM,AVG,MAX,MIN,COUNT,GROUP_CONCAT) ref: http://qiita.com/yamaguchi_takashi/items/c8e88d889f6338931be8
CREATE TABLE `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`name_kana` varchar(100) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`gender` varchar(10) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`blood_type` varchar(10) DEFAULT NULL,
`birthday` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
@yamagucci
yamagucci / file0.txt
Last active February 19, 2017 13:48
【エンジニア教材】MySQL編(2) ソートについて (ORDER BY,LIMIT) ref: http://qiita.com/yamaguchi_takashi/items/e12c89214ec3f7f4a9b6
CREATE TABLE `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`name_kana` varchar(100) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`gender` varchar(10) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`blood_type` varchar(10) DEFAULT NULL,
`birthday` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
@yamagucci
yamagucci / file0.txt
Last active February 19, 2017 14:08
【エンジニア教材】MySQL編(1) WHERE句について (等号,不等号,BETWEEN,LIKE,IN,IS NULL) ref: http://qiita.com/yamaguchi_takashi/items/d6dc3d7b8ece41b87b2c
CREATE TABLE `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`name_kana` varchar(100) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`gender` varchar(10) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`blood_type` varchar(10) DEFAULT NULL,
`birthday` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
@yamagucci
yamagucci / file0.txt
Last active October 24, 2016 11:23
【開発環境】MySQL5.6のインストール、初期設定、アンインストールの手順 ref: http://qiita.com/yamaguchi_takashi/items/7cb0b27441597c49df45
$ sudo yum -y install http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
@yamagucci
yamagucci / file0.txt
Last active October 24, 2016 11:39
【保存版】EC2(Amazon Linux)の環境構築でhttpdとphp5.6を正しくインストールする手順 ref: http://qiita.com/yamaguchi_takashi/items/69a24de41ffd1f5ef4e2
$ sudo yum -y remove httpd*
$ sudo yum -y remove php-*
$ sudo yum clean all
@yamagucci
yamagucci / file0.txt
Last active October 18, 2016 13:14
【保存版】EC2(Amazon Linux)の環境構築でphp5.6を正しくインストールする手順 ref: http://qiita.com/yamaguchi_takashi/items/d4b7b2693b42679dc3ae
$ sudo yum -y remove httpd*
$ sudo yum -y remove php-*
$ sudo yum clean all