Only Few Seats Left for Advanced Certification Courses on Data Science, ML & AI by E&ICT Academy IIT Roorkee

  Apply Now

Assessment Question - Connecting to MySQL

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

Loading comments...