abcarroll · July 30, 2020 02:33
diff --git a/binary-test.txt b/binary-test.txt
 ab@tower:~/vxx$ echo "drop database xxx" | sudo mysql
 ab@tower:~/vxx$ echo "create database if not exists xxx; use xxx; create table if not exists a( b blob ); insert into a (b) values(X'000a0af0ffdeadbeef');" | sudo mysql
 ab@tower:~/vxx$ echo "select * from xxx.a" | sudo mysql --raw -b > data
 ab@tower:~/vxx$ hd data 
 00000000  62 0a 00 0a 0a f0 ff de  ad be ef 0a              |b...........|
 0000000c
	ab@tower:~/vxx$ echo "drop database xxx" \| sudo mysql
	ab@tower:~/vxx$ echo "create database if not exists xxx; use xxx; create table if not exists a( b blob ); insert into a (b) values(X'000a0af0ffdeadbeef');" \| sudo mysql
	ab@tower:~/vxx$ echo "select * from xxx.a" \| sudo mysql --raw -b > data
	ab@tower:~/vxx$ hd data
	00000000 62 0a 00 0a 0a f0 ff de ad be ef 0a \|b...........\|
	0000000c