Tag: MySQL Command-Line Client

Paging in MySQL Command-Line Client

Paging in MySQL Command-Line Client

February 4, 2014 | By | Add a Comment

By default MySQL command-line client wraps lines in a SELECT query result and has no paging. You can solve both these problems by using the less command available in Unix/Linux systems.

Continue Reading

Importing and Exporting MySQL Databases

Importing and Exporting MySQL Databases

June 19, 2013 | By | 2 Comments

Importing and exporting MySQL databases in a Unix/Linux environment can be done easily with a single command. You can even choose to export the database’s structure or data only.

Continue Reading

Navigating MySQL Databases and Tables

Navigating MySQL Databases and Tables

June 18, 2013 | By | Add a Comment

Here is a list of MySQL’s command line client commands to navigate through the databases and their tables.

Continue Reading