menu

Recent questions tagged sqlite

1 vote
1 answer
How do I delete multiple rows from a table? Hello, everyone! There are several columns in the table, one of them with the date of the species: 2020-09-27T17:00:00.000Z. I need to delete several rows with old dat ...
by isergeevich666
asked Sep 24, 2021
1 vote
1 answer
image
How to process Django form data? I'm making my own project and studying Django at the same time. Project goal: Make a convenient mechanism for slicing IP-networks for the necessary masks. Keep a record ...
by 0ldn0mad
asked Sep 24, 2021
1 vote
1 answer
How to work asynchronously with sqlite3? Hello! I can't figure out the database in nodejs. On the input: the list of pages to be parsed is stored in the database The script goes to the page gets the necessar ...
by jslby
asked Sep 24, 2021
1 vote
1 answer
How do I access the last row in a sqlite table with django? Good afternoon, I need to access the last item in the sqlite database through django by using User.objects.values()-1.get(id), but negative indexing is not supported i ...
by Andrei1penguin1
asked Sep 24, 2021
1 vote
1 answer
Why is only the first table value updated? There is a code like: for i in cursor.execute(f"PRAGMA table_info(userResource)"): if y < 2: y+=1 else: cursor.execute(f"UPDATE userResource SET {i} = 0 WHERE I ...
by kibergile
asked Sep 22, 2021
1 vote
1 answer
How do I output a value to sqlite3? how do I find all the rows in the database, where user_id = msg.chat.id. Code below user_id = msg.chat.id.#тут коннект к бдcur.execute("SELECT balance FROM orders WHE ...
by srgvac
asked Sep 21, 2021
1 vote
1 answer
How do I solve the problem in telebot/sqlite3? How do I get all the people who started the bot into the database? import sqlite3import telebotbot = telebot.TeleBot('Токен')db = sqlite3.connect('TG.db', check_same_t ...
by MrSel
asked Sep 20, 2021
1 vote
1 answer
Can I use comparative operations in WHERE-sqlite? Can I use comparative operations in WHERE? For example <=, >=, != ? If so, what is the correct use case? ...
by mlneko
asked Sep 20, 2021
1 vote
1 answer
What caused the error? Hi Here is the error itself: File "C:\Users\fyodrro\AppData\Local\Programs\Python\Python38-32\lib\site-packages\telebot\util.py", line 60, in run task(args, kwargs ...
by srgvac
asked Sep 20, 2021
1 vote
1 answer
How do I compare data from a table with zero? Tell me how you can compare data from a table with zero There is such a code: @bot.command(aliases = 'warn')async def __warn(ctx, member: discord.Member = None, arg: ...
by delam0re
asked Sep 20, 2021
1 vote
1 answer
What is the best datatype to use for the key in SQL? The PRIMARY KEY column stores the IMEI. What is the best datatype to make SELECT/UPDATE with WHERE by key faster? You can essentially put INT, since there are only nu ...
by TomRiddle
asked Sep 19, 2021
1 vote
3 answers
I want to create an app to prepare for the exam on the android using java, what technology stack should I learn? is the topic of my thesis, in the application should be to study materials and tests with questions and answer options, that is, the user first learns the material, then ...
by Tillthecoyote
asked Sep 19, 2021
1 vote
3 answers
How do I add information to a sqlite3 table? I'm wondering if it's possible to add text to a sqlite3 cell if the cell already has information written in it. If so, how?) ...
by swpavlov
asked Sep 18, 2021
1 vote
2 answers
Why is the SQLite3 record not deleted? You need to delete the clan_id entry. cursor.execute("DELETE clan_id FROM clans WHERE owner_id = {}".format(ctx.author.id)) Error: sqlite3.OperationalError: near "clan_ ...
by 20two_may
asked Sep 18, 2021
1 vote
2 answers
C#: Import a large csv file into a SQLite database. How to do this? Give me a good way to migrate big data (1 million rows, 12 columns) from csv file to SQLite database (without iterating in loop, slow and inefficient). ...
by Samyrro054
asked Sep 17, 2021
1 vote
2 answers
How do I check for a specific number in a database (SQLite)? I have a sqlite database with the following columns: telegram_id, username, status How to make the database is searched for all tables where the status is 3. If = 3 the ...
by pythonnovi4ok
asked Apr 4, 2021
1 vote
6 answers
What is the best way to put a sqlite base on the network? You need to place the sqlite base on a resource that is connected to the network. Now I use sshfs (the choice is random) and experience frequent base crashes, which so f ...
by Insaned
asked Apr 4, 2021
1 vote
1 answer
Why doesn't the migration to SQLITE create a foreign key? Listen, people, faced with this country bullshit, I want that clever people enlighten me. I have ORM Doctrine and a sqlite database in my project The essence looks like ...
by MasterCopipaster
asked Apr 1, 2021
1 vote
2 answers
Why am I getting the error "sqlite3.OperationalError: no such column: test"? There is a table cursor_voice.execute("""CREATE TABLE IF NOT EXISTS voice_data( c_name TEXT, c_id INT, v_name TEXT, v_id INT ...
by old_stalin
asked Apr 1, 2021
1 vote
2 answers
Where does "No such column" in SQLite3 come from? There is a block of code like this: import sqlite3sql.execute("""CREATE TABLE IF NOT EXISTS users ( login TEXT, password TEXT, сash INT)""")db.commit()db = sqli ...
by paralolik
asked Mar 30, 2021