EXERCISE 4 FINAL

///////////////////////////////////////////////////////////////////////////

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| realtraining       |
| schsystem          |
| test               |
| unique_key         |
+--------------------+
7 rows in set (0.00 sec)

mysql> use realtraining;
Database changed

mysql> create table data_test2
    -> (f1 int,
    -> f2 double,
    -> f3 decimal(5,2),
    -> f4 decimal(6,3));
Query OK, 0 rows affected (0.08 sec)

mysql> insert data_test2
    -> set f1=123.456;
Query OK, 1 row affected (0.03 sec)

mysql> insert data_test2
    -> set f2=123.456;
Query OK, 1 row affected (0.02 sec)

mysql> insert data_test2
    -> set f3=123.456;
Query OK, 1 row affected, 1 warning (0.03 sec)

mysql> insert data_test2
    -> set f4=123.456;
Query OK, 1 row affected (0.05 sec)


mysql> describe data_test2
    -> ;
+-------+--------------+------+-----+---------+-------+
| Field | Type         | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| f1    | int(11)      | YES  |     | NULL    |       |
| f2    | double       | YES  |     | NULL    |       |
| f3    | decimal(5,2) | YES  |     | NULL    |       |
| f4    | decimal(6,3) | YES  |     | NULL    |       |
+-------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql>
mysql>

mysql> create table auto_test
    -> (f1 int auto_increment primary key,
    -> f2 int);
Query OK, 0 rows affected (0.06 sec)


mysql> insert auto_test
    -> set f1=123;
Query OK, 1 row affected (0.03 sec)

mysql> insert auto_test
    -> set f2=456;
Query OK, 1 row affected (0.03 sec)

mysql> select * from auto_test;
+-----+------+
| f1  | f2   |
+-----+------+
| 123 | NULL |
| 124 |  456 |
+-----+------+
2 rows in set (0.00 sec)

mysql> describe auto_test
    -> ;
+-------+---------+------+-----+---------+----------------+
| Field | Type    | Null | Key | Default | Extra          |
+-------+---------+------+-----+---------+----------------+
| f1    | int(11) | NO   | PRI | NULL    | auto_increment |
| f2    | int(11) | YES  |     | NULL    |                |
+-------+---------+------+-----+---------+----------------+
2 rows in set (0.02 sec)

mysql> insert auto_test
    -> set f2=789;
Query OK, 1 row affected (0.03 sec)

mysql> select * from auto_test;
+-----+------+
| f1  | f2   |
+-----+------+
| 123 | NULL |
| 124 |  456 |
| 125 |  789 |
+-----+------+
3 rows in set (0.00 sec)

mysql> insert auto_test
    -> set f1=4, f2=123;
Query OK, 1 row affected (0.02 sec)

mysql> select * from auto_test;
+-----+------+
| f1  | f2   |
+-----+------+
|   4 |  123 |
| 123 | NULL |
| 124 |  456 |
| 125 |  789 |
+-----+------+
4 rows in set (0.00 sec)

mysql> drop table if exists auto_test;
Query OK, 0 rows affected (0.01 sec)

mysql> show tables;
+------------------------+
| Tables_in_realtraining |
+------------------------+
| data_test              |
| data_test2             |
| data_test3             |
+------------------------+
3 rows in set (0.00 sec)


+------------------------+
| Tables_in_realtraining |
+------------------------+
| data_test              |
| data_test2             |
| data_test3             |
+------------------------+
3 rows in set (0.00 sec)


mysql> show tables;
+------------------------+
| Tables_in_realtraining |
+------------------------+
| data_test              |
| data_test2             |
| data_test3             |
+------------------------+
3 rows in set (0.00 sec)

mysql> create table auto_test
    -> (f1 int auto_increment primary key,
    -> f2 int);
Query OK, 0 rows affected (0.08 sec)

mysql> insert auto_test
    -> set f2=123;
Query OK, 1 row affected (0.03 sec)

mysql> insert auto_test
    -> set f2=456;
Query OK, 1 row affected (0.01 sec)

mysql> insert auto_test
    -> set f2=789;
Query OK, 1 row affected (0.03 sec)

mysql> describe auto_test
    -> ;
+-------+---------+------+-----+---------+----------------+
| Field | Type    | Null | Key | Default | Extra          |
+-------+---------+------+-----+---------+----------------+
| f1    | int(11) | NO   | PRI | NULL    | auto_increment |
| f2    | int(11) | YES  |     | NULL    |                |
+-------+---------+------+-----+---------+----------------+
2 rows in set (0.01 sec)

mysql>
mysql>