Exercise 4 (int,Double,decimal and auto increment)
1,creates table data_test2
(f1 int,f2 double, f3 decimal(5,2),
f4 decimal(6,3));

2.insert data_test2
set f1=123.456,
    f2=123.456,
    f3=123.456,
    f4=123.456;
3.Select * from data_test2
Question waht is the value for f1?f2?f3?f4?

4.insert data_test2
set f2=1234.5678
    f4= 1234.5678
question what is the value for f1,f2,f3,f4

5.create table auto_test (f1 int auto_increment primary key,
f2 int);

6 insert auto_test
set f2=123;
insert autotest
set f2=456;

insert auto_test
set f2=789;

7.Select * from auto_test;
8.insert auto_test 
set f1=4,
    f2=123,

9.Select * from auto_test;
question were you able to save the record

10. delete from auto_test;
11. insert auto_test;

set f2=123;
insert auto_test;
set f2=123;
insert auto_test
set f2=456;
insert auto_test
set f2=789;
question what are the values of f1 fields now?