Now, this is time for a little bit deeper hands on.
Let's try to connect to MySQL database and perform few basic actions.
What we are going to do:
Connect to MySQL
Switch to a particular database
Create a table t_test with single column "name" of type varchar 10.
Insert a row in the table with "name" as "John".
Select the data from table t_test to see the data that was inserted.
From Lab -> Services, get your userid, password and hostname for MySQL.
Open a new terminal from the lab.
Submit below command after putting in correct values:
mysql -h cxln2.c.thelab-240901.internal -u sqoopuser -pNHkkP876rp
You will get connected to MySQL prompt. MySQL database system has many databases and we will switch to a particular database to perform our activities.
On the MySQL prompt, run below SQL commands:
# Switch to a database use retail_db; # Create the table, ignore the errors if table is already created create table t_test(name varchar(10)); # Delete any existing rows delete from t_test; # Insert new rows insert into t_test values("John"); # Select the data select * from t_test;
You just created a table, deleted the data, inserted the data into the table and selected the data from the table. Awesome!
Note - Having trouble with the assessment engine? Follow the steps listed here