Executing MySQL Queries Directly From the Command Line
MySQL is a central component of the LAMP open-source web application software stack (and other "AMP" stacks). LAMP is an acronym for "Linux, Apache, MySQL,
Perl/PHP/Python". Applications that use the MySQL database include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, and Drupal.
MySQL is also used in many high-profile, large-scale websites, including Google(though not for searches), Facebook, Twitter,Flickr, and YouTube.
Viewing list of Databases in your System
To create Databases and start working with them
Without output from MySQL, nothing will be returned after running a command like the command above.
Create tables and view tables
To Insert into the table
To view data in the table
Now we want to output the result to a file, the tee command comes in handy or output redirection by running
The output will be saved to output.txt of the working directory. Which can be viewed using cat command
$ cat output.txt