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!
Taking you to the next exercise in seconds...
Want to create exercises like this yourself? Click here.
Note - Having trouble with the assessment engine? Follow the steps listed here
Loading comments...