MySQL Data types with examples
Data Types with examples
JSON
CREATE TABLE events(
event_id INT AUTO_INCREMENT PRIMARY KEY,
event_name char(75),
properties json
);
insert into events values (1,'dance','{ "name": "Mozilla Firefox", "OS": "Mac",
"resolution": {"x": 1920, "y": 1080} }')
select * from events;
insert into events values (2,'sports','{
"location" : "mumbai",
"players" : 11,
"name" : "doni",
"age" : 35,
"sponser" : "sony"
}')
Tvenkat
I have 16+ years of experience in IT and 11+ years of experience in training. I am currently working in Bangalore and occasionally in Hyderabad as well. I have worked in various domains including Telecom, Healthcare, Pharma, Insurance, Retail, and Storage. Currently, I am working as a Cloud Principal Consultant in an MNC Product based company.
