sqlite: INSERT using a variable for table name

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

sqlite: INSERT using a variable for table name

buran

Posts: 8,091

Threads: 154

Joined: Sep 2016

Reputation: 582

Feb-19-2019, 04:43 AM (This post was last modified: Feb-19-2019, 04:43 AM by buran.)

Fix your DB/schema design. Don't use separate table for each type. You need only one table for recepies. Recepy/dish type is just another table and extra column in recepies. Also I would I would not store each ingredient as separate column.

If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Find

Messages In This Thread

sqlite: INSERT using a variable for table name - by DT2000 - Feb-19-2019, 03:03 AM

RE: sqlite: INSERT using a variable for table name - by buran - Feb-19-2019, 04:43 AM

RE: sqlite: INSERT using a variable for table name - by DT2000 - Feb-22-2019, 10:27 PM

RE: sqlite: INSERT using a variable for table name - by DT2000 - Feb-23-2019, 06:28 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Insert 10gb csv files into sql table via python	mg24	2	1,998	Apr-28-2023, 04:14 PM Last Post: snippsat
	store all variable values into list and insert to sql_summary table	mg24	3	1,196	Sep-28-2022, 09:13 AM Last Post: Larz60+
	Insert into SQL Table only when Table is First Created?	Extra	4	1,513	Jun-28-2022, 07:50 AM Last Post: Pedroski55
	UPDATE SQLITE TABLE - Copy a fields content to another field.	andrewarles	14	4,503	May-08-2021, 04:58 PM Last Post: ibreeden
	Unable to Update SQLite Table	sambanerjee	5	3,017	Sep-30-2020, 12:21 PM Last Post: Larz60+
	How to create db table with SQLite and SQLAlchemy??	marcello86	1	2,345	Sep-02-2020, 03:05 PM Last Post: marcello86
	how to use items combobox in table name sqlite in python	hampython	1	2,721	May-24-2020, 02:17 AM Last Post: Larz60+
	Failed to insert record into MySQL table.Python type tuple cannot be converted	farah97	3	21,741	Dec-26-2019, 02:01 PM Last Post: buran
	Insert a variable in a Python > Cellular AT command	ElectronicsNut	1	2,127	Jul-07-2019, 02:26 PM Last Post: joe_momma
	Updating records 1 to n on an SQLite table	KevinBrown	2	2,684	Mar-30-2019, 05:02 PM Last Post: KevinBrown

Users browsing this thread: 1 Guest(s)

View a Printable Version

sqlite: INSERT using a variable for table name

User Panel Messages

Announcements