sscasc@tumkur to see the structure of newly created table use explain commandas followsmysql explain fruitadding data to table now try adding some data into fruit table to add new row to tableyou use the sql insert statement in its basic forman insert statement looks like thisinsert into table values value value )this inserts values into each of the fields of the tablein the order that the fields were created to insert row of partial datauseinsert into table field field values value value )so you can add three rows to the fruit table by inserting data into just the name and color fields (the id field will be filled automatically)mysql >insert into fruit(namecolorvalues('banana''yellow')query ok row affected ( secmysql >insert into fruit (namecolorvalues('tangerine''orange)query ok row affected ( secmysql insert into fruit (namecolor values ('plum','purple)query ok row affected ( secmysql reading data from table to read data in sqlwe create query using the select statement to retrieve list of all the data in your fruit tableyou can usetypical form of mysql select statementwhich retrieves records from table operations performed with select are known as queries (hence the name "structured query language")select field field fieldn from table where condition to retrieve list of all the data in fruit tablewe can usemysql select from fruitsp_python programming