Deleting data

If the need arises to delete a row, or multiple rows of a table because the data has become obsolete, then we have to use the DELETE command. When we want to make large-scale deletions in a table, this command is very handy.

Now, create the script to delete the record:

mysql -u user1 -pTest623@! <<MY_QUERY 
use testdb; 
DELETE FROM Authors WHERE Name = 'Mansi Joshi'; 
select * from Authors; 

Now, save the program and run it as follows:

          $ chmod +x
          $ ./

The output will be:

    Id    Name
    2     Charles Dickens
    3     Jane Austen
    4     George Orwell
    5     Oscan Wilde

Get Learning Linux Shell Scripting - Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.