2011-10-17から1日間の記事一覧
CREATE TABLE ranking ( user_id INT UNSIGNED NOT NULL COMMENT "ユーザID", score INT NOT NULL COMMENT "順位付けに使う値", rank INT UNSIGNED NOT NULL COMMENT "順位", PRIMARY KEY (user_id), INDEX USING BTREE (score) ); user_id score rank 1 100…
CREATE TABLE ranking ( user_id INT UNSIGNED NOT NULL COMMENT "ユーザID", score INT NOT NULL COMMENT "順位付けに使う値", rank INT UNSIGNED NOT NULL COMMENT "順位", PRIMARY KEY (user_id), INDEX USING BTREE (score) ); user_id score rank 1 100…