tokuhirom (owner)

Revisions

gist: 176254 Download_button fork
public
Public Clone URL: git://gist.github.com/176254.git
Embed All Files: show embed
Text only #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

mysql> create table foo ( p bit(32) default 0 );
Query OK, 0 rows affected (0.20 sec)
 
mysql> show create table foo;
+-------+----------------------------------------------------------------------------------------+
| Table | Create Table                                                                           |
+-------+----------------------------------------------------------------------------------------+
| foo   | CREATE TABLE `foo` (
  `p` bit(32) DEFAULT b'0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 | 
+-------+----------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
 
mysql> create table bar ( p bit(32) default '0' );
Query OK, 0 rows affected (0.08 sec)
 
mysql> show create table bar;
+-------+---------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                |
+-------+---------------------------------------------------------------------------------------------+
| bar   | CREATE TABLE `bar` (
  `p` bit(32) DEFAULT b'110000'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 | 
+-------+---------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)