Only Few Seats Left for Advanced Certification Courses on Data Science, ML & AI by E&ICT Academy IIT RoorkeeApply Now
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!
No hints are availble for this assesment
Answer is not availble for this assesment
Note - Having trouble with the assessment engine? Follow the steps listed here