全文検索:
- MySQL - 数値に変換してソート @02_freebsd:04_database:01_mysql
- | | 3869 | 18379424 | | 3869 | 18086912 | | 3173 | 17994708 | | 3173 | 178706... 88 | | 3173 | 17870688 | | 4933 | 170412 | | 3829 | 14502832 | | 3781 | NULL | +---------+-------------+ 12 rows in set (0.01 sec) </code> ===== こうすれば、数値に変換... | | 3869 | 18379424 | | 3869 | 18086912 | | 3173 | 17994708 | | 3173 | 178706
- 18 MySQLでALTER TABLEの進捗確認 @02_freebsd:04_database:01_mysql
- e; +------------+ | count(id) | +------------+ | 1273517123 | +------------+ 1 row in set (10 min 26.05 sec) $ bash alert_progress.sh 200000 200000 2000
- MySQLコマンド @02_freebsd:04_database:01_mysql
- root | | Y | | 127.0.0.1 | root | ... | | localhost | stats | 3cf31278467575ed | N | | localhost |... | | localhost | iline8 | 6e4d585d01239c27 | N | | localhost | eccu... --+-------------+------------------+------------+ 12 rows in set (0.00 sec) </code> ==== 権限の確認 ====