What is diferences between MySQL and MSSQL?

|
Nelson Mathew 2020-04-10 22:16:45
But its also not working in the db
Nelson Mathew 2020-04-10 22:17:38
I m confused because, the function is working in all another db with same structure
smlkw 2020-04-11 00:36:55
Nelson Mathew 2020-04-10 22:17:38
I m confused because, the function is working in all another db with same structure

you need to check out your mysql logs and to understand why the query is running so many times

smlkw 2020-04-11 00:37:10
maybe your server is slow
Nelson Mathew 2020-04-11 06:03:56
I m working in localhost
Nelson Mathew 2020-04-11 06:04:35
Only one time i m using the function
2020-04-11 10:25:41
I need your help. Recently i took a script and cleaned it is shells and bags but while using i told to one master and he could enter to my datebase in 15 minutes but i could find what the problem is ?
2020-04-11 10:25:48
Who can help me?
Paynalton 2020-04-11 17:26:45
2020-04-11 10:25:41
I need your help. Recently i took a script and cleaned it is shells and bags but while using i told to one master and he could enter to my datebase in 15 minutes but i could find what the problem is ?

I cant understand

2020-04-11 17:27:52
Paynalton 2020-04-11 17:26:45
I cant understand

Can you pass to private?

MasterZiv 2020-04-11 17:37:46
Nelson Mathew 2020-04-10 20:35:07
I am facing an issue with a stored function in mysql db..

Its working fine with db A. But its not working in db B.. both A & B are similar one… what will be the issue?? Anybody plz help me

Heck!

Where are details?

Now I can only tell you that you have issues!

sea1011 2020-04-11 17:44:20
sixpeteunder 2020-03-28 13:16:04
Something I’m building has a votes system, with a user being able to cast a single upvote or downvote.

Should I represent this in the DB as a signed tinyint column, or as an enum with +1 and -1 as the options?

Did you know how to do it?

sea1011 2020-04-11 17:44:34
Because i want to do it in my app
MasterZiv 2020-04-11 17:45:00
Nelson Mathew 2020-04-10 21:54:24
I m using a function to find out one id’s ancestor ids which is in hierarchical level… it is working fine in some DBs.. but,ina a particular db its not working.. it got hanged..

Except the fact that this function is not needed for a fuck, I can’t say anything. There are no details, no errors, nothing.

I recommend you dropping this function out and add the subquery to the place that uses this function

MasterZiv 2020-04-11 17:45:58
Nelson Mathew 2020-04-10 22:08:13
No… its just hanged…

Do it from mysql utility then

sea1011 2020-04-11 17:47:22
Waiting your reply
MasterZiv 2020-04-11 17:47:54
2020-04-11 10:25:41
I need your help. Recently i took a script and cleaned it is shells and bags but while using i told to one master and he could enter to my datebase in 15 minutes but i could find what the problem is ?

I’ll be dropping the questions that cannot be answered, I think

MasterZiv 2020-04-11 17:49:44
sea1011 2020-04-11 17:44:20
Did you know how to do it?

You can do this any way, this or that, it doesn’t matter how you do this.

sea1011 2020-04-11 17:50:12
MasterZiv 2020-04-11 17:49:44
You can do this any way, this or that, it doesn’t matter how you do this.

Ok good, what about the next question

MasterZiv 2020-04-11 17:50:32
sea1011 2020-04-11 17:50:12
Ok good, what about the next question

Which one?

sea1011 2020-04-11 17:50:38
This
MasterZiv 2020-04-11 17:51:05
sea1011 2020-04-11 17:50:38
This

I don’t see any..

sea1011 2020-04-11 17:51:17
Funny admin πŸ˜‚
MasterZiv 2020-04-11 17:52:03
sea1011 2020-04-11 17:51:17
Funny admin πŸ˜‚

Because, if you ask stupid questions, they cannot be answered

sea1011 2020-04-11 17:52:19
Why? It is good questions
MasterZiv 2020-04-11 17:52:40
sea1011 2020-04-11 17:52:19
Why? It is good questions

It’s not

sea1011 2020-04-11 17:52:44
Because someone said that MySql is not fast when you want to read the data from it
2020-04-11 17:53:09
MasterZiv 2020-04-11 17:47:54
I’ll be dropping the questions that cannot be answered, I think

SureπŸ˜’

sea1011 2020-04-11 17:53:53
I dont know about MySQL very much
MasterZiv 2020-04-11 17:56:04
sea1011 2020-04-11 17:52:44
Because someone said that MySql is not fast when you want to read the data from it

It’s like asking ” is boing 737 fast? I wanna fly to New York”!

And I’ll say “No, Mig-35 is faster!”

But you will not fly Mig-35 to New York, nobody will let you do this!

sea1011 2020-04-11 17:57:30
Ok
sea1011 2020-04-11 17:57:46
Good
sea1011 2020-04-11 17:57:51
Good person
MasterZiv 2020-04-11 18:07:32
2020-04-11 17:27:52
Can you pass to private?

You didn’t write nothin neither here nor in Russian chat, but ask help in PMs.

I deleted all in Russian chat, but next time you do so i’m gonna ban you from both.

2020-04-11 18:08:13
MasterZiv 2020-04-11 18:07:32
You didn’t write nothin neither here nor in Russian chat, but ask help in PMs.

I deleted all in Russian chat, but next time you do so i’m gonna ban you from both.

I see

smlkw 2020-04-12 00:01:45
Nelson Mathew 2020-04-11 06:03:56
I m working in localhost

Have you checked your MySQL logs?

marko2202 2020-04-12 21:20:52
What is diferences between MySQL and MSSQL?
smlkw 2020-04-12 22:25:41
marko2202 2020-04-12 21:20:52
What is diferences between MySQL and MSSQL?

MMSQL is Microsoft SQL Server

marko2202 2020-04-12 22:29:52
Is there any syntax differences?
Ezzmo77 2020-04-12 22:30:36
Sql vs tsql
MasterZiv 2020-04-13 08:36:27
marko2202 2020-04-12 22:29:52
Is there any syntax differences?

Yes, these are completely different DBMS, everything is different

MasterZiv 2020-04-13 08:37:20
marko2202 2020-04-12 22:29:52
Is there any syntax differences?

SQL principals and basics only are same

ranasharif 2020-04-14 07:11:33
Happy Bangla New Year 1427
smlkw 2020-04-14 12:24:19
ranasharif 2020-04-14 07:11:33
Happy Bangla New Year 1427

Please, without offtopic

Sagar 2020-04-14 13:32:49
how to find the no of hours, minutes,Seconds between two datetime values
I know to find the Hours and minutes but stack in seconds.. Can please help
Select Cast(DatedIFF(MINUTE,Getdate()-1,Getdate())/60 as varchar(20))+’:’+Cast(DatedIFF(MINUTE,Getdate()-1,Getdate())%60 as varchar(20))
AleHerz 2020-04-15 01:19:10
Aborted connection 110 to db: ‘DBTest’ user: ‘username’ host: ‘x.x.x.x’ (Got an error reading communication packets) How i can resolve this problem? 1 of 2 query generate this… and this Connection attributes of length 106 were truncated

Query like this… UPDATE users SET in_group=1 WHERE id=18121313

MasterZiv 2020-04-15 01:49:00
AleHerz 2020-04-15 01:19:10
Aborted connection 110 to db: ‘DBTest’ user: ‘username’ host: ‘x.x.x.x’ (Got an error reading communication packets) How i can resolve this problem? 1 of 2 query generate this… and this Connection attributes of length 106 were truncated

Query like this… UPDATE users SET in_group=1 WHERE id=18121313

This is networking problems

AleHerz 2020-04-15 01:49:51
MasterZiv 2020-04-15 01:49:00
This is networking problems

I use a connection pool, could that be the cause?

MasterZiv 2020-04-15 01:58:00
AleHerz 2020-04-15 01:49:51
I use a connection pool, could that be the cause?

I don’t think so, but who knows..

AleHerz 2020-04-15 02:50:50
MasterZiv 2020-04-15 01:58:00
I don’t think so, but who knows..

I put everything on a vps server to try, but nothing’s changed… I’m using a “OVH Cloud Database” service

|