I faced an error can anyone suggest me the solution?

|
Unknownrjbeast 2021-12-27 15:10:00
MasterZiv 2021-12-27 15:07:37
Send your query text, diagnostics and DDL of the table , if you want to get some help

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 πŸ™„

MasterZiv 2021-12-27 15:11:45
Unknownrjbeast 2021-12-27 15:10:00
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

MasterZiv 2021-12-27 15:12:20
Unknownrjbeast 2021-12-27 15:10:00
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 text please

Unknownrjbeast 2021-12-27 15:14:37
This is my code to insert user details
MasterZiv 2021-12-27 15:14:43
this is not MySQL query code
piterden 2021-12-27 15:14:50
This is Python not MySQL
Unknownrjbeast 2021-12-27 15:15:05
piterden 2021-12-27 15:14:50
This is Python not MySQL

Mysql python connector

MasterZiv 2021-12-27 15:15:50
Unknownrjbeast 2021-12-27 15:15:05
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

Unknownrjbeast 2021-12-27 15:17:05
>> 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
Unknownrjbeast 2021-12-27 15:17:34
Any idea πŸ₯ΊπŸ₯ΊπŸ₯Ί
Rupesh Sase 2021-12-27 17:23:43
How I change my user pasword?
Rupesh Sase 2021-12-27 17:26:06
Dnyanesh 2021-12-26 14:58:33
My Institute “SANDYR IT TECHNOLOGIES” is going to start free industry level training for needy candidates

We have planned to take session (C language= 2 weeks, C++ and OOPS concepts = 2 weeks and then Core Java , MYSQL AND Manual testing ) on google meet/Youtube channel

Training will be free of cost

So plz be keep in touch with that

If any student interested tell them to join

This training will help them to clear technical interview

If interested for this then join telegram channel SANDYR IT TECHNOLOGIES

Thanks

Interested

svart 2021-12-27 19:03:40
Rupesh Sase 2021-12-27 17:23:43
How I change my user pasword?

set password

Rahul Kumar 2021-12-28 11:45:00
hi. anyone please share any documentation for configuring rman in mysql
svart 2021-12-28 13:32:54
Rahul Kumar 2021-12-28 11:45:00
hi. anyone please share any documentation for configuring rman in mysql

rman is the part of oracle ecosystem not mysql

Rahul Kumar 2021-12-28 14:11:14
svart 2021-12-28 13:32:54
rman is the part of oracle ecosystem not mysql

how to take backup of database

Khushi Hura 2021-12-28 14:25:03
How to backup MySQL database on Windows – SqlBak Blog
https://sqlbak.com/blog/how-to-backup-mysql-database-on-windows
Khushi Hura 2021-12-28 14:25:12
You can go through this article
ssssss 2021-12-28 15:10:27
Hi, how to resolve the system locks in slave?
ssssss 2021-12-28 15:12:31
Anyone please have a look on system locks clearance on slave
Shadabkhanking 2021-12-28 17:43:37
Hello can anyone suggest me
Shadabkhanking 2021-12-28 17:44:04
I ma installing opencats. Anyone have knowledge about that ?
Shadabkhanking 2021-12-28 17:44:28
I faced an error can anyone suggest me the solution?
Khushi Hura 2021-12-28 17:50:08
But in your table there is no name which has both of these
So null will be the output
Khushi Hura 2021-12-28 17:51:30
Select manufacturer from item where item_name==”Personal computer” and item_name==”laptop”;
Khushi Hura 2021-12-28 17:59:37
Hm
Khushi Hura 2021-12-28 18:00:03
Ok!!
Khushi Hura 2021-12-28 18:24:12
So u must go with

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

Khushi Hura 2021-12-28 18:24:25
Khushi Hura 2021-12-28 18:24:12
So u must go with

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

This will give u desired output

Khushi Hura 2021-12-28 19:06:44
Ya but distinct clause will not give only HP and Lenevo
It will give all the items which are not duplicated
Khushi Hura 2021-12-28 19:06:53
But here hp is duplicated
Khushi Hura 2021-12-28 19:14:35
Oh OK
Khushi Hura 2021-12-28 19:14:38
I got that
Khushi Hura 2021-12-28 19:15:21
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
Khushi Hura 2021-12-28 19:15:40
So if u don’t use where clause then it will result in that which I told earlier
|