Python Forum
Running Sql query stored in CSV file
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Running Sql query stored in CSV file
#14
Output:
"select * from dual" '"select * from dual"'
This output clearly shows that you have double quotes around your SQL statement in the file.
Note that single quotes around the second print output is due to the fact that you print repr() of the string, not they are actually there, so it's not possible to remove them (line #16)
I told you file should look like this
Output:
SELECT * FROM dual;
just in case - don't put new line (i.e. don't hit ENTER) at the end of the line, even if it doesn't matter in SQL

here is Gist
https://gist.github.com/boyank/3b8f8a4c6...d2de45fdcc
Reply


Messages In This Thread
Running Sql query stored in CSV file - by purnima1 - Oct-02-2017, 06:15 AM
RE: Running Sql query stored in CSV file - by buran - Oct-02-2017, 06:56 AM
RE: Running Sql query stored in CSV file - by buran - Oct-02-2017, 08:25 AM
RE: Running Sql query stored in CSV file - by buran - Oct-02-2017, 09:01 AM
RE: Running Sql query stored in CSV file - by buran - Oct-02-2017, 09:12 AM
RE: Running Sql query stored in CSV file - by buran - Oct-03-2017, 11:15 AM
RE: Running Sql query stored in CSV file - by buran - Oct-04-2017, 10:17 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  error "cannot identify image file" part way through running hatflyer 0 834 Nov-02-2023, 11:45 PM
Last Post: hatflyer
  Web project and running a .py file emont 0 734 Dec-11-2022, 11:15 PM
Last Post: emont
  batch file for running python scipt in Windows shell MaartenRo 2 2,067 Jan-21-2022, 02:36 PM
Last Post: MaartenRo
  rows from sql query need to write to a file as columns sjcsvatt 6 2,577 Oct-09-2021, 12:45 AM
Last Post: snippsat
  write mariadb table rows query to each file? shams 1 2,015 Feb-02-2021, 04:10 PM
Last Post: buran
  Running A Parser In VSCode - And Write The Results Into A Csv-File apollo 5 4,869 Jan-14-2021, 08:58 PM
Last Post: snippsat
  WinError 87 while running .exe file Timych 0 2,485 Aug-06-2020, 02:36 PM
Last Post: Timych
  Write SQLite query result to file hjk6734 1 2,025 May-27-2020, 12:17 PM
Last Post: menator01
  problem running python file using cmd panzers 2 2,400 Dec-19-2019, 04:04 PM
Last Post: panzers
  Interpreter and running a .py file give different outputs PythonNPC 5 3,222 Jul-21-2019, 01:07 PM
Last Post: PythonNPC

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020