Python Forum
Python Forum

Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: MySQLdb._exceptions.ProgrammingError: not enough arguments for format string.
Post: MySQLdb._exceptions.ProgrammingError: not enough a...
Hi...I have created a button to copy data from table1 to table2. The problem is I got this error: Error:MySQLdb._exceptions.ProgrammingError: not enough arguments for format stringThis is my code: cur...
 farah97 General Coding Help 0 3,342 Jan-22-2020, 03:49 AM
    Thread: How to display sentence only from the database
Post: How to display sentence only from the database
I get the data from the database and I want to display sentence only. But, instead..it just display id and also sentence in one column. Example table output that I got: ------------------------------...
 farah97 Web Scraping & Web Development 0 1,199 Jan-03-2020, 09:43 AM
    Thread: how to save the data from MySQL to CSV in Flask
Post: RE: how to save the data from MySQL to CSV in Flas...
thanks
 farah97 Web Scraping & Web Development 4 2,946 Jan-03-2020, 03:02 AM
    Thread: how to save the data from MySQL to CSV in Flask
Post: RE: how to save the data from MySQL to CSV in Flas...
I have tried your code, but got error: Error: File "c:/Users/User/Documents/first/app.py", line 78 while article = cur.fetchone(): ^ SyntaxError: invalid syntaxWhat's the problem...
 farah97 Web Scraping & Web Development 4 2,946 Dec-30-2019, 11:50 PM
    Thread: how to save the data from MySQL to CSV in Flask
Post: how to save the data from MySQL to CSV in Flask
Hi..I want to save the data from MySQL to CSV in Flask. The data that need to be saved, consists of id,q1 and q2. The problem is, it does not generate all the data. Instead, it just shown id,q1 and q2...
 farah97 Web Scraping & Web Development 4 2,946 Dec-30-2019, 03:56 PM
    Thread: How to insert data if not exists in mysql?
Post: How to insert data if not exists in mysql?
Hi...I want to insert the new data if it is not exist in MySQL. This is the code: mySql_insert_query = """INSERT INTO sent (q,polarity,senti) SELECT * FROM (SELECT %s,%s,%s) AS tmp WHERE NOT EXISTS (...
 farah97 General Coding Help 0 2,828 Dec-29-2019, 08:32 AM
    Thread: Failed to insert record into MySQL table.Python type tuple cannot be converted
Post: RE: Failed to insert record into MySQL table.Pytho...
I got Error:Failed to insert record into MySQL table Failed executing the operation; Not enough parameters for the SQL statement when do this code: records_to_insert = (row,sentiment_dict['compound'],...
 farah97 General Coding Help 3 21,610 Dec-26-2019, 01:04 PM
    Thread: Failed to insert record into MySQL table.Python type tuple cannot be converted
Post: Failed to insert record into MySQL table.Python ty...
I want to create sentiment analysis using Vader in Python and Mysql. The problem is, I got the error on mysql, especially when to insert the data into the database. The error that I got is Error:Fail...
 farah97 General Coding Help 3 21,610 Dec-26-2019, 12:26 PM

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020