Computer Science (Python) > Database Management > Interface Of Python With Sql

(i) Give one difference between CHAR and VARCHAR datatype in MySQL.

(ii) Rahim wants to write a program in Python to insert the following record in the table named

in MySQL database, :

- integer

- string

- string

- float

Note the following to establish connectivity between Python and MySQL:

Username - admin

Password - root

Host - localhost

The values of fields

, , and have to be accepted from the user. Help Rahim to write the program in Python.