How to Use MySQL from the Command Line on Ubuntu Server 20.04
Jul 28, 2021
Step 1 : First, we will need to connect to the MySQL server
mysql -u admin -h localhost -p
Replace admin with a user account on the MySQL server
Step 2 : Enter the password for the admin account
Step 3 : Create a database with the following query.
mysql> create database blog;
Step 4 : Check all databases with a show databases query.
mysql> show databases;
Step 5 : Select a database to work with
mysql> use blog;
Step 6 : Create a table to store our data. Use the following query to create a table
mysql> CREATE TABLE `persons` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`last_name` varchar(255) NOT NULL,
`first_name` varchar(255) NOT NULL,
`address` varchar(255) NOT NULL,
`city` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1;
Step 7 : You can check tables with the show tables query
mysql> show tables;
Step 8 : let’s insert some data in our table.
mysql> INSERT INTO `persons` (`id`, `last_name`, `first_name`, `address`, `city`)
VALUES (NULL, 'Santos', 'Matt', 'Kelley Road', 'Gulfport');
Step 9 : The following query will select all records from the articles table
mysql> Select * from persons;
Step 10 : Retrieve the selected records from the table
mysql> Select * from persons where id = 1;
Step 11 : Update the selected record
mysql> Update persons set last_name="New last_name" where id=1;
Step 12 : Delete the record, using the following command
mysql> Delete from persons where id = 1;
Recommended
Apr 04, 2024
Apr 04, 2024
Apr 03, 2024
Apr 03, 2024
Apr 03, 2024
Apr 01, 2024
Apr 01, 2024
Apr 01, 2024
Apr 01, 2024
Mar 31, 2024
Mar 30, 2024
Mar 30, 2024
Mar 30, 2024