Skip to content

Instantly share code, notes, and snippets.

@kou
Created October 18, 2012 03:58
Show Gist options
  • Save kou/3909792 to your computer and use it in GitHub Desktop.
Save kou/3909792 to your computer and use it in GitHub Desktop.
mroonga BIGINT UNSIGNED test
mysql> CREATE TABLE ids (id BIGINT UNSIGNED) ENGINE=mroonga DEFAULT CHARSET=utf8;
mysql> INSERT INTO ids VALUES(1);
mysql> SELECT * FROM ids;
id
1
mysql> DELETE FROM ids where id = 1;
mysql> SELECT * FROM ids;
id
CREATE TABLE ids (
id BIGINT UNSIGNED
) ENGINE=mroonga DEFAULT CHARSET=utf8;
INSERT INTO ids VALUES(1);
SELECT * FROM ids;
DELETE FROM ids where id = 1;
SELECT * FROM ids;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment