-- phpMyAdmin SQL Dump -- version 2.10.2 -- http://www.phpmyadmin.net -- -- 主機: localhost -- 建立日期: Nov 14, 2013, 09:06 AM -- 伺服器版本: 5.0.45 -- PHP 版本: 4.4.7 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- 資料庫: `web` -- -- -------------------------------------------------------- -- -- 資料表格式： `viewcount` -- CREATE TABLE `viewcount` ( `view_id` int(10) unsigned NOT NULL auto_increment, `view_time` datetime default NULL, `view_ip` varchar(20) collate utf8_unicode_ci default NULL, PRIMARY KEY (`view_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=170 ; -- -- 列出以下資料庫的數據： `viewcount` -- INSERT INTO `viewcount` VALUES (1, '2010-01-25 20:28:05', '127.0.0.1'); INSERT INTO `viewcount` VALUES (2, '2010-01-26 20:28:59', '127.0.0.1'); INSERT INTO `viewcount` VALUES (3, '2010-02-27 20:29:26', '127.0.0.1'); INSERT INTO `viewcount` VALUES (4, '2010-03-27 20:29:35', '127.0.0.1'); INSERT INTO `viewcount` VALUES (5, '2010-03-27 20:29:47', '127.0.0.1'); INSERT INTO `viewcount` VALUES (6, '2010-03-27 20:30:03', '127.0.0.1'); INSERT INTO `viewcount` VALUES (7, '2010-03-27 20:30:03', '127.0.0.1'); INSERT INTO `viewcount` VALUES (8, '2010-03-27 20:30:13', '127.0.0.1'); INSERT INTO `viewcount` VALUES (9, '2010-03-27 20:31:38', '127.0.0.1'); INSERT INTO `viewcount` VALUES (10, '2010-03-27 21:10:01', '127.0.0.1'); INSERT INTO `viewcount` VALUES (11, '2010-03-27 21:52:52', '127.0.0.1'); INSERT INTO `viewcount` VALUES (12, '2010-03-27 21:53:04', '127.0.0.1'); INSERT INTO `viewcount` VALUES (13, '2010-03-27 23:54:16', '127.0.0.1'); INSERT INTO `viewcount` VALUES (14, '2010-03-27 23:54:24', '127.0.0.1'); INSERT INTO `viewcount` VALUES (15, '2010-03-28 00:01:48', '127.0.0.1'); INSERT INTO `viewcount` VALUES (16, '2010-03-28 00:57:17', '127.0.0.1'); INSERT INTO `viewcount` VALUES (17, '2010-03-28 00:57:39', '127.0.0.1'); INSERT INTO `viewcount` VALUES (18, '2010-03-28 05:53:50', '127.0.0.1'); INSERT INTO `viewcount` VALUES (19, '2010-03-28 05:58:17', '127.0.0.1'); INSERT INTO `viewcount` VALUES (20, '2010-03-28 05:58:44', '127.0.0.1'); INSERT INTO `viewcount` VALUES (21, '2010-03-28 05:59:16', '127.0.0.1'); INSERT INTO `viewcount` VALUES (22, '2010-03-28 06:05:21', '127.0.0.1'); INSERT INTO `viewcount` VALUES (23, '2010-03-28 08:34:01', '127.0.0.1'); INSERT INTO `viewcount` VALUES (24, '2010-03-28 09:35:43', '127.0.0.1'); INSERT INTO `viewcount` VALUES (25, '2010-03-28 09:36:01', '127.0.0.1'); INSERT INTO `viewcount` VALUES (26, '2010-03-28 09:36:16', '127.0.0.1'); INSERT INTO `viewcount` VALUES (27, '2010-03-28 09:36:30', '127.0.0.1'); INSERT INTO `viewcount` VALUES (28, '2010-03-28 16:36:46', '127.0.0.1'); INSERT INTO `viewcount` VALUES (29, '2010-03-29 13:38:30', '127.0.0.1'); INSERT INTO `viewcount` VALUES (30, '2010-03-29 14:35:38', '127.0.0.1'); INSERT INTO `viewcount` VALUES (31, '2010-03-29 14:36:28', '127.0.0.1'); INSERT INTO `viewcount` VALUES (32, '2010-03-29 14:37:06', '127.0.0.1'); INSERT INTO `viewcount` VALUES (33, '2010-03-29 14:37:10', '127.0.0.1'); INSERT INTO `viewcount` VALUES (34, '2010-03-29 14:37:18', '127.0.0.1'); INSERT INTO `viewcount` VALUES (35, '2010-03-29 14:37:48', '127.0.0.1'); INSERT INTO `viewcount` VALUES (36, '2010-03-29 14:38:39', '127.0.0.1'); INSERT INTO `viewcount` VALUES (37, '2010-03-29 14:39:09', '127.0.0.1'); INSERT INTO `viewcount` VALUES (38, '2010-03-29 14:40:18', '127.0.0.1'); INSERT INTO `viewcount` VALUES (39, '2010-03-29 14:41:13', '127.0.0.1'); INSERT INTO `viewcount` VALUES (40, '2010-03-29 14:41:28', '127.0.0.1'); INSERT INTO `viewcount` VALUES (41, '2010-03-29 14:41:30', '127.0.0.1'); INSERT INTO `viewcount` VALUES (42, '2010-03-29 14:41:30', '127.0.0.1'); INSERT INTO `viewcount` VALUES (43, '2010-03-29 14:41:31', '127.0.0.1'); INSERT INTO `viewcount` VALUES (44, '2010-03-29 14:41:32', '127.0.0.1'); INSERT INTO `viewcount` VALUES (45, '2010-03-29 19:08:59', '127.0.0.1'); INSERT INTO `viewcount` VALUES (46, '2010-03-29 19:31:54', '127.0.0.1'); INSERT INTO `viewcount` VALUES (47, '2010-03-29 19:32:42', '127.0.0.1'); INSERT INTO `viewcount` VALUES (48, '2010-03-29 19:32:54', '127.0.0.1'); INSERT INTO `viewcount` VALUES (49, '2010-03-29 19:33:17', '127.0.0.1'); INSERT INTO `viewcount` VALUES (50, '2010-03-29 19:33:46', '127.0.0.1'); INSERT INTO `viewcount` VALUES (51, '2010-03-29 19:33:47', '127.0.0.1'); INSERT INTO `viewcount` VALUES (52, '2010-03-29 19:36:43', '127.0.0.1'); INSERT INTO `viewcount` VALUES (53, '2010-03-29 19:36:46', '127.0.0.1'); INSERT INTO `viewcount` VALUES (54, '2010-03-29 19:36:50', '127.0.0.1'); INSERT INTO `viewcount` VALUES (55, '2010-03-29 19:38:04', '127.0.0.1'); INSERT INTO `viewcount` VALUES (56, '2010-03-29 19:38:17', '127.0.0.1'); INSERT INTO `viewcount` VALUES (57, '2010-03-29 19:42:02', '127.0.0.1'); INSERT INTO `viewcount` VALUES (58, '2010-03-29 19:43:36', '127.0.0.1'); INSERT INTO `viewcount` VALUES (59, '2010-03-29 19:44:42', '127.0.0.1'); INSERT INTO `viewcount` VALUES (60, '2010-03-29 20:09:39', '127.0.0.1'); INSERT INTO `viewcount` VALUES (61, '2010-03-29 20:11:02', '127.0.0.1'); INSERT INTO `viewcount` VALUES (62, '2010-03-29 20:11:04', '127.0.0.1'); INSERT INTO `viewcount` VALUES (63, '2010-03-29 20:14:43', '127.0.0.1'); INSERT INTO `viewcount` VALUES (64, '2010-03-29 20:22:36', '127.0.0.1'); INSERT INTO `viewcount` VALUES (65, '2010-03-29 20:23:26', '127.0.0.1'); INSERT INTO `viewcount` VALUES (66, '2010-03-29 20:27:31', '127.0.0.1'); INSERT INTO `viewcount` VALUES (67, '2010-03-29 20:28:13', '127.0.0.1'); INSERT INTO `viewcount` VALUES (68, '2010-03-29 20:51:40', '127.0.0.1'); INSERT INTO `viewcount` VALUES (69, '2010-03-29 21:23:08', '127.0.0.1'); INSERT INTO `viewcount` VALUES (70, '2010-03-30 00:56:27', '127.0.0.1'); INSERT INTO `viewcount` VALUES (71, '2010-03-30 11:06:26', '127.0.0.1'); INSERT INTO `viewcount` VALUES (72, '2010-03-30 16:52:23', '127.0.0.1'); INSERT INTO `viewcount` VALUES (73, '2010-03-30 19:18:01', '127.0.0.1'); INSERT INTO `viewcount` VALUES (74, '2010-03-30 19:53:28', '127.0.0.1'); INSERT INTO `viewcount` VALUES (75, '2010-03-30 20:12:49', '127.0.0.1'); INSERT INTO `viewcount` VALUES (76, '2010-03-31 11:51:20', '127.0.0.1'); INSERT INTO `viewcount` VALUES (77, '2010-03-31 12:23:18', '127.0.0.1'); INSERT INTO `viewcount` VALUES (78, '2010-03-31 12:36:16', '127.0.0.1'); INSERT INTO `viewcount` VALUES (79, '2010-03-31 17:47:40', '127.0.0.1'); INSERT INTO `viewcount` VALUES (80, '2010-03-31 22:07:58', '127.0.0.1'); INSERT INTO `viewcount` VALUES (81, '2010-04-01 10:55:59', '127.0.0.1'); INSERT INTO `viewcount` VALUES (82, '2010-04-01 16:44:49', '127.0.0.1'); INSERT INTO `viewcount` VALUES (83, '2010-04-01 19:45:55', '127.0.0.1'); INSERT INTO `viewcount` VALUES (84, '2010-04-01 22:26:06', '127.0.0.1'); INSERT INTO `viewcount` VALUES (85, '2010-04-01 22:45:47', '127.0.0.1'); INSERT INTO `viewcount` VALUES (86, '2010-04-01 23:27:21', '127.0.0.1'); INSERT INTO `viewcount` VALUES (87, '2010-04-02 12:06:36', '127.0.0.1'); INSERT INTO `viewcount` VALUES (88, '2010-04-07 20:09:51', '127.0.0.1'); INSERT INTO `viewcount` VALUES (89, '2010-04-02 21:55:40', '127.0.0.1'); INSERT INTO `viewcount` VALUES (90, '2010-04-02 22:19:57', '127.0.0.1'); INSERT INTO `viewcount` VALUES (91, '2010-04-02 22:21:04', '127.0.0.1'); INSERT INTO `viewcount` VALUES (92, '2010-04-02 22:22:13', '127.0.0.1'); INSERT INTO `viewcount` VALUES (93, '2010-04-02 22:27:43', '127.0.0.1'); INSERT INTO `viewcount` VALUES (94, '2010-04-02 22:28:31', '127.0.0.1'); INSERT INTO `viewcount` VALUES (95, '2010-04-02 22:28:43', '127.0.0.1'); INSERT INTO `viewcount` VALUES (96, '2010-04-02 22:29:00', '127.0.0.1'); INSERT INTO `viewcount` VALUES (97, '2010-04-02 22:29:20', '127.0.0.1'); INSERT INTO `viewcount` VALUES (98, '2010-04-02 23:06:52', '127.0.0.1'); INSERT INTO `viewcount` VALUES (99, '2010-04-02 23:07:37', '127.0.0.1'); INSERT INTO `viewcount` VALUES (100, '2010-04-02 23:25:56', '127.0.0.1'); INSERT INTO `viewcount` VALUES (101, '2010-04-03 00:15:41', '127.0.0.1'); INSERT INTO `viewcount` VALUES (102, '2010-04-03 13:06:28', '127.0.0.1'); INSERT INTO `viewcount` VALUES (103, '2010-04-04 15:38:29', '127.0.0.1'); INSERT INTO `viewcount` VALUES (104, '2010-04-05 00:03:00', '127.0.0.1'); INSERT INTO `viewcount` VALUES (105, '2010-04-05 17:30:23', '127.0.0.1'); INSERT INTO `viewcount` VALUES (106, '2010-04-05 19:08:04', '127.0.0.1'); INSERT INTO `viewcount` VALUES (107, '2010-04-05 19:33:48', '127.0.0.1'); INSERT INTO `viewcount` VALUES (108, '2010-04-06 00:44:56', '127.0.0.1'); INSERT INTO `viewcount` VALUES (109, '2010-04-06 00:59:21', '127.0.0.1'); INSERT INTO `viewcount` VALUES (110, '2010-04-06 13:34:12', '127.0.0.1'); INSERT INTO `viewcount` VALUES (111, '2010-04-06 13:41:45', '127.0.0.1'); INSERT INTO `viewcount` VALUES (112, '2010-04-06 16:15:22', '127.0.0.1'); INSERT INTO `viewcount` VALUES (113, '2010-04-06 17:12:01', '127.0.0.1'); INSERT INTO `viewcount` VALUES (114, '2010-04-06 18:05:37', '127.0.0.1'); INSERT INTO `viewcount` VALUES (115, '2010-04-06 19:42:12', '127.0.0.1'); INSERT INTO `viewcount` VALUES (116, '2010-04-06 22:01:32', '127.0.0.1'); INSERT INTO `viewcount` VALUES (117, '2010-04-06 23:23:38', '127.0.0.1'); INSERT INTO `viewcount` VALUES (118, '2010-04-07 18:01:02', '127.0.0.1'); INSERT INTO `viewcount` VALUES (119, '2010-04-07 19:45:05', '127.0.0.1'); INSERT INTO `viewcount` VALUES (120, '2010-04-07 21:55:17', '127.0.0.1'); INSERT INTO `viewcount` VALUES (121, '2010-04-07 22:09:23', '127.0.0.1'); INSERT INTO `viewcount` VALUES (122, '2010-04-07 22:13:52', '127.0.0.1'); INSERT INTO `viewcount` VALUES (123, '2010-04-08 13:27:51', '127.0.0.1'); INSERT INTO `viewcount` VALUES (124, '2010-04-08 13:30:05', '127.0.0.1'); INSERT INTO `viewcount` VALUES (125, '2010-04-08 14:05:11', '127.0.0.1'); INSERT INTO `viewcount` VALUES (126, '2010-04-08 14:56:29', '127.0.0.1'); INSERT INTO `viewcount` VALUES (127, '2010-04-08 22:07:32', '127.0.0.1'); INSERT INTO `viewcount` VALUES (128, '2010-04-08 23:59:18', '127.0.0.1'); INSERT INTO `viewcount` VALUES (129, '2010-04-09 12:46:23', '127.0.0.1'); INSERT INTO `viewcount` VALUES (130, '2010-04-09 14:52:08', '127.0.0.1'); INSERT INTO `viewcount` VALUES (131, '2010-04-09 14:52:26', '127.0.0.1'); INSERT INTO `viewcount` VALUES (132, '2010-04-09 15:53:00', '127.0.0.1'); INSERT INTO `viewcount` VALUES (133, '2010-04-09 19:26:41', '127.0.0.1'); INSERT INTO `viewcount` VALUES (134, '2010-04-09 20:24:04', '127.0.0.1'); INSERT INTO `viewcount` VALUES (135, '2010-04-09 22:23:37', '127.0.0.1'); INSERT INTO `viewcount` VALUES (136, '2010-04-10 12:15:46', '127.0.0.1'); INSERT INTO `viewcount` VALUES (137, '2010-04-10 19:29:35', '127.0.0.1'); INSERT INTO `viewcount` VALUES (138, '2010-04-10 20:14:02', '127.0.0.1'); INSERT INTO `viewcount` VALUES (139, '2010-04-11 12:54:51', '127.0.0.1'); INSERT INTO `viewcount` VALUES (140, '2010-04-11 18:02:33', '127.0.0.1'); INSERT INTO `viewcount` VALUES (141, '2010-04-11 19:21:07', '127.0.0.1'); INSERT INTO `viewcount` VALUES (142, '2010-04-11 22:55:52', '127.0.0.1'); INSERT INTO `viewcount` VALUES (143, '2010-04-12 01:34:41', '127.0.0.1'); INSERT INTO `viewcount` VALUES (144, '2010-04-12 01:44:16', '127.0.0.1'); INSERT INTO `viewcount` VALUES (145, '2010-04-12 01:46:12', '127.0.0.1'); INSERT INTO `viewcount` VALUES (146, '2010-04-12 01:46:32', '127.0.0.1'); INSERT INTO `viewcount` VALUES (147, '2010-04-12 10:40:02', '127.0.0.1'); INSERT INTO `viewcount` VALUES (148, '2010-04-12 13:45:27', '127.0.0.1'); INSERT INTO `viewcount` VALUES (149, '2010-04-12 15:40:50', '127.0.0.1'); INSERT INTO `viewcount` VALUES (150, '2010-04-12 17:19:12', '127.0.0.1'); INSERT INTO `viewcount` VALUES (151, '2010-04-12 17:27:13', '127.0.0.1'); INSERT INTO `viewcount` VALUES (152, '2010-04-12 17:35:24', '127.0.0.1'); INSERT INTO `viewcount` VALUES (153, '2010-04-12 21:57:51', '127.0.0.1'); INSERT INTO `viewcount` VALUES (154, '2010-04-13 12:14:22', '127.0.0.1'); INSERT INTO `viewcount` VALUES (155, '2010-04-14 13:07:39', '127.0.0.1'); INSERT INTO `viewcount` VALUES (156, '2010-04-14 13:10:32', '127.0.0.1'); INSERT INTO `viewcount` VALUES (157, '2010-04-15 01:00:58', '127.0.0.1'); INSERT INTO `viewcount` VALUES (158, '2010-04-15 07:47:28', '127.0.0.1'); INSERT INTO `viewcount` VALUES (159, '2010-04-15 08:04:49', '127.0.0.1'); INSERT INTO `viewcount` VALUES (160, '2010-04-17 12:40:23', '127.0.0.1'); INSERT INTO `viewcount` VALUES (161, '2010-04-17 12:48:52', '127.0.0.1'); INSERT INTO `viewcount` VALUES (162, '2010-04-18 12:47:42', '127.0.0.1'); INSERT INTO `viewcount` VALUES (163, '2010-05-29 16:55:01', '127.0.0.1'); INSERT INTO `viewcount` VALUES (164, '2010-05-29 18:29:38', '127.0.0.1'); INSERT INTO `viewcount` VALUES (165, '2010-05-29 19:55:24', '127.0.0.1'); INSERT INTO `viewcount` VALUES (166, '2010-05-29 21:06:37', '127.0.0.1'); INSERT INTO `viewcount` VALUES (167, '2010-05-30 00:03:46', '127.0.0.1'); INSERT INTO `viewcount` VALUES (168, '2010-05-30 12:19:13', '127.0.0.1'); INSERT INTO `viewcount` VALUES (169, '2013-11-14 08:48:51', '127.0.0.1');