MySQL and Python -- Int() adding "L"

Asked Jan 02 '14 at 20:33

Active Jan 02 '14 at 20:33

Viewed 51 times

I am new to MySQL and I am trying to just test out python and MySQLdb. I was able to create a table in MySQL and print the contents in python.

TABLE:
name_number int(11) NO  PRI     
name    varchar(45) YES         

1   Bob
2   steve

Python Output:
(1L, 'Bob')
(2L, 'steve')

My Question is where is the "L" coming from? Sorry I know this is a stupid mistake, but I can't figure it out.

asked Jan 02 '14 at 20:33

Trying_hard

5

L is for Long, the size of the int. – Pete B. Jan 02 '14 at 20:34
Can I have them show just the number of 1? – Trying_hard Jan 02 '14 at 20:40
1

@Dumbkid_trying Let's say `row` is your row tuple. If you use `print (', '.join (str(x) for x in row) )`, the L won't show. – Hyperboreus Jan 02 '14 at 20:41
Show us the code that produces the "Python Output" and we'll show you how to fix it. – Robᵩ Jan 02 '14 at 20:43

0 Answers0