Redmi Note 5 Specification And Price

Image
See the Redmi Note 5 Specification And Price

Display


18:9 Full screen displayCustom display with rounded corners
Procesor & Memory

Octa-core processorSnapdragon 625 2.0GHz maxAdreno 506Dimensions
Height: 158.5mmWidth: 75.45mmThickness: 8.05mmWeight: 180g

Display
18:9 Full screen display15.2cm (5.99) (diagonally)18:9 screen aspect ratio2160 x 1080 FHD+ resolution, 403 PPI, 1000:1 contrast ratio450 nits brightness84% of NTSC color gamutSunlight displayNight displayReading modeColor temperature adjustmentStandard mode
Battery
4000mAh (typ) / 3900mAh (min)Non-removable5V/2A
Camera & Video
12MP rear camera12MP, 1.25μm large pixel5-element lens, ƒ/2.2 apertureDual LED flashPDAFLow light enhancementHDRPanoramaBurst modeFace recognition5MP front cameraBeautify 4.0Selfie-lightSelfie countdownFace recognition1080p/720p video, 30fps
Networks & Connectivity
Supports 802.11a/b/g/n protocolsSupports 2.4 / 5G WiFi / WIFI Direct / WiFi DisplayBluetooth 4.2, Bluetooth HID4G dual SIM:
3-choose-2 hybrid S…

Where Syntax for SELECT Query in Mysql

Where Syntax in Select Query can be used to filter the data from database.Suppose if you have 100 of data with different gender like male and female but you want the data of all male what you can do?

Simply use mysql select query with where condition to filter the data from table.


Example Table : For your reference



table_name
Column_name1
Column_name2
Column_name3
Column_name4
1
Male
articles
Sam
2
Female
database
Sam
3
Male
coding
Jam
4
Male
coding
Kam
5
Female
coding
Jam

Table Name is : table_name

Query : "SELECT * from table_name WHERE Column_name2='Male'"

If you execute the above query then all female records will disappears from the table data

table_name
Column_name1
Column_name2
Column_name3
Column_name4
1
Male
articles
Sam
3
Male
coding
Jam
4
Male
coding
Kam


Query : "SELECT Column_name3 , Column_name4  from table_name WHERE Column_name2='Male'"

If you execute the above query then all female records will disappears from the table data and will display only Column_name3 and Column_name4 

table_name
Column_name3
Column_name4
articles
Sam
coding
Jam
coding
Kam






Comments

Popular posts from this blog

Gradle project sync failed. Basic functionality (e.g, editing, debugging) will not work properly.

How Automation Can Make You Better at Your Job

Best Expense Manager App For Your Android Phone