8.sqlite3 数据库

zmjames2000

于 2019-09-10 09:37:03 发布

阅读量135

点赞数

CC 4.0 BY-SA版权

分类专栏：爬虫 python 文章标签：爬虫 sqlite3 数据库

本文链接：https://blog.youkuaiyun.com/zmjames2000/article/details/100689440

python 同时被 2 个专栏收录

56 篇文章

订阅专栏

爬虫

18 篇文章

订阅专栏

本文详细介绍如何使用Python的sqlite3模块创建数据库、建立表结构、插入数据、更新记录、查询信息及删除特定条目。通过具体代码示例，读者将学会基本的SQL语句在Python中的应用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

简单介绍

    import sqlite3
    
    conn = sqlite3.connect('test.db', timeout=10)
    print("Open database successfully")
    c = conn.cursor()
    sql = ""
    c.execute('''CREATE TABLE COMPANY
              (ID INT PRIMARY KEY     NOT NULL,
              NAME           TEXT    NOT NULL,
              AGE            INT     NOT NULL,
              ADDRESS        CHAR(50),
              SALARY         REAL);''')
    
    c.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) 
         		 VALUES (1, 'Paul', 32, 'California', 20000.00 )");
    
    c.execute("UPDATE COMPANY set SALARY = 25000.00 where ID=1")
    
    cursor = c.execute("SELECT id, name, address, salary  from COMPANY");
    for row in cursor:
       print "ID = ", row[0]
       print "NAME = ", row[1]
       print "ADDRESS = ", row[2]
       print "SALARY = ", row[3], "\n"
    
    c.execute("DELETE from COMPANY where ID=2;")
    
    c.execute(sql)
    conn.commit()
    conn.close()