mysql python retreive specific column from specific row

Question

I have an database called sportschool and one record looks like this

ID Logouttime Logintime totaltime

What i want to do is for example where id is 1(this can be different depending on the user input) is retreive the logintime and store that in a variable

This is what i have now:

aa= pymysql.connect(host='',user='',passwd='',db='',)
mm = aa.cursor()
mm.execute('SELECT Logouttime FROM sportschool WHERE ID = 1')

but how can i store it in a variable then? Insert works fine but i need to retreive the data and store it so i can calculate the difference betwheen logintime and loguittime

Hope someone can help

Imre_G · Accepted Answer · 2018-01-17 15:05:58Z

1

What you are looking for is the line

logouttime = mm.fetchone()

More info here: http://pymssql.org/en/stable/pymssql_examples.html

answered Jan 17, 2018 at 15:05

Imre_G

2,5251 gold badge20 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Klaas Over a year ago

Thanks for the command i did what you said But when i print logguittime it prints it like this: {u'loguittime': datetime.timedelta(0, 58981)} in phpmyadmin it stands like this: 16:23:01

Rishabh K Sharma · Accepted Answer · 2018-01-17 18:25:06Z

0

logouttime = mm.fetchone()

it will give you tuple of tuple

    (("10:00:00"))

now you can do whatever you want with that logout time

>>> import datetime
>>> a = {u'loguittime': datetime.timedelta(0, 58981)}
>>> a['loguittime']
     datetime.timedelta(0, 58981)
>>> d = a['loguittime']
>>> (d.days, d.seconds, d.microseconds)
    (0, 58981, 0)

edited Jan 17, 2018 at 18:25

answered Jan 17, 2018 at 15:09

Rishabh K Sharma

2595 silver badges16 bronze badges

5 Comments

Klaas Over a year ago

Thanks for the command i did what you said @BloodringBanger But when i print logguittime it prints it like this: {u'loguittime': datetime.timedelta(0, 58981)} in phpmyadmin it stands like this: 16:23:01

Rishabh K Sharma Over a year ago

thats the problem with date time you need to parse it and then you can perform operations onto it

Klaas Over a year ago

And by any change do you know how to do that?

Imre_G Over a year ago

This is something that is easily found by a google search I suppose. Try "parsing datetime python". Good luck!

Rishabh K Sharma Over a year ago

@Klaas see this is how you will parse

Collectives™ on Stack Overflow

mysql python retreive specific column from specific row

2 Answers 2

1 Comment

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related