Database structure problems
Answered
Hi, guys, I have a question about how I saved the new table written in python, I extract some information from a txt file, and save them into a table, all code was written in Python. everything worked fine, but I am confused about this structure, i attached a screen cut here. I was thinking this new "Counts" table was supposed to be saved under SQLite or MySql, but I created a new "email" in database, I donot know why, was it because code of line 3? then how can i save this table to SQLite or MySql? Thank you all guys for more help and explanation.
Please sign in to leave a comment.
Yes, you have specified connection to 'email' database in your script.To save it in MySQL you need to open mysql connection from your code and work with it.
WHat you see in Database tool window is used only for code completion when you write SQL queries inside your Python script and you can't use these data sources in your code, you always need to create connection to database in code following the guides.
Hi Yuriy,
Thank you so much for the explanation. I understand much better now. Thank you very much for the help.