Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
PyMySQL
#1
Hey,

I have PyMySQL working however the result its printing has an unexpected character.

#!/usr/bin/python

import pymysql.cursors

connection = pymysql.connect(
    host='localhost',
    user='test',
    password='test',
    db='test',
    charset='utf8',
    cursorclass=pymysql.cursors.DictCursor
)

try:
    with connection.cursor() as cursor:
        cursor.execute("SELECT * FROM `test` WHERE `id`=`1`")
        result = cursor.fetchone()
        print(result)

finally:
    connection.close()
These are the results i get.

{u'row1': 100, u'row2': 100}

All of the results i get have a u before each result. I could always just cut up the string but i was more so wondering what the u means.

Thanks
Reply
#2
It's unicode. The u isn't actually part of your string, much like a bracket character isn't part of a list.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Mysql Syntax error in pymysql ilknurg 4 2,287 May-18-2022, 06:50 AM
Last Post: ibreeden
  pymysql can't do SELECT * Pedroski55 3 2,899 Sep-11-2021, 10:18 PM
Last Post: Pedroski55
  pymysql won't handle some diacritic characters awarren2001AD 0 1,235 Apr-16-2020, 08:58 AM
Last Post: awarren2001AD
  pyMySQL - ROW_NUMBER in SQL statement JayCee 1 2,339 Apr-12-2020, 08:40 PM
Last Post: JayCee
  pyMySQL How do I get the row id JayCee 3 2,667 Apr-12-2020, 08:38 PM
Last Post: JayCee
  PyMySQL return a single dictionary Valon1981 2 1,732 Feb-20-2020, 04:07 PM
Last Post: Valon1981
  pymysql: formating ouput of query wardancer84 18 8,175 Oct-04-2018, 01:54 PM
Last Post: wardancer84
  pymysql ifnull aland 4 3,938 Sep-06-2018, 05:58 AM
Last Post: buran
  get last row id in pymysql tony1812 1 11,071 Sep-26-2017, 11:25 PM
Last Post: Larz60+
  pymysql question tony1812 1 2,857 Sep-26-2017, 12:41 AM
Last Post: Larz60+

Forum Jump:

User Panel Messages

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