I would like to understand if is this a good practice and then, do I create a single cursor as the connection or opening and closing a cursor for every query?

|
MasterZiv 2021-10-13 12:08:49
schemes can’t be nested. the ‘tree’ is like this: instance, scheme, object.
aicantar 2021-10-13 12:11:07
aicantar 2021-10-13 12:07:37
phpMyAdmin groups databases together by common prefix.

When you create databases Intent_Entity, Intent_Entity_New and Intent_Entity_sports, phpMyAdmin will detect common prefixes (`Intent` and `Entity`) and group them together.

You can disable this behavior if you go to Settings > Navigation tree and uncheck the “Group items in the tree” setting

aicantar 2021-10-13 12:11:30
God it’s been a while since I used phpMyAdmin lol
sheikh shoaib 2021-10-13 12:14:31
So from python code if i want to connect Intent_Entity table i can connect directly right?
aicantar 2021-10-13 12:16:14
sheikh shoaib 2021-10-13 12:14:31
So from python code if i want to connect Intent_Entity table i can connect directly right?

Yes

sheikh shoaib 2021-10-13 12:16:41
aicantar 2021-10-13 12:16:14
Yes

Thanks 🙏

MasterZiv 2021-10-13 12:31:58
sheikh shoaib 2021-10-13 12:14:31
So from python code if i want to connect Intent_Entity table i can connect directly right?

What do you mean by “connect to a table” ?
You don’t connect to it, you use it

madno 2021-10-13 12:34:04
Hi, is there any tools for visualising query execution
sheikh shoaib 2021-10-13 13:02:21
MasterZiv 2021-10-13 12:31:58
What do you mean by “connect to a table” ?
You don’t connect to it, you use it

Means first by connect to db then execute query on that table

Me 2021-10-13 17:51:35
Given a dataset with the following structure: 

claimID, userID, handling timestamp this represents a CLAIM HANDLING RECORD that shows that a user (userID) handled a claim (claimID) at a specific time (handling timestamp).

1. What steps do you need to take to determine:

a. Average number of claim handling records per User

b. Average number of unique handling records per User per DAY

Me 2021-10-13 17:51:43
Can anyone help me with this
Me 2021-10-13 17:54:00
Is count(claimid)/count(userid) correct for ques a
thanosphan 2021-10-13 22:03:04
Yes
thanosphan 2021-10-13 22:03:10
Have you tried?
2021-10-14 09:19:06
svart 2021-10-11 22:59:19
do you use push or pull model? The error clearly states that you have problem with connectivity.

It’s a push model..

2021-10-14 10:14:51
Hi All,
I get the performance issues for sql reports after the mariadb upgradation from 10.0 to 10.4 version. Did anyone have any help for like what’s need to do ..
coincap360admin 2021-10-14 13:36:00
hello
is it possible?

“mycursor.execute(f’update register set verify = “verifying” where verify = “no” where user_id = “{m.from_user.id}”‘)”

MasterZiv 2021-10-14 13:44:43
coincap360admin 2021-10-14 13:36:00
hello
is it possible?

“mycursor.execute(f’update register set verify = “verifying” where verify = “no” where user_id = “{m.from_user.id}”‘)”

yes it is possible

coincap360admin 2021-10-14 14:16:03
MasterZiv 2021-10-14 13:44:43
yes it is possible

Not work
I replace “and” in 2 “where” and it is work

MasterZiv 2021-10-14 14:17:09
coincap360admin 2021-10-14 14:16:03
Not work
I replace “and” in 2 “where” and it is work

but it is possible, it is still possible.

Qlagh 2021-10-16 20:54:26
how can i count how many row i added into my table?
i may delete all of them
i just want to know many ive added in the past!
MasterZiv 2021-10-17 04:17:42
Qlagh 2021-10-16 20:54:26
how can i count how many row i added into my table?
i may delete all of them
i just want to know many ive added in the past!

Select count(*) From thetable

Qlagh 2021-10-17 09:14:35
MasterZiv 2021-10-17 04:17:42
Select count(*) From thetable

count(“) ???

MasterZiv 2021-10-17 09:18:44
Qlagh 2021-10-17 09:14:35
count(“) ???

Sorry count(*)

Qlagh 2021-10-17 09:21:06
MasterZiv 2021-10-17 04:17:42
Select count(*) From thetable

I mean I have to see how many rows have been added from the beginning to now (even rows that have been deleted in the past)
The method you just mentioned says only the number of rows in the table

MasterZiv 2021-10-17 09:22:25
Qlagh 2021-10-17 09:21:06
I mean I have to see how many rows have been added from the beginning to now (even rows that have been deleted in the past)
The method you just mentioned says only the number of rows in the table

Well, how can you count rows that have been deleted already?

Do you know the way?

Qlagh 2021-10-17 09:22:36
MasterZiv 2021-10-17 09:22:25
Well, how can you count rows that have been deleted already?

Do you know the way?

im asking you

MasterZiv 2021-10-17 09:23:14
Qlagh 2021-10-17 09:22:36
im asking you

I dont know neither

MasterZiv 2021-10-17 09:25:44
Qlagh 2021-10-17 09:21:06
I mean I have to see how many rows have been added from the beginning to now (even rows that have been deleted in the past)
The method you just mentioned says only the number of rows in the table

You can separately keep records of each row being added or deleted by means of code of your application, inside DBMS our outside.
But this what DBMS cannot do for you automatically

OnlySmene 2021-10-17 21:07:31
Hi guys, I’am new in MySQL and I would like to ask something about it.
I develop in python and I’m currently going in this way:

Create a single connection to share into all the files.

I would like to understand if is this a good practice and then, do I create a single cursor as the connection or opening and closing a cursor for every query?

Thanks in advance!

MasterZiv 2021-10-17 22:11:33
OnlySmene 2021-10-17 21:07:31
Hi guys, I’am new in MySQL and I would like to ask something about it.
I develop in python and I’m currently going in this way:

Create a single connection to share into all the files.

I would like to understand if is this a good practice and then, do I create a single cursor as the connection or opening and closing a cursor for every query?

Thanks in advance!

You can’t reuse a cursor from a query for the next query.
It s not possible

OnlySmene 2021-10-17 22:12:00
MasterZiv 2021-10-17 22:11:33
You can’t reuse a cursor from a query for the next query.
It s not possible

so opening and closing a new cursor is the right way?

MasterZiv 2021-10-17 22:18:06
OnlySmene 2021-10-17 22:12:00
so opening and closing a new cursor is the right way?

Yes, moreover, you can’t execute next query without closing the previous query (cursor of the previous query )

OnlySmene 2021-10-17 22:22:13
MasterZiv 2021-10-17 22:18:06
Yes, moreover, you can’t execute next query without closing the previous query (cursor of the previous query )

I mean a global cursor, not a closed one, but ok, thanks

thanosphan 2021-10-17 23:44:11
OnlySmene 2021-10-17 21:07:31
Hi guys, I’am new in MySQL and I would like to ask something about it.
I develop in python and I’m currently going in this way:

Create a single connection to share into all the files.

I would like to understand if is this a good practice and then, do I create a single cursor as the connection or opening and closing a cursor for every query?

Thanks in advance!

Go for connection pooling

|