これまでは普通の1万円~2万円くらいのオフィスチェアしか使ったことがありませんでしたがコンテッサは完全に別格。座り心地はもちろん、稼動部が多いのには驚かされた。自転車のブレーキケーブルみたいのがついてて、ボタンをぽちっと押すだけで高さとか角度とかが調節できる。
たとえるなら、普通のオフィスチェアがソフビ人形で、コンテッサは全身フル稼働の超合金ロボ、という感じです。
これがマイコンテッサの雄姿だ!
腰が痛い人や、座り仕事が多い人におすすめです。
楽天で「コンテッサ」を探す!
$title = mb_convert_encoding($title, "UTF-8", "auto");
$title = mb_convert_encoding($title, "UTF-8", "ASCII,JIS,UTF-8,EUC-JP,SJIS");
mysqlshow
mysqlshow [dbname]
$ mysql -u root mysql
mysql> update user set Password=password('hissql') where user='root';
$ mysqladmin -u root password [newpassword]
show databases;
show tables from [dbname];
show fields from [tablename] from [dbname];
select * from [tablename];
ex) mysql> select * from test_table;
insert into [tablename] ([Field],[Field],......) values (*,*,....);
ex) mysql> insert into test_table (hoge,moe) values (1,'aa');
update [tablename] set [Field]='value' where [Field] = 'value';
ex) mysql> update test_table set hoge=2 where moe='aa';
delete from [tablename] where....;
ex) mysql> delete from shintaro where hoge=1;
create table [tablename] (field kata,field kata);
ex) mysql> create table test_table (num int(2),moji char(2));
mysql> select count(*) from [tablename];
alter table OLDTBLNAME rename to NEWTBLNAME;
alter table TBLNAME add column (COLNAME DATATYPE);
alter table TBLNAME drop column COLNAME;
alter table TBLNAME add index IDXNAME (IDXCOLUMN);
mysql> grant all privileges on *.* to mysql@localhost identified by 'yoursql' with grant option;
mysql> grant all privileges on *.* to mysql@"%" identified by 'yoursql' with grant option;
mysql> GRANT ALL PRIVILEGES ON *.* TO [username]@localhost IDENTIFIED BY '[password]' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO [username]@"%" IDENTIFIED BY '[password]' WITH GRANT OPTION;
mysql>use DBNAME;
mysql>create database DBNAME;
mysql>drop database DBNAME;
$ mysql DATABASE_NAME < temp.sql
$ mysql test > out.txt
mysql> select * from test_table;
mysql> quit
/usr/local/mysql/bin/mysqldump --all-databases > /path/to/backup_dir/dump.dat -u root --password=[password]
mysql> load data local infile "hoge.csv" into table TABLE_NAME;
mysqlimport --local --fields-terminated-by=',' DBNAME /FULL/PATH/TABLENAME.txt
mysql -u root --password=[password] TARGET_DB < batch_sql.txt
mysqld_safe --log &
update TABLE set column = replace(column, "置換前ワード", "置換後ワード");
select
DATE_FORMAT(current_date, '%Y/%m/%d') as today,
DATE_FORMAT(current_date, '%Y/%m') as this_month,
DATE_FORMAT(DATE_ADD(current_date, INTERVAL -1 MONTH), '%Y/%m') as before_month;
# mysqladmin status
# mysqladmin variables
# myisamchk /usr/local/var/DBNAME/TBLNAME.MYI
# myisamchk -d /usr/local/var/DBNAME/TBLNAME.MYI
#myisamchk -r /usr/local/var/DBNAME/TBLNAME.MYI
#myisamchk -o /usr/local/var/DBNAME/TBLNAME.MYI