sscasc@tumkur selectis used to retrieve data from the database insertis used to insert data into table updateis used to update existing data within table deleteis used to delete records from database table data control language (dcl)dcl includes commands such as grant and revoke which mainly deals with the rightspermissions and other controls of the database system examples of dcl commandsgrantgives user' access privileges to database revokewithdraw user' access privileges given by using the grant command commitcommits transaction rollbackrollbacks transaction in case of any error occurs savepointsets save point within transaction set transactionspecify characteristics for the transaction creating table tables are where we actually store your data to start withto create very simple tablefruitcontaining three fieldsid (the primary key)name (the name of the fruit)and color (the fruit' colorthe first thing to do is select the database just created once you database are selectedany database manipulation commands entered works on that database type the followinguse mydatabasepress enterand we seedatabase changed mysql now to create table type the following at the mysql promptmysql create table fruit (id smallint unsigned not null auto_incrementname varchar( not nullcolor varchar( not nullprimary key (id)after successful execution of command we get messagequery ok rows affected ( secto see list of tables in the databaseuse the show tables commandmysql show tablessp_python programming