I am stuck and request help. I have an Sqlite3 table and code with PyQt5 in PyCharm. I want to insert id's latest row of table_1 into a "import" column in table_2 simultaneously when a button is click to make new record for/in table_2. [Fetch table_1 id's latest row number and insert into "import" column along with name1 and name2 (user input) text value in table_2 when a button is click.]
Table_1:
CREATE TABLE "table_1" ( "id" INTEGER UNIQUE, "first_name" TEXT, "last_name" TEXT, PRIMARY KEY("id" AUTOINCREMENT) )
id | first_name | last_name |
---|------------|-----------|
1 | Mike | Spiker |
2 | John | lastname |
Table_2:
CREATE TABLE "table_2" ( "import" INTEGER, "name1" TEXT, "name2" TEXT )
import | name1 | name2 |
-------|------------|-----------|
1 | apple | self |
1 | mango | import |
2 | tomato | stock |
2 | potato | trans |
I have google many website but could not find clue/answer to my problem. There are some code to insert value(s) into another table but they missed out on how to insert into along with capturing the txt_name1 & txt_name2 user's input values.
Thanks in advance.