Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> CREATE TABLE `trades` (
- -> `id` int(10) unsigned NOT NULL,
- -> `symbol` char(8) NOT NULL,
- -> `time` char(12) NOT NULL,
- -> `price` float unsigned NOT NULL,
- -> `size` mediumint(8) unsigned NOT NULL,
- -> `exchange` char(1) NOT NULL,
- -> `code` char(1) NOT NULL,
- -> `bid` float unsigned NOT NULL,
- -> `ask` float unsigned NOT NULL,
- -> `vwap` double unsigned NOT NULL,
- -> `vwap_volume` int(10) unsigned NOT NULL,
- -> PRIMARY KEY (`id`),
- -> KEY `Index_2` (`symbol`,`time`),
- -> KEY `Index_3` (`time`)
- -> ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 MAX_ROWS=1000000000;
- 100513 16:41:06 [Note] NDB Binlog: CREATE TABLE Event: REPL$test/trades
- Query OK, 0 rows affected (0.57 sec)
- mysql> insert into trades set symbol = 'MSFT',time = '1234',price = '1.23',size = '1234',exchange = '2',code = '1',bid = '1.34',ask = '1.34',vwap='1.45',vwap_volume='1';
- mysql> select * from trades;
- +----+--------+------+-------+------+----------+------+------+------+------+-------------+
- | id | symbol | time | price | size | exchange | code | bid | ask | vwap | vwap_volume |
- +----+--------+------+-------+------+----------+------+------+------+------+-------------+
- | 0 | MSFT | 1234 | 1.23 | 1234 | 2 | 1 | 1.34 | 1.34 | 1.45 | 1 |
- +----+--------+------+-------+------+----------+------+------+------+------+-------------+
- 1 row in set (0.03 sec)
- mysql> SELECT symbol,length(symbol) FROM trades;
- +--------+----------------+
- | symbol | length(symbol) |
- +--------+----------------+
- | MSFT | 4 |
- +--------+----------------+
- 1 row in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement