Advertisement
Guest User

Untitled

a guest
May 25th, 2017
493
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.65 KB | None | 0 0
  1. mysql> CREATE TABLE `trades` (
  2. -> `id` int(10) unsigned NOT NULL,
  3. -> `symbol` char(8) NOT NULL,
  4. -> `time` char(12) NOT NULL,
  5. -> `price` float unsigned NOT NULL,
  6. -> `size` mediumint(8) unsigned NOT NULL,
  7. -> `exchange` char(1) NOT NULL,
  8. -> `code` char(1) NOT NULL,
  9. -> `bid` float unsigned NOT NULL,
  10. -> `ask` float unsigned NOT NULL,
  11. -> `vwap` double unsigned NOT NULL,
  12. -> `vwap_volume` int(10) unsigned NOT NULL,
  13. -> PRIMARY KEY (`id`),
  14. -> KEY `Index_2` (`symbol`,`time`),
  15. -> KEY `Index_3` (`time`)
  16. -> ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 MAX_ROWS=1000000000;
  17. 100513 16:41:06 [Note] NDB Binlog: CREATE TABLE Event: REPL$test/trades
  18. Query OK, 0 rows affected (0.57 sec)
  19.  
  20. 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';
  21.  
  22.  
  23. mysql> select * from trades;
  24. +----+--------+------+-------+------+----------+------+------+------+------+-------------+
  25. | id | symbol | time | price | size | exchange | code | bid | ask | vwap | vwap_volume |
  26. +----+--------+------+-------+------+----------+------+------+------+------+-------------+
  27. | 0 | MSFT | 1234 | 1.23 | 1234 | 2 | 1 | 1.34 | 1.34 | 1.45 | 1 |
  28. +----+--------+------+-------+------+----------+------+------+------+------+-------------+
  29. 1 row in set (0.03 sec)
  30.  
  31. mysql> SELECT symbol,length(symbol) FROM trades;
  32. +--------+----------------+
  33. | symbol | length(symbol) |
  34. +--------+----------------+
  35. | MSFT | 4 |
  36. +--------+----------------+
  37. 1 row in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement