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 ~]#
How to setup mysql on Linux
You may like:
- Quick way to setup AWS web server.
- How to recover forgotten root password in Linux.
- How to tune linux kernel parameter
- Quick guide Bash while loop with examples
- How to install Ubuntu in AWS
- How to configure password less ssh login.
- How to extend-resize Linux root partition on AWS EC2
- What is Linux standard input output error and how to redirect stdout and stderr to file in Linux
Don’t use regular MySQL, Percona and MariaDB (we’ll migrate to MariaDB later) are better.