MySQLdb, problem with query with user-defined variables

Thread Rating:

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

Thread Modes

MySQLdb, problem with query with user-defined variables

nilamo
Last Thursdayist
Super Moderators

Posts: 3,458

Threads: 101

Joined: Sep 2016

Reputation: 143

Feb-03-2017, 06:10 PM

Ok, so it looks like you're only using those variables as sort of config values, since you never modify them. Why not eliminate them entirely, define the values in python, and pass them to .execute()?

OR, you can try passing multi=True to .execute():
https://dev.mysql.com/doc/connector-pyth...ecute.html

Find

Messages In This Thread

MySQLdb, problem with query with user-defined variables - by buran - Feb-01-2017, 09:09 PM

RE: MySQLdb, problem with query with user-defined variables - by nilamo - Feb-03-2017, 05:06 PM

RE: MySQLdb, problem with query with user-defined variables - by buran - Feb-03-2017, 05:47 PM

RE: MySQLdb, problem with query with user-defined variables - by nilamo - Feb-03-2017, 05:52 PM

RE: MySQLdb, problem with query with user-defined variables - by buran - Feb-03-2017, 06:05 PM

RE: MySQLdb, problem with query with user-defined variables - by nilamo - Feb-03-2017, 06:10 PM

RE: MySQLdb, problem with query with user-defined variables - by buran - Feb-03-2017, 06:16 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	A problem with defining variables	meru120	7	4,965	Jul-05-2024, 06:06 PM Last Post: deanhystad
	User-defined function to reset variables?	Mark17	3	3,199	May-25-2022, 07:22 PM Last Post: Gribouillis
	Multiple user defined plots with secondary axes using for loop	maltp	1	2,582	Apr-30-2022, 10:19 AM Last Post: maltp
	WHILE Loop - constant variables NOT working with user input boundaries	C0D3R	4	2,513	Apr-05-2022, 06:18 AM Last Post: C0D3R
	Setting permanent user variables in Windows	coder420	2	2,149	Jan-04-2022, 10:42 AM Last Post: Larz60+
	Problem Using SQL Placeholder In MySQL Query	AdeS	11	9,916	Jul-31-2021, 12:19 AM Last Post: Pedroski55
	Problem restricting user input in my rock paper scissors game	ashergreen	6	6,363	Mar-25-2021, 03:54 AM Last Post: deanhystad
	Running scripts and location of saved interpreted user-defined classes and functions	leodavinci1990	3	3,378	Aug-25-2020, 03:43 AM Last Post: micseydel
	python library not defined in user defined function	johnEmScott	2	5,029	May-30-2020, 04:14 AM Last Post: DT2000
	Problem with user defined main menu function	stefzeer	3	3,283	Mar-27-2020, 06:12 AM Last Post: buran

Users browsing this thread: 1 Guest(s)

View a Printable Version

MySQLdb, problem with query with user-defined variables

User Panel Messages

Announcements