19. To delete a certain field:
mysql> DELETE FROM student WHERE age=30; Query OK, 1 row affected (0.00 sec) mysql>
now check with select statement;
20. Now to quit the menu use command “\q” in mysql prompt.
mysql> \q Bye [root@kalwa1 ~]#
Platform for learning UNIX & LINUX technologies
In this article you will find the examples of how to run remote ssh command in Linux to Show result locally.
Don’t use regular MySQL, Percona and MariaDB (we’ll migrate to MariaDB later) are better.