没有合适的资源?快使用搜索试试~ 我知道了~
lightdata資料規格表資料表名稱lightdata用途亮度資料表欄位名稱型態大小索引用途IdIntPrimary key主鍵(自動新增資料)dataflo
资源详情
资源评论
资源推荐
lightdata 資料規格表
資料表名稱
lightdata
用途
亮度資料表
欄位名稱
型態
大小
索引
用途
Id
Int
Primary key
主鍵(自動新增資料)
data
float
16
亮度資料
dataupdat
e
timestamp
更新資料資時間戳記
DEFAULT
CURRENT_TIMESTA
MP
ON UPDATE
CURRENT_TIMESTA
MP
SQL
-- phpMyAdmin SQL Dump
-- version 3.3.5
-- http://www.phpmyadmin.net
--
-- 主機: localhost
-- 建立日期: May 11, 2015, 02:21 PM
-- 伺服器版本: 5.1.49
-- PHP 版本: 5.2.14
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS
*/;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION
*/;
/*!40101 SET NAMES utf8 */;
--
-- 資料庫: `iot`
--
-- --------------------------------------------------------
--
-- 資料表格式: `lightdata`
--
CREATE TABLE IF NOT EXISTS `lightdata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`data` float NOT NULL,
`dataupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21719 ;
--
-- 列出以下資料庫的數據: `lightdata`
--
INSERT INTO `lightdata` (`id`, `data`, `dataupdate`) VALUES
(1, 43534, '2015-05-04 16:47:55'),
(2, 43534, '2015-05-04 16:48:03'),
(3, 43534, '2015-05-04 16:48:03'),
(4, 43534, '2015-05-04 16:48:04'),
(5, 43534, '2015-05-04 16:48:04'),
(6, 45, '2015-05-04 18:47:45'),
(7, 45, '2015-05-04 18:47:47'),
(8, 16, '2015-05-04 22:35:49'),
(9, 0, '2015-05-04 23:12:31'),
(10, 0, '2015-05-04 23:12:34'),
(11, 0, '2015-05-04 23:12:37'),
(12, 0, '2015-05-04 23:12:40'),
(13, 0, '2015-05-04 23:12:50'),
(14, 0, '2015-05-04 23:12:53'),
(15, 0, '2015-05-04 23:12:57'),
(16, 0, '2015-05-04 23:13:00'),
(17, 0, '2015-05-04 23:13:03'),
(18, 0, '2015-05-04 23:13:06'),
(19, 0, '2015-05-04 23:13:09'),
(20, 0, '2015-05-04 23:13:12'),
(21, 0, '2015-05-04 23:13:15'),
(22, 0, '2015-05-04 23:13:18'),
(23, 0, '2015-05-04 23:13:21'),
(24, 0, '2015-05-04 23:13:24'),
(25, 0, '2015-05-04 23:13:27'),
(26, 0, '2015-05-04 23:13:30'),
(27, 0, '2015-05-04 23:13:33'),
(28, 0, '2015-05-04 23:13:36'),
(29, 0, '2015-05-04 23:13:40'),
(30, 0, '2015-05-04 23:13:43'),
(31, 0, '2015-05-04 23:13:46'),
(32, 0, '2015-05-04 23:13:49'),
(33, 0, '2015-05-04 23:13:52'),
(34, 0, '2015-05-04 23:13:55'),
(35, 0, '2015-05-04 23:13:58'),
(36, 19, '2015-05-04 23:14:01'),
(37, 19, '2015-05-04 23:14:04'),
(38, 18, '2015-05-04 23:14:07'),
(39, 0, '2015-05-04 23:14:19'),
(40, 0, '2015-05-04 23:14:23'),
(41, 0, '2015-05-04 23:14:26'),
(42, 0, '2015-05-04 23:14:29'),
(43, 0, '2015-05-04 23:14:32'),
(44, 0, '2015-05-04 23:14:35'),
(45, 0, '2015-05-04 23:14:38'),
(46, 0, '2015-05-04 23:14:41'),
(47, 0, '2015-05-04 23:14:44'),
(48, 0, '2015-05-04 23:14:47'),
(49, 19, '2015-05-04 23:14:59'),
(50, 19, '2015-05-04 23:15:02'),
(51, 19, '2015-05-04 23:15:05'),
(52, 19, '2015-05-04 23:15:08'),
(53, 19, '2015-05-04 23:15:11'),
(54, 19, '2015-05-04 23:15:14'),
(55, 18, '2015-05-04 23:15:18'),
(56, 17, '2015-05-04 23:15:21'),
(57, 16, '2015-05-04 23:15:24'),
(58, 15, '2015-05-04 23:15:27'),
(59, 15, '2015-05-04 23:15:30'),
(60, 16, '2015-05-04 23:15:33'),
(61, 17, '2015-05-04 23:15:36'),
(62, 17, '2015-05-04 23:15:39'),
(63, 18, '2015-05-04 23:15:42'),
(64, 19, '2015-05-04 23:15:53'),
(65, 19, '2015-05-04 23:15:56'),
(66, 19, '2015-05-04 23:15:59'),
(67, 19, '2015-05-04 23:16:02'),
(68, 19, '2015-05-04 23:16:05'),
(69, 17, '2015-05-04 23:16:08'),
(70, 38, '2015-05-04 23:16:11'),
(71, 118, '2015-05-04 23:16:14'),
(72, 10894, '2015-05-04 23:16:17'),
(73, 90, '2015-05-04 23:16:21'),
(74, 224, '2015-05-04 23:16:24'),
(75, 65, '2015-05-04 23:16:27'),
(76, 1051, '2015-05-04 23:16:30'),
(77, 55, '2015-05-04 23:16:33'),
(78, 53, '2015-05-04 23:16:36'),
(79, 197, '2015-05-04 23:16:39'),
(80, 59, '2015-05-04 23:16:42'),
(81, 59, '2015-05-04 23:16:45'),
(82, 59, '2015-05-04 23:16:48'),
(83, 60, '2015-05-04 23:16:51'),
(84, 59, '2015-05-04 23:16:54'),
(85, 59, '2015-05-04 23:16:57'),
(86, 59, '2015-05-04 23:17:01'),
(87, 59, '2015-05-04 23:17:04'),
(88, 58, '2015-05-04 23:17:07'),
(89, 55, '2015-05-04 23:17:10'),
(90, 56, '2015-05-04 23:17:13'),
(91, 57, '2015-05-04 23:17:16'),
(92, 57, '2015-05-04 23:17:19'),
(93, 58, '2015-05-04 23:17:22'),
(94, 58, '2015-05-04 23:17:25'),
(95, 58, '2015-05-04 23:17:28'),
(96, 59, '2015-05-04 23:17:31'),
(97, 58, '2015-05-04 23:17:34'),
(98, 58, '2015-05-04 23:17:37'),
(99, 57, '2015-05-04 23:17:40'),
(100, 54, '2015-05-04 23:17:44'),
(101, 53, '2015-05-04 23:17:47'),
(102, 57, '2015-05-04 23:17:50'),
(103, 57, '2015-05-04 23:17:53'),
(104, 57, '2015-05-04 23:17:56'),
(105, 54, '2015-05-04 23:17:59'),
(106, 50, '2015-05-04 23:18:02'),
(107, 57, '2015-05-04 23:18:05'),
(108, 57, '2015-05-04 23:18:08'),
(109, 58, '2015-05-04 23:18:11'),
(110, 56, '2015-05-04 23:18:14'),
(111, 54, '2015-05-04 23:18:17'),
(112, 54, '2015-05-04 23:18:20'),
(113, 56, '2015-05-04 23:18:23'),
(114, 56, '2015-05-04 23:18:26'),
(115, 57, '2015-05-04 23:18:30'),
(116, 57, '2015-05-04 23:18:33'),
(117, 55, '2015-05-04 23:18:36'),
剩余573页未读,继续阅读
小埋妹妹
- 粉丝: 22
- 资源: 344
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0