MySQL Command Line Interface


Insert

                INSERT INTO fees
                (Student_ID, Student_Name, Student_Course, Fess)  
                VALUES 
                ('[101]', '[Ishaq]', '[DSD-06]', '[21000]');

Update

                    UPDATE `fees`
                    SET
                    `Student_Name`='[Quazi Ishaq]',
                    `Student_Course`='[Cyber_Sec]',
                    `Fess`='[45000]'
                    WHERE
                    `Student_ID`='[101]';

Delete

                        DELETE FROM 
                        `fees` 
                        WHERE 
                        `Student_ID`=101;