Linux Today: Linux News On Internet Time.

10 Command-line Timesavers for MySQL Tasks

Oct 29, 2010, 15:33 (0 Talkback[s])
(Other stories by Jason Gilmore)

"Although several great GUI-based MySQL clients exist, among them phpMyAdmin and SQLYog, I've always preferred to use the native mysql command-line client. It does take some time to get acquainted with using a command-line interface (CLI), particularly if you don't regularly work with an operating system offering a robust CLI environment. However, after some practice you'll be able to manage users, navigate your databases, and perform other tasks with incredible ease.

"In this article I'll introduce you to 10 mysql client tips and tricks that I've accumulated over the years. Whether you adopt one or all I guarantee you'll save a considerable amount of time and effort when using this powerful MySQL interface.

"Incidentally, the mysql client is available for all operating systems, Windows included. However, because Windows' native CLI is horrible, consider installing Console, a great alternative solution that offers a great set of features including convenient text selection and multiple tabs."

Complete Story

Related Stories: