Great congratulations 👍

Hi @mauricioreguete466, thanks for your comment! Seems like you've successfully followed through with the video, that's great! If you have any questions around any further processes or you're encountering difficulties with any steps, please do let me know. Stay tuned for more exciting and informative Python tutorials. Happy Coding!

You have to use the username and password which you have set while installing mysql, for example my username is 'root' and password is '1234' and hostname will be 'localhost' only.

Hello @EktaGupta-zn1ch, it seems you're doing a great job following along with the tutorial. For the login credentials while connecting to the database, you need to use the credentials for your MySQL server, not the ones used for logging into the Student Management System. This would be the username and password you set up when you installed MySQL on your PC. So, the hostname is usually 'localhost' if the database is on your computer, the username is the one you set during MySQL installation (often 'root'), and the password is also set during MySQL installation. Don't forget to have your MySQL server running when trying to connect. If you're still facing issues, please share the error message you're getting so I can help you troubleshoot further! Happy Coding!

Because of the type you have defined for id and number while creating the table columns, you can modify that

Hi @flytomoon2209, that's a great question! The limitation is due to the data type assigned to these fields in our code. For the ID field and phone number field, we've chosen 'integer' data type. And generally, in most systems, the maximum allowable integer number is up to 10 digits long. Therefore, if you try to add more than 10 digits, it may return an error.

But don’t worry, if you have IDs or phone numbers that are longer than 10 digits, you can easily change the data type to something like a string (VARCHAR) that can hold more characters. Just remember to reflect this when you insert and retrieve information from the database. And make the necessary changes when validating the input and formatting for display.

I hope this answers your question. Keep exploring the world of Python with me! Let me know if you have any more questions.

# Create a Treeview widget
tree = ttk.Treeview(root) # Define the columns
tree["columns"] = ("Name", "Age", "City")
# Set the column width tree.column("#0", width=100)
# First column (the tree column) tree.column("Name", width=150) tree.column("Age", width=100) tree.column("City", width=200)

Hi @hanzalahirfan5621, interesting observation! It appears that you may need to adjust the column widths within the tree view. The tree view columns width , or any other GUI element size in this case, is designed according to the initial requirements and screen resolution. However, you can modify it according to your needs. Use the column method of the treeview like this:
`treeview.column("#0", width=100)`, where '#0' is the column identifier and 'width' is the attribute you want to change.

You can also set the minwidth, stretch, and anchor attributes too. Remember to replace 100 with the width you actually want. Repeat this for all the columns you want to adjust. Hope this helps, and continue happy coding!

Thanks

Hey @waqasnaqvi502, thanks for the thumbs up! Always great to receive positive feedback. If you have any questions or if there's a specific topic you'd love to see on the channel, don't hesitate to share. Happy coding!