Python Programming Tutorial - 50: Insert Data Into Tables

In this tutorial we'll learn to populate a MySql table and also to retrieve data from it and display in the python shell.

[shermanmerman]

Thank you for making all those videos. You have helped a lot of people.

[jaspercuajotor]

Thanks straight forward video. helps me have create ideas on using it with python.

[bobdave]

how can i add data like taking user input than add the data to the database.

[ovishekdhar]

how should we send the data type TIMESTAMP and Id(AUTO_INCREMENT) from python to sql

[saifuddinsyed]

How to view sql table values as HTML tables here?

[supriyakurade]

Hi, I am inserting the values like (3, 'abc', 'fjhjgh', '2015-3-03') for (id, name, address, date_of_birth) but while printing
i m getting (3, u'abc', u'fjhjgh', datetime.date(2015, 3, 3) ) this as output.
why 'u' is coming in output before each varchar field?