MySQL 101: Installation, care, and feeding on Ubuntu If you've got 15 minutes, we can show you the ropes of basic MySQL management.

The mysql command-line interactive program is a very powerful way to access, display and even manipulate data without the need for any GUI at all. The basic commands are well worth learning, so if you ...

Inserting a string into a MySQL table is a matter of logging into the MySQL server, then issuing an "insert" command for the table column that holds text data.

How to Sequence Names in MySQL. Sequences in MySQL help ensure that values aren't repeated, and many applications require database tables to have an incrementing "id" column. The MySQL syntax ...

Unfortunately, I'm not sure if mySQL has an equivalent function, so this may be useless to you. That may make for nice syntax but the query plan is probably horrendous.

Since MariaDB is a fork from MySQL, the syntax is similar, but MariaDB has several additional features. Basic SQL syntax remains the same, but MariaDB handles data storage and functions differently.

Jack Wallen explains how to add data into a MySQL table from the command line.