python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - sql-insert

Conditional increment of values in two rows after insert in MySQL

I currently have the following three tables in a football db: teams(name) season(name, beginning, end) game(id, Date, season, hometeam, awayteam, HomeTeamScore, AwayTeamScore) (hometeam, awayte...
test-img

user11626803

mysql

sql

triggers

sql-update

sql-insert

Votes: 0

Answers: 2

Latest Answer

Much easier than maintaining redundant data with triggers is to just have a view; this is just a basic sum of a union: create view stats as ( select season, team, sum(goalsscored) goalsscored, sum...
test-img

ysth

How to do an insert in the database with Python

I have a Python script that does the Moodle version check. After checking the Moodle version I would like to insert into the database but I am getting the following error: line 337 mycursor = db.curso...
test-img

Jhon Laurence

python

mysql

sql-insert

indentation

mysql-python

Votes: 0

Answers: 3

Latest Answer

You have a slight misunderstanding here, in any function in python you need to provide an indentation(tab) before you start writing any code, i.e. structure is def your_functionname(parameters) &l...
test-img

Polymath

How can I write an SQL update command using %s in psycopg2 with python

I am new to python, currently learning. So I am using the psycopg2 library to run postgresql query and have an insert command like this: cursor.execute( "INSERT INTO test_case (run_id...
test-img

Alapan Das

python

postgresql

sql-update

sql-insert

psycopg2

Votes: 0

Answers: 1

Latest Answer

Something like below: cursor.execute( """UPDATE test_run SET (status, project_name,total_time_in_ms, total_time_in_hr_min_sec) = (%s, %s, ...
test-img

Adrian Klaver

INSERT SQL records from one database to a second (where 2nd has an additional column)

I'd like to insert select records from Table A --> Table B (in this example case, different "databases" == different tables to not worry about ATTACH), where Table A has less columns than...
test-img

jbplasma

python

sql

sqlite

sqlalchemy

sql-insert

Votes: 0

Answers: 1

Latest Answer

You can use 'NewInfo' as a string literal in the SELECT statement: INSERT INTO B_Table (col1, col2, col3) SELECT col1, col2, 'NewInfo' FROM A_Table;
test-img

forpas

Posts

Questions

Blogs

Jobs