Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.5k views
in Technique[技术] by (71.8m points)

does storing MYSQL query in file is good practice? right now i write them into python file

my python file looks like that:

statement="SELECT DATE_FORMAT(`Date`,%s) AS  x, Sum(%s) As y FROM
   `covid19-db`.`covid-19` WHERE " 
                 "`Date` between %s  and %s GROUP BY Date;"


db_cursor.execute(statement,(dateFormat,case,start_date,CURRENT_DAY))
   result = db_cursor.fetchall()

is it necessary to store the query in a file?

question from:https://stackoverflow.com/questions/65652181/does-storing-mysql-query-in-file-is-good-practice-right-now-i-write-them-into-p

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...