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
This article will guide you on How to add line in file on multiple servers using Ansible playbook in minutes.
Don’t use regular MySQL, Percona and MariaDB (we’ll migrate to MariaDB later) are better.