Stupid-Tyro的博客

SQLSQL 结构化查询语言，1.创建数据库：create database name2.创建数据库中的表create table table_name(column_name1 data_type(size),列名 数据类型（表内列的最大长度）)3.显示某一列或几列的值select column_name,column_name from table_name与selec...

python-mysql创建数据库连接import mysql.connectormydb = mysql.connector.connect(host='localhost',db='scrapymysql',user='root',password='wzh960823',)创建数据库mycursor = mydb.cursor()mycursor.execute('...

目前主要的使用是插入数据import pymysql#建立连接db = pymysql.connect('local','database_username','database_password','database_name')#创建cursor对象cursor = cd.cursor()#sql插入格式sql = """INSERT INTO table_name (字段名) ...

爬虫复习import scrapy#创建类class scrapydata(scrapy.Spider): #name赋值，必备 name = 'scrapydata' #url start_urls = ['http://lab.scrapyd.cn/'] def parse(self,response): content = response.css('div.quote...

scrapy-mysqlitems.py用于接收content和authorimport scrapyclass ScrapymysqlItem(scrapy.Item): # define the fields for your item here like: # name = scrapy.Field() content = scrapy.Field() ...