# CrawlingNews

**Repository Path**: YYSWDD/CrawlingNews

## Basic Information

- **Project Name**: CrawlingNews
- **Description**: 爬取腾讯新闻热点新闻
- **Primary Language**: Python
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-03-22
- **Last Updated**: 2021-03-22

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# CrawlingNews

#### 介绍
爬取腾讯新闻热点新闻

#### 创建表sql语句

```
CREATE TABLE `news` (
  `id` varchar(255) COLLATE utf8_bin NOT NULL,
  `cms_id` varchar(25) COLLATE utf8_bin NOT NULL DEFAULT '',
  `url` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `title` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
  `summary` varchar(200) COLLATE utf8_bin DEFAULT NULL,
  `source` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `img` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `update_time` datetime NOT NULL,
  `text` longtext COLLATE utf8_bin NOT NULL,
  `in_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cms_id` (`cms_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
```