Mysql Tutorial - Data Types - Session 02

---- Datatypes
---String type is nothing but text
text, char, varchar

---numberic type : numbers, floating, double
integer, float, double


create table education.type_example(
marriage_status char,
name varchar(10),
address text,
age integer,
marks_percentage float,
avg_salary double
);



select *from education.type_example;

insert into education.type_example( marriage_status, name, address,age,marks_percentage,avg_salary)
values ('Y', 'Prasanna', 'dno 820 hyderabad',20, 70.1, 32000.50);

insert into education.type_example( marriage_status, name, address,age,marks_percentage,avg_salary)
values ('Y', 'Rambabu15', 'dno 820 hyderabad efdslkjfgdskl;fdls;fk;dlsglkds;gkdfl;gkdfgkjdfdksldfj',20, 70.12944904040, 32000.129449040408);


drop table education.type_example;

create table education.type_example(
-- String types
marriage_status char,
name varchar(10),
address text,

-- numerical types
age integer,
marks_percentage float,
avg_salary double,

-- date types
create_date timestamp
);

insert into education.type_example( marriage_status, name, address,age,marks_percentage,avg_salary,create_date)
values ('Y', 'Prasanna', 'dno 820 hyderabad',20, 70.1, 32000.50, '2020-06-28 15:44');

insert into education.type_example( marriage_status, name, address,age,marks_percentage,avg_salary,create_date)
values ('Y', 'Prasanna', 'dno 820 hyderabad',20, 70.1, 32000.50, sysdate());

insert into education.type_example( marriage_status, name, address,age,marks_percentage,avg_salary,create_date)
values ('NO', 'Prasanna', 'dno 820 hyderabad',20, 70.1, 32000.50, now());

select *from education.type_example;

select now()

SELECT @@system_time_zone;