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…

Solution : Cannot delete or update a parent row: a foreign key constraint fails

Whenever you want to delete a particular row from a parent table, usually a database engine checks whether this parent data primary key value refers to any child table data.

For Example,

Table: user

id
login_Id
user_Name
1
demo001
Note
2
demo002
Book

Table: userAddress

id
user_id
Country
State
1
1
India
Himachal Pradesh
2
2
India
Tamil Nadu

Primary Key
Foreign Key

Table UserAddress has “user_id” is a foreign key reference from Table User.

So User Table is Parent Table and UserAddress Table is Child Table

If you are try to delete any data in child table then you might be not facing an error but if you try to delete any data in parent table then you will face problem “Cannot delete or update a parent row: a foreign key constraint fails” because parent table data is referencing to child table.

Execute this Query

SET FOREIGN_KEY_CHECKS = 0;

After executing the above query

Now try to delete the parent table data which is referencing to child table data then database engine won’t be checking and it will delete without any problem.

To Do the Reset

SET FOREIGN_KEY_CHECKS = 1;

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