{"flag":true,"single":true,"pageTitle":"Mysqlite commands in Python","post":{"id":235,"user_id":"1","slug":"mysqlite-commands-in-python-e8xt","title":"Mysqlite commands in Python","body":"

1.IMPORT SQL LITE AND CREATE DB<\/strong><\/p>\r\n

import sqlite3\r\nconn = sqlite3.connect('test.db') #create db or connect if already exist<\/code><\/pre>\r\n
 <\/p>\r\n
2. CREATE TABLE<\/strong><\/p>\r\n
conn.execute('''CREATE TABLE questions\r\n         (id INTEGER PRIMARY KEY NOT NULL,\r\n         question_url    TEXT NOT NULL,\r\n         status            INTEGER     NOT NULL DEFAULT 0,\r\n         Upvotes        INTEGER,\r\n         downvotes        INTEGER);''')<\/code><\/pre>\r\n
 <\/p>\r\n
3.INSERT RECORDS<\/strong><\/p>\r\n
conn.execute(\"INSERT INTO questions (question_url,status,Upvotes,downvotes) \\\r\n      VALUES ('https:\/\/status.com', 0, 0, 0 )\");\r\nconn.commit()<\/code><\/pre>\r\n
 <\/p>\r\n
4.SELECT DATA<\/strong><\/p>\r\n
cursor = conn.execute(\"SELECT id, question_url, status, Upvotes, downvotes from questions\")\r\nfor row in cursor:\r\n   print \"ID = \", row[0]\r\n   print \"question_url = \", row[1]\r\n   print \"status = \", row[2]\r\n   print \"Upvotes = \", row[3], \"\\n\"<\/code><\/pre>\r\n
 <\/p>\r\n
5.UPDATE DATA <\/strong><\/p>\r\n
conn.execute(\"UPDATE questions set status = 25 where ID = 1\")\r\nconn.commit()<\/code><\/pre>\r\n
 <\/p>\r\n
6. DELETE DATA<\/strong><\/p>\r\n
conn.execute(\"DELETE from questions where ID = 2;\")\r\nconn.commit()<\/code><\/pre>\r\n
 <\/p>\r\n
7. CLOSE THE CONNECTION<\/strong><\/p>\r\n
conn.close()<\/code><\/pre>","category_id":"5","is_private":"0","created_at":"2023-12-26T09:54:24.000000Z","updated_at":"2023-12-26T09:54:24.000000Z","category":{"id":5,"user_id":"1","name":"Python","slug":"python-6gqr","parent_id":null,"created_at":"2023-03-16T12:36:56.000000Z","updated_at":"2023-03-16T12:36:56.000000Z"},"user":{"id":1,"name":"R GONDAL","email":"rizikmw@gmail.com","email_verified_at":null,"two_factor_confirmed_at":null,"current_team_id":"1","profile_photo_path":null,"created_at":"2023-03-12T10:49:33.000000Z","updated_at":"2025-01-10T12:59:00.000000Z","profile_photo_url":"https:\/\/ui-avatars.com\/api\/?name=R+G&color=7F9CF5&background=EBF4FF"}},"pageDesc":"1.IMPORT SQL LITE AND CREATE DB import sqlite3 conn = sqlite3.connect('test.db') #create db or connect if already exist   2. CREATE TAB - Mysqlite commands in Python (Updated: December 26, 2023) - Read more about Mysqlite commands in Python at my programming site [SITE]","categories":[]}