In that case, aurora or mysql?

|
MasterZiv 2021-02-25 00:33:07
Makgato 2021-02-25 00:30:48
Guys i need to know that if i connect mySQL with visual studio code for C++

Can i create program in C++ for user to store information in database from mySQL ?

yes, you can.

MasterZiv 2021-02-25 00:33:55
Makgato 2021-02-25 00:30:48
Guys i need to know that if i connect mySQL with visual studio code for C++

Can i create program in C++ for user to store information in database from mySQL ?

But for this there is no need to connect to a database, although you can do this.

Makgato 2021-02-25 00:38:58
MasterZiv 2021-02-25 00:33:55
But for this there is no need to connect to a database, although you can do this.

I can do using C++ language only or mySQL ?🤔

MasterZiv 2021-02-25 00:42:04
Makgato 2021-02-25 00:38:58
I can do using C++ language only or mySQL ?🤔

to create program in C++ to store information in mySQL database you need to use C++ and MySQL

Makgato 2021-02-25 01:40:56
MasterZiv 2021-02-25 00:42:04
to create program in C++ to store information in mySQL database you need to use C++ and MySQL

Ok thank you

madno 2021-02-25 07:24:00
Hi, I have a table column which stores disk size. It can be in TB, GB or MB. How can I change these all to Bytes using a query
MasterZiv 2021-02-25 08:15:04
madno 2021-02-25 07:24:00
Hi, I have a table column which stores disk size. It can be in TB, GB or MB. How can I change these all to Bytes using a query

You can do it by meats of UPDATE query.

J 2021-02-25 14:24:07
Hello,

Anyone know where to find murex guide and resources? Thanks

MasterZiv 2021-02-25 14:56:15
J 2021-02-25 14:24:07
Hello,

Anyone know where to find murex guide and resources? Thanks

What’s “murex” ?

J 2021-02-25 15:19:36
A special software
rodrigo_tc7 2021-02-26 01:33:55
madno 2021-02-25 07:24:00
Hi, I have a table column which stores disk size. It can be in TB, GB or MB. How can I change these all to Bytes using a query

Update with case and instr()

piterden 2021-02-27 00:58:10
.5Gb zip? Is it video?
Ashwin_Bruno 2021-02-27 00:59:21
Yes it’s a video tutorials for performance tuning.
File size is in MB
piterden 2021-02-27 01:21:00
Ashwin_Bruno 2021-02-27 00:59:21
Yes it’s a video tutorials for performance tuning.
File size is in MB

But zip almost doesn’t compress videos. Just share video file

piterden 2021-02-27 01:21:48
Also zip is good for hiding viruses
Ashwin_Bruno 2021-02-27 01:24:20
Ohh okk cool…actually there were total 20-25 videos so I thought will combine it in a zip file and share.
Ashwin_Bruno 2021-02-27 01:24:26
piterden 2021-02-27 01:21:48
Also zip is good for hiding viruses

True

piterden 2021-02-27 01:25:38
Moreover, videos have a preview thumbnail
piterden 2021-02-27 01:26:13
Why don’t you just share link to videohoster?
Ashwin_Bruno 2021-02-27 01:26:22
piterden 2021-02-27 01:25:38
Moreover, videos have a preview thumbnail

Yeah I got it

piterden 2021-02-27 01:27:36
Ashwin_Bruno 2021-02-27 01:26:22
Yeah I got it

Btw, videos are worse for studying something technical

piterden 2021-02-27 01:28:39
And as for me, I do not watch any videos )))
Ashwin_Bruno 2021-02-27 01:29:43
piterden 2021-02-27 01:26:13
Why don’t you just share link to videohoster?

Yeah I should have done that..my bad🤦‍♂🤦‍♂

Ashwin_Bruno 2021-02-27 01:31:15
piterden 2021-02-27 01:27:36
Btw, videos are worse for studying something technical

Yeah some prefer books and some prefer videos too.. actually I went through that video and it’s really helpful so that thought of sharing the video

adinath_kamode 2021-03-01 18:04:35
Team, I have a situation.
One legacy application table has been using MyIsam engine with fulltext index. Working very well , providing matching word count and rank using match-against.
Now this app is moving to AWS only with InnoDB, but match against is providing complete different results and results not matching with myISAM.
The way InnoDb calculates match against is different, does anyknow how can I maintain same results on InnoDB?
MasterZiv 2021-03-01 18:12:43
adinath_kamode 2021-03-01 18:04:35
Team, I have a situation.
One legacy application table has been using MyIsam engine with fulltext index. Working very well , providing matching word count and rank using match-against.
Now this app is moving to AWS only with InnoDB, but match against is providing complete different results and results not matching with myISAM.
The way InnoDb calculates match against is different, does anyknow how can I maintain same results on InnoDB?

I don’t have personal experience related to this but I believe the behavior should be same.
Have you read about these distinct behavior in the documentation?

adinath_kamode 2021-03-01 18:35:19
MasterZiv 2021-03-01 18:12:43
I don’t have personal experience related to this but I believe the behavior should be same.
Have you read about these distinct behavior in the documentation?

I was expecting same or at least 90% match, but it is like 360 degree different, There are documents saying it is different and match not sure. Rewriting application is not the solution.

MasterZiv 2021-03-01 18:36:01
adinath_kamode 2021-03-01 18:35:19
I was expecting same or at least 90% match, but it is like 360 degree different, There are documents saying it is different and match not sure. Rewriting application is not the solution.

Can you give a link to the docs saying that ?

MasterZiv 2021-03-01 18:36:55
adinath_kamode 2021-03-01 18:35:19
I was expecting same or at least 90% match, but it is like 360 degree different, There are documents saying it is different and match not sure. Rewriting application is not the solution.

This looks like you are not migrating to this AWS service….
🙂

rodrigo_tc7 2021-03-02 00:26:46
Are you using rds?
In that case, aurora or mysql?
adinath_kamode 2021-03-02 05:04:17
Mysql,
adinath_kamode 2021-03-02 05:05:32
adinath_kamode 2021-03-01 18:35:19
I was expecting same or at least 90% match, but it is like 360 degree different, There are documents saying it is different and match not sure. Rewriting application is not the solution.

One approach i am thinking is to create a temporary table in.myisam based on filter criteria, return results and drop that temp table.

Gladiator Xf 2021-03-02 09:59:40
I am unable to install sql anyne who can help
piterden 2021-03-02 10:01:49
Gladiator Xf 2021-03-02 09:59:40
I am unable to install sql anyne who can help

I can. What do you want me to do?

Gladiator Xf 2021-03-02 10:02:19
I am a beginner and want to download mysql bu am unable to
|