Python and MySQL result conversion

[Guest]

Hola!

I'm currently making a Python Tkinter app as a personal project, however I've hit a road block. The program inputs an entry into MySQL query which then spits out the result as a Label.

You enter a name and it prints out: "ID name email". So it works great, but I need those values as separate variables. I could just access the data with 3 SQL queries but thats just awful. 

What I need is some kind of a string function that will use the result variable and create three variables or better, a list with [ID,name,email].

I appreciate all input. I didn't include the source code because it doesn't really matter here. A general solution or a point in the right direction will be more beneficial for me, as I will be able to learn and adapt it for my needs.

[Hi P]

25 minutes ago, Doctor_GLaDOS said:

What I need is some kind of a string function that will use the result variable and create three variables or better, a list with [ID,name,email]

 

https://www.w3schools.com/python/ref_string_split.asp

Is that what you are looking for?

[Guest]

22 minutes ago, Hi P said:

 

https://www.w3schools.com/python/ref_string_split.asp

Is that what you are looking for?

Muchas gracias love you case closed  

[Guest]

I don't quite understand your question. However, if you don't know the SQL commands, you can use

codecademy.com

That has a course on SQL. Just don't pay for anything haha.

 

It might help you better understand how SQL operates. Complete the whole course. It's quite short.

 

If I'm reading it correctly... you are trying to access an entry in your database & it's giving you all the information about it instead of only a specific variable in the entry.

If this is the case, you are using the "Select" statement incorrectly.

 

 Select * from table

is using the wildcard and showing all elements.

It's been a while since I used SQL but you need to use a few extra keywords.

 Select email from table where name is "jan"

My syntax is probably incorrect, but I think that's something along the lines of what you may need.

[Guest]

2 minutes ago, fpo said:

I don't quite understand your question. However, if you don't know the SQL commands, you can use

codecademy.com

That has a course on SQL. Just don't pay for anything haha.

 

It might help you better understand how SQL operates. Complete the whole course. It's quite short.

 

If I'm reading it correctly... you are trying to access an entry in your database & it's giving you all the information about it instead of only a specific variable in the entry.

If this is the case, you are using the "Select" statement incorrectly.

 

 

 Select * from table

is using the wildcard and showing all elements.

It's been a while since I used SQL but you need to use a few extra keywords.

 

 Select email from table where name is "jan"

 

My syntax is probably incorrect, but I think that's something along the lines of what you may need.

Really appreciate your reply and it's a good idea. My SQL is rudimentary and a course might only do me good