I didnt understand sorry, is different things MYSQL and SQLServer?

|
piterden 2021-05-19 17:04:39
madno 2021-05-19 17:04:00
Query is not optimized for the primary key. So creating a separate index. Then planning to drop the column from PK.

What do you store in this table?

madno 2021-05-19 17:09:13
We store the payment details
rodrigo_tc7 2021-05-19 18:25:58
You can keep both indexes
madno 2021-05-19 18:54:33
rodrigo_tc7 2021-05-19 18:25:58
You can keep both indexes

Yes, i was able to create secondary index.

MasterZiv 2021-05-20 11:20:11
madno 2021-05-19 16:21:44
Hi everyone,I have PRIMARY KEY (id, wallet_id). Can I add a secondary index for wallet_id in se table

You may have theoretically unlimited number of indices in a table. And only one unique primary key

UnknownError417 2021-05-20 11:23:55
Hey guys do you recommend this is a good database for a social recommendation algorithm ?
piterden 2021-05-20 11:24:37
UnknownError417 2021-05-20 11:23:55
Hey guys do you recommend this is a good database for a social recommendation algorithm ?

It is for storing your data

MasterZiv 2021-05-20 11:47:08
UnknownError417 2021-05-20 11:23:55
Hey guys do you recommend this is a good database for a social recommendation algorithm ?

Which one?

MasterZiv 2021-05-20 11:48:36
UnknownError417 2021-05-20 11:23:55
Hey guys do you recommend this is a good database for a social recommendation algorithm ?

A database keeps data, it doesn’t implement algorithms.
So a DB cannot be for or not for soothe particular algorithm.

ysf_cms 2021-05-23 12:27:25
I have 145 gb sql file , ı want to import mysql
ysf_cms 2021-05-23 12:28:13
How can ı import faster ? I use source command , it take 1 week but it does not import :/
MasterZiv 2021-05-23 14:28:45
ysf_cms 2021-05-23 12:28:13
How can ı import faster ? I use source command , it take 1 week but it does not import :/

by using mysql console utility

MasterZiv 2021-05-23 14:29:14
ysf_cms 2021-05-23 12:28:13
How can ı import faster ? I use source command , it take 1 week but it does not import :/

Check messages, logs, there must be some error

Curioustolearn 2021-05-23 20:06:56
Humm !!!
https://www.w3schools.com/mysql/default.asp

MySQL TutorialW3Schools
W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.
Deb_575 2021-05-23 21:38:43
ysf_cms 2021-05-23 12:28:13
How can ı import faster ? I use source command , it take 1 week but it does not import :/

Use mysql client and set foreign key checks to zero, bin log to zero and max allowed packets to maximum if it’s Mysql 8.0 that would be 1024MB

diogorocha20 2021-05-24 10:47:55
Does anyone know why this code dont work in my MySQL – select * from main_mp
where Data between DateAdd(DD,-7,GETDATE() ) and GETDATE()
diogorocha20 2021-05-24 10:48:12
Error
SQL query: Copy Documentation

select * from main_mp
where Data between DateAdd(DD,-7,GETDATE() ) and GETDATE() LIMIT 0, 25
MySQL said: Documentation

#1305 – FUNCTION pentaplast.DateAdd does not exist

MasterZiv 2021-05-24 11:55:13
diogorocha20 2021-05-24 10:47:55
Does anyone know why this code dont work in my MySQL – select * from main_mp
where Data between DateAdd(DD,-7,GETDATE() ) and GETDATE()

https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html

Re-check MySQL built-in function names for your purpose here.

There is no DateAdd function in MySQL

diogorocha20 2021-05-24 12:01:42
MasterZiv 2021-05-24 11:55:13
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html

Re-check MySQL built-in function names for your purpose here.

There is no DateAdd function in MySQL

so this is wrong? https://www.w3schools.com/sql/func_sqlserver_dateadd.asp

SQL Server DATEADD() FunctionW3Schools
W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.
MasterZiv 2021-05-24 12:02:52
diogorocha20 2021-05-24 12:01:42
so this is wrong? https://www.w3schools.com/sql/func_sqlserver_dateadd.asp

This is CORRECT.
The article about SQLServer.

diogorocha20 2021-05-24 12:04:08
i didnt understand sorry, is different things MYSQL and SQLServer? Isnt it the same things? Sorry for asking
MasterZiv 2021-05-24 12:05:03
diogorocha20 2021-05-24 12:04:08
i didnt understand sorry, is different things MYSQL and SQLServer? Isnt it the same things? Sorry for asking

MySQL is MySQL , SQLServer is a relational DBMS by Misrosoft.
They are completely different

diogorocha20 2021-05-24 12:10:17
ho ok
CMDLS 2021-05-24 12:13:11
Ok thank you
MasterZiv 2021-05-24 12:15:09
How to take incremental back up in windows MySQL
MasterZiv 2021-05-24 12:15:10
Then how to collect regular backup to time period , if you have any cornjob
MasterZiv 2021-05-24 12:15:10
No incremental backups in vanilla MySQL afaik
MasterZiv 2021-05-24 12:17:25
MasterZiv 2021-05-24 12:15:10
Then how to collect regular backup to time period , if you have any cornjob

This and other interesting question is in our new magazine “NOWAY”!

Hades $ :(){ :|:& };: Polaris 2021-05-24 20:02:25
@RS20012, Thank you for your shared MySQL-Notes
piterden 2021-05-24 20:52:25
Hades $ :(){ :|:& };: Polaris 2021-05-24 20:02:25
@RS20012, Thank you for your shared MySQL-Notes

https://sqlzoo.net/

CMDLS 2021-05-24 20:55:21
Which software to best practices MYsql opration
piterden 2021-05-24 20:55:33
CMDLS 2021-05-24 20:55:21
Which software to best practices MYsql opration

MySQL

CMDLS 2021-05-24 20:55:47
MYSQL
piterden 2021-05-24 20:56:38
MySQL-server is the best software to practice
piterden 2021-05-24 20:58:00
You can also try to guess the best site to learn mysql
|