0
votes
0answers
31 views

insert a Python list into a column in MySQL

I have list and I want to enter each element of that list into associated indexed cells of a column in MYSQL using Python. E.g lst = [11,22,33,44,55,66] MYSql column: Data 11 22 33 44 55 66. ...
0
votes
1answer
31 views

How do I remove a python egg?

This post (How to install MySQLdb (Python data access library to MySQL) on Mac OS X?) recommends cleaning up a MySQLdb installation by removing a python egg: "Step 3c: Remove the egg under ...
0
votes
0answers
17 views

Python/Django 1.5 DatabaseWrapper thread error

Throwing the following DatabaseError in Django 1.5.1 (and 1.5.0) and mysql when I runserver and attempt to load a local version of the web app: DatabaseError at / DatabaseWrapper objects ...
0
votes
3answers
23 views

How to insert a table consist of several dictionaries into MySQL tables?

I have the below result from my python code: [ {filename:'1,2',Name:'Gorge',registration number: '6657', registration date: '2012-09-10 14:31:13'}, {filename:'5,43',Name:'mazu',registration ...
0
votes
1answer
34 views

Connecting Python, MySQL and HTML [closed]

Ok so here's an overview of what I'm trying to do. I'm reading data from a GSM modem and I am storing this in a database. I'm doing this using a Python script and a MySQL database. So here Python ...
0
votes
3answers
43 views

What's the best way to automate running MySQL scripts on several databases on a daily basis? [closed]

What's the best way to automatically query several dozen MySQL databases with a script on a nightly basis? The script usually returns no results, so I'd ideally have it email or notify me if any are ...
0
votes
1answer
19 views

Unable to Insert into MySQL via Python and pymysql

I've got a table with 9 columns, the first three are all text and the last 6 are setup as INT's. When I insert into the text fields everything works as expected conn = pymysql.connect(host='', ...
0
votes
2answers
36 views

How to put info of a text file in a tuple to be convertible to SQL table?

I have several text files that contain specific information.I need to extract the required info from the files and put them in a MySQL table. The files contain several lines of info but I only need ...
0
votes
1answer
31 views

Python: MySQL connection is open, but can't create cursor

I'm trying to open a cursor to a MySQL-DB. But I'm getting this error: 'NoneType' object has no attribute 'cursor' Here is a small sourcecode: class Sample: def __init__(self): self.conn = ...
0
votes
3answers
41 views

Installing MySQl Python on Mac OSX

I've racked my brain, searched Google, read StackOverflow, and spent hours trying to figure this out to no avail. Long story short. When I write the following: sudo easy_install MySQL-python I ...
0
votes
1answer
32 views

How can you convert datetime.date from mysql into unix timestamp

Have spent a few hours trying to figure this out unsuccessfully. I've imported some 'date' (not datetime) fields from MySQL into a python list. If I print the list, the values will show up as: ...
0
votes
0answers
52 views

Converting php app to python app (very simple one) [closed]

I've made a web app for accounting for my fathers need. It's very simple, basically a jquery table with add delete edit buttons, and simple php backend for fetching from MySql. Now the jQuery plugin i ...
1
vote
4answers
27 views

TypeError: not all arguments converted during string formatting when inserting with parameters

I'm trying to insert an interger, a string and a list as a single record into a database, but am striking an error. Here is my code: values=nprnd.randint(10, size=48) #NUMPY ARRAY valuelist= ...
0
votes
2answers
33 views

SQL query to show results + or - 30mins than what is stored in table Python

I'm new to Python and using MySqldb and in need of a bit of help. I have the below code in a python script to search a table in my database to find any ids of meetings that have today's date. ...
1
vote
1answer
35 views

How to print standard/native MySQL output on the screen?

As per the title say: Is there a way to print standard/native MySQL output on the screen? I'm talking about, e.g. something like this: san@pcjq:~$ mysql -uroot -p mysql -t -e "SELECT Host,User FROM ...

1 2 3 4 5 156
15 30 50 per page