Tagged Questions
0
votes
1answer
60 views
Mysqldb INSERT INTO syntax error in Python
I have an excel file which I am trying to put into mysql. There are 32 fields which I want to extract using the python plugin xlrd and put into mysql. The data is laid out like so:
My methodology ...
0
votes
1answer
46 views
Grouping SQL queries
Sometimes an application requires quite a few SQL queries before it can do anything useful. I was wondering if there is a way to send those as a batch to the database, to avoid the overhead of going ...
0
votes
1answer
221 views
Django db.connection.cursor.fetchone() returns emty result, when raw SQL doesn't
I have method in a cusom QuerySet that performs raw SQL query to database.
class QuerySet(models.query.QuerySet):
def get_short(self, language_code='en'):
"""Returns shortest name for ...
1
vote
1answer
263 views
sql dump file.. load to mysql
Ok first, please assume that this is the first time I will be writing a single alphabet of code in SQL.. so please please please... it would be very kind if you can explain me each step. :)
I am using ...
