API tools faq
paste
Advertisement
Guest User

mysql example

a guest
Jul 6th, 2016
40
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.55 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.6.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Jul 06, 2016 at 04:34 PM
  7. -- Server version: 5.7.10-log
  8. -- PHP Version: 7.0.6
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Database: `temp`
  15. --
  16.  
  17. -- --------------------------------------------------------
  18.  
  19. --
  20. -- Table structure for table `tbl`
  21. --
  22.  
  23. CREATE TABLE `tbl` (
  24. `value` decimal(7,2) DEFAULT NULL,
  25. `pts` datetime NOT NULL,
  26. `ptshour` mediumint(8) UNSIGNED NOT NULL,
  27. `tshour` mediumint(8) UNSIGNED NOT NULL,
  28. `ts` datetime NOT NULL
  29. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  30.  
  31. --
  32. -- Dumping data for table `tbl`
  33. --
  34.  
  35. INSERT INTO `tbl` (`value`, `pts`, `ptshour`, `tshour`, `ts`) VALUES
  36. ('11.00', '2016-06-04 21:00:00', 21, 24, '2016-06-05 00:00:00'),
  37. ('9.00', '2016-06-04 22:00:00', 22, 24, '2016-06-05 00:00:00'),
  38. ('10.00', '2016-06-04 22:00:00', 22, 25, '2016-06-05 01:00:00'),
  39. ('29.00', '2016-06-04 23:00:00', 23, 24, '2016-06-05 00:00:00'),
  40. ('-1.00', '2016-06-04 23:00:00', 23, 25, '2016-06-05 01:00:00'),
  41. ('12.00', '2016-06-04 23:00:00', 23, 26, '2016-06-05 02:00:00'),
  42. ('6.00', '2016-06-05 00:00:00', 24, 25, '2016-06-05 01:00:00'),
  43. ('7.00', '2016-06-05 00:00:00', 24, 26, '2016-06-05 02:00:00'),
  44. ('18.00', '2016-06-05 00:00:00', 24, 27, '2016-06-05 03:00:00'),
  45. ('22.00', '2016-06-05 01:00:00', 25, 26, '2016-06-05 02:00:00'),
  46. ('24.00', '2016-06-05 01:00:00', 25, 27, '2016-06-05 03:00:00'),
  47. ('3.00', '2016-06-05 01:00:00', 25, 28, '2016-06-05 04:00:00'),
  48. ('10.00', '2016-06-05 02:00:00', 26, 27, '2016-06-05 03:00:00'),
  49. ('28.00', '2016-06-05 02:00:00', 26, 28, '2016-06-05 04:00:00'),
  50. ('19.00', '2016-06-05 02:00:00', 26, 29, '2016-06-05 05:00:00'),
  51. ('27.00', '2016-06-05 03:00:00', 27, 28, '2016-06-05 04:00:00'),
  52. ('21.00', '2016-06-05 03:00:00', 27, 29, '2016-06-05 05:00:00'),
  53. ('17.00', '2016-06-05 03:00:00', 27, 30, '2016-06-05 06:00:00'),
  54. ('5.00', '2016-06-05 04:00:00', 28, 29, '2016-06-05 05:00:00'),
  55. ('8.00', '2016-06-05 04:00:00', 28, 30, '2016-06-05 06:00:00'),
  56. ('15.00', '2016-06-05 04:00:00', 28, 31, '2016-06-05 07:00:00'),
  57. ('24.00', '2016-06-05 05:00:00', 29, 30, '2016-06-05 06:00:00'),
  58. ('2.00', '2016-06-05 05:00:00', 29, 31, '2016-06-05 07:00:00'),
  59. ('29.00', '2016-06-05 05:00:00', 29, 32, '2016-06-05 08:00:00'),
  60. ('28.00', '2016-06-05 06:00:00', 30, 31, '2016-06-05 07:00:00'),
  61. ('28.00', '2016-06-05 06:00:00', 30, 32, '2016-06-05 08:00:00'),
  62. ('2.00', '2016-06-05 06:00:00', 30, 33, '2016-06-05 09:00:00'),
  63. ('16.00', '2016-06-05 07:00:00', 31, 32, '2016-06-05 08:00:00'),
  64. ('8.00', '2016-06-05 07:00:00', 31, 33, '2016-06-05 09:00:00'),
  65. ('12.00', '2016-06-05 07:00:00', 31, 34, '2016-06-05 10:00:00'),
  66. ('23.00', '2016-06-05 08:00:00', 32, 33, '2016-06-05 09:00:00'),
  67. ('2.00', '2016-06-05 08:00:00', 32, 34, '2016-06-05 10:00:00'),
  68. ('12.00', '2016-06-05 08:00:00', 32, 35, '2016-06-05 11:00:00'),
  69. ('15.00', '2016-06-05 09:00:00', 33, 34, '2016-06-05 10:00:00'),
  70. ('28.00', '2016-06-05 09:00:00', 33, 35, '2016-06-05 11:00:00'),
  71. ('13.00', '2016-06-05 09:00:00', 33, 36, '2016-06-05 12:00:00'),
  72. ('27.00', '2016-06-05 10:00:00', 34, 35, '2016-06-05 11:00:00'),
  73. ('7.00', '2016-06-05 10:00:00', 34, 36, '2016-06-05 12:00:00'),
  74. ('25.00', '2016-06-05 10:00:00', 34, 37, '2016-06-05 13:00:00'),
  75. ('3.00', '2016-06-05 11:00:00', 35, 36, '2016-06-05 12:00:00'),
  76. ('13.00', '2016-06-05 11:00:00', 35, 37, '2016-06-05 13:00:00'),
  77. ('1.00', '2016-06-05 11:00:00', 35, 38, '2016-06-05 14:00:00'),
  78. ('9.00', '2016-06-05 12:00:00', 36, 37, '2016-06-05 13:00:00'),
  79. ('17.00', '2016-06-05 12:00:00', 36, 38, '2016-06-05 14:00:00'),
  80. ('10.00', '2016-06-05 12:00:00', 36, 39, '2016-06-05 15:00:00'),
  81. ('4.00', '2016-06-05 13:00:00', 37, 38, '2016-06-05 14:00:00'),
  82. ('8.00', '2016-06-05 13:00:00', 37, 39, '2016-06-05 15:00:00'),
  83. ('26.00', '2016-06-05 13:00:00', 37, 40, '2016-06-05 16:00:00'),
  84. ('-4.00', '2016-06-05 14:00:00', 38, 39, '2016-06-05 15:00:00'),
  85. ('23.00', '2016-06-05 14:00:00', 38, 40, '2016-06-05 16:00:00'),
  86. ('28.00', '2016-06-05 14:00:00', 38, 41, '2016-06-05 17:00:00'),
  87. ('26.00', '2016-06-05 15:00:00', 39, 40, '2016-06-05 16:00:00'),
  88. ('27.00', '2016-06-05 15:00:00', 39, 41, '2016-06-05 17:00:00'),
  89. ('9.00', '2016-06-05 15:00:00', 39, 42, '2016-06-05 18:00:00'),
  90. ('18.00', '2016-06-05 16:00:00', 40, 41, '2016-06-05 17:00:00'),
  91. ('15.00', '2016-06-05 16:00:00', 40, 42, '2016-06-05 18:00:00'),
  92. ('7.00', '2016-06-05 16:00:00', 40, 43, '2016-06-05 19:00:00'),
  93. ('7.00', '2016-06-05 17:00:00', 41, 42, '2016-06-05 18:00:00'),
  94. ('18.00', '2016-06-05 17:00:00', 41, 43, '2016-06-05 19:00:00'),
  95. ('0.00', '2016-06-05 17:00:00', 41, 44, '2016-06-05 20:00:00'),
  96. ('5.00', '2016-06-05 18:00:00', 42, 43, '2016-06-05 19:00:00'),
  97. ('15.00', '2016-06-05 18:00:00', 42, 44, '2016-06-05 20:00:00'),
  98. ('13.00', '2016-06-05 18:00:00', 42, 45, '2016-06-05 21:00:00'),
  99. ('5.00', '2016-06-05 19:00:00', 43, 44, '2016-06-05 20:00:00'),
  100. ('21.00', '2016-06-05 19:00:00', 43, 45, '2016-06-05 21:00:00'),
  101. ('16.00', '2016-06-05 19:00:00', 43, 46, '2016-06-05 22:00:00'),
  102. ('16.00', '2016-06-05 20:00:00', 44, 45, '2016-06-05 21:00:00'),
  103. ('22.00', '2016-06-05 20:00:00', 44, 46, '2016-06-05 22:00:00'),
  104. ('3.00', '2016-06-05 20:00:00', 44, 47, '2016-06-05 23:00:00'),
  105. ('25.00', '2016-06-05 21:00:00', 45, 46, '2016-06-05 22:00:00'),
  106. ('17.00', '2016-06-05 21:00:00', 45, 47, '2016-06-05 23:00:00'),
  107. ('24.00', '2016-06-05 22:00:00', 46, 47, '2016-06-05 23:00:00');
  108.  
  109. --
  110. -- Indexes for dumped tables
  111. --
  112.  
  113. --
  114. -- Indexes for table `tbl`
  115. --
  116. ALTER TABLE `tbl`
  117. ADD KEY `ts` (`ts`),
  118. ADD KEY `pts` (`pts`),
  119. ADD KEY `tsptshour` (`ptshour`,`tshour`);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!