I faced an error can anyone suggest me the solution?

Yes I have to write down an project program with connection mysql python.
In this project I create an table first to input user details for upsc registration, But when I use update statement to to change user data like name,place of birth,etc its showing str not work int type required 🙄

Send your query text, diagnostics and DDL of the table , if you want to get some help

send text please

This is my code to insert user details

this is not MySQL query code

This is Python not MySQL

Mysql python connector

[In reply to Rajan Singh]
Send your query text, diagnostics and DDL of the table , if you want to get some help

>> create database upsc;
>> use upsc;
>> create table registration(name varchar(50) ,father_name varchar(50),mother_name varchar(50),examination_applied varchar(40),year int(4),gender varchar(11),date_of_birth varchar(12),nationality varchar(15),marital_status varchar(10),community varchar(4),minority varchar(4),add_1 varchar(40),add_2 varchar(40),add_3 varchar(40),dist varchar(20),state varchar(20),pin_code int(6),pho_no int (10),mobile_no int (10),e_mail varchar(45),education_qualification varchar (100),preferance varchar(10));
>>>
This is how I created table and insert values, but I don’t know how to update or change details insert previously

Any idea 🥺🥺🥺

How I change my user pasword?

Interested

set password

hi. anyone please share any documentation for configuring rman in mysql

rman is the part of oracle ecosystem not mysql

how to take backup of database

How to backup MySQL database on Windows – SqlBak Blog
https://sqlbak.com/blog/how-to-backup-mysql-database-on-windows

You can go through this article

Hi, how to resolve the system locks in slave?

Anyone please have a look on system locks clearance on slave

Hello can anyone suggest me

I ma installing opencats. Anyone have knowledge about that ?

I faced an error can anyone suggest me the solution?

But in your table there is no name which has both of these
So null will be the output

Select manufacturer from item where item_name==”Personal computer” and item_name==”laptop”;

Hm

Ok!!

So u must go with

Select manufacturer from item where manufacturer=”HP” or manufacturer=”lenovo”;

This will give u desired output

Ya but distinct clause will not give only HP and Lenevo
It will give all the items which are not duplicated

But here hp is duplicated

Oh OK

I got that

Distinct clause will give those which r duplicated only once
That means only the first hp record and first Lenovo record
And where clause will specify the condition

So if u don’t use where clause then it will result in that which I told earlier