Question
how to add type based on condition mysql? I have population and country table. based on population and country table I need to create a
how to add type based on condition mysql?
I have population and country table.
based on population and country table I need to create a view with these column
value | country | population
value's value will be either minimum or maximum
example
value | country | population
max | New Zealand | 201
min | Russia | 114
Thank you
example table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Advanced Database Systems For Integration Of Media And User Environments 98
Authors: Yahiko Kambayashi, Akifumi Makinouchi, Shunsuke Uemura, Katsumi Tanaka, Yoshifumi Masunaga
1st Edition
9810234368, 978-9810234362
