When you are using CLC for practice activity # $2,$ follow these steps:

You need to create a database: let's say its name is INFO$2312$:

mysql$>$ CREATE DATABASE INFO$2312$;

Query OK$,1$ row affected $(0\mathrm{.}04$ sec$)$

Use this database by running:

mysql$>$ CREATE DATABASE INFO$2312$;

Query OK$,1$ row affected $(0\mathrm{.}04$ sec$)$

Next step is to create table:

CREATE TABLE employees$3($

$$ id INT AUTO$\_$INCREMENT PRIMARY KEY,

$$ name VARCHAR$(100),$

$$ age INT,

$$ position VARCHAR$(100)$

$)$;

Insert data into table:

mysql$>$ INSERT INTO employees$3($name$,$ age, position$)$ VALUES

$->(\text{'}$John Doe', $30,$ 'Manager'$),$

$->(\text{'}$Jane Smith', $25,$ 'Developer'$),$

$->(\text{'}$Michael Johnson', $35,$ 'Designer'$),$

$->(\text{'}$Emily Davis', $28,$ 'Marketing'$)$;

Query OK$,4$ rows affected $(0\mathrm{.}01$ sec$)$

Records: $4$Duplicates: $0$Warnings: $0$

Run query:

mysql$>$ SELECT $*$ FROM employees$3$;

$+----+-----------------+------+-----------+$

$|$ id $|$ name $|$ age $|$ position $|$

$+----+-----------------+------+-----------+$

$|1|$ John Doe $|30|$ Manager $|$

$|2|$ Jane Smith $|25|$ Developer $|$

$|3|$ Michael Johnson $|35|$ Designer $|$

$|4|$ Emily Davis $|28|$ Marketing $|$

$+----+-----------------+------+-----------+$

$4$ rows in set $(0\mathrm{.}00$ sec$)$

We will start DDL programming in the next lecture, covering all the steps. This activity only provides you with an exercise on how to start working with CLC$.$