MySQL

[intrinsic column flags] - PK: primary key (column is part of a pk) - NN: not null (column is nullable) - UQ: unique (column is part of a unique key) - AI: auto increment (the column is auto incremented when rows are inserted) [additional data type flags, depend on used data type] - BIN: binary (if dt is a blob or similar, this indicates that is binary data, rather than text) - UN: unsigned (for integer types, see docs: "10.2. Numeric Types") - ZF: zero fill (rather a display related flag, see docs: "10.2. Numeric Types") MySQLでログを出力してみる ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option ‘secure_auth’ enabled) MySQLのバージョンがちがうとパスワードハッシュが違うのでログインできなくなる

2015年8月5日 · 1 分

Redis Windows

Redis-64 on Windows Install C:\Users\hdknr>choco install redis-64 Chocolatey v0.9.9.2 Installing the following packages: redis-64 By installing you accept licenses for the packages. redis-64 v2.8.19 ShimGen has successfully created a shim for redis-benchmark.exe ShimGen has successfully created a shim for redis-check-aof.exe ShimGen has successfully created a shim for redis-check-dump.exe ShimGen has successfully created a shim for redis-cli.exe ShimGen has successfully created a shim for redis-server.exe redis-64 has been installed successfully. Chocolatey installed 1/1 package(s). 0 package(s) failed. See the log for details. redis-server C:\Users\hdknr>redis-server [7308] 21 Apr 10:26:02.432 # Warning: no config file specified, using the defaul t config. In order to specify a config file use C:\ProgramData\chocolatey\lib\redis-64\redis-server.exe /path/to/redis.conf _._ _.-``__ ''-._ _.-`` `. `_. ''-._ Redis 2.8.19 (00000000/0) 64 bit .-`` .-```. ```\/ _.,_ ''-._ ( ' , .-` | `, ) Running in stand alone mode |`-._`-...-` __...-.``-._|'` _.-'| Port: 6379 | `-._ `._ / _.-' | PID: 7308 `-._ `-._ `-./ _.-' _.-' |`-._`-._ `-.__.-' _.-'_.-'| | `-._`-._ _.-'_.-' | http://redis.io `-._ `-._`-.__.-'_.-' _.-' |`-._`-._ `-.__.-' _.-'_.-'| | `-._`-._ _.-'_.-' | `-._ `-._`-.__.-'_.-' _.-' `-._ `-.__.-' _.-' `-._ _.-' `-.__.-' [7308] 21 Apr 10:26:02.455 # Server started, Redis version 2.8.19 [7308] 21 Apr 10:26:02.456 * The server is now ready to accept connections on port 6379 redis-cli C:\Users\hdknr>redis-cli 127.0.0.1:6379> set testkey testvalue OK 127.0.0.1:6379> get testkey "testvalue" 127.0.0.1:6379> StackExchange.Redis NuGet PM> Install-Package StackExchange.Redis Windows Forms 1 2 3 4 5 6 7 8 private void button1_Click(object sender, EventArgs e) { var connect = StackExchange.Redis.ConnectionMultiplexer.Connect("localhost"); var cb = connect.GetDatabase(); // StackExchange.Redis.IDatabase cb.StringSet("name", "hdknr"); MessageBox.Show(cb.StringGet("name")); } Console Client 127.0.0.1:6379> get name "hdknr"

2015年4月21日 · 2 分

PNGファイルの連結

imagemagick install $ brew install ImageMagick ==> Downloading https://homebrew.bintray.com/bottles/imagemagick-6.9.0-3.yosemite.bottle.tar.gz ######################################################################## 100.0% ==> Pouring imagemagick-6.9.0-3.yosemite.bottle.tar.gz Error: The `brew link` step did not complete successfully The formula built, but is not symlinked into /usr/local Could not symlink bin/convert Target /usr/local/bin/convert already exists. You may want to remove it: rm '/usr/local/bin/convert' To force the link and overwrite all conflicting files: brew link --overwrite imagemagick To list all files that would be deleted: brew link --overwrite --dry-run imagemagick Possible conflicting files are: /usr/local/bin/convert /usr/local/share/man/man1/convert.1 ==> Summary 🍺 /usr/local/Cellar/imagemagick/6.9.0-3: 1440 files, 22M $ rm '/usr/local/bin/convert' override rwxr-xr-x root/wheel for /usr/local/bin/convert? yes $ ls /usr/local/bin/convert ls: /usr/local/bin/convert: No such file or directory $ brew link --overwrite imagemagick Linking /usr/local/Cellar/imagemagick/6.9.0-3... 71 symlinks created

2015年3月1日 · 1 分

Boostrap : nav

navbar navbar-brand navbar-collapse navbar-default navbar-form navbar-header navbar-nav navbar-toggle navbar-left navbar-btn navbar-text navbar-link navbar-right navbar-fixed-top navbar-fixed-bottom navbar-static-top navbar-inverse

2015年2月25日 · 1 分