Can one create a view with multiple where statements?

|
Anfield 2021-05-15 01:38:15
Hello, I’m having issue downloading MySQL product ( server and shell)…it brings error when downloading, what can I do ?
piterden 2021-05-15 04:06:04
Anfield 2021-05-15 01:38:15
Hello, I’m having issue downloading MySQL product ( server and shell)…it brings error when downloading, what can I do ?

Nobody knows except you

MasterZiv 2021-05-15 08:37:40
CMDLS 2021-05-14 22:08:29
Anyone can help me ? How can i learn DBMS ?

I can , read books, go to study in an university.

Gunechi 2021-05-15 09:18:11
Can one create a view with multiple where statements?
Gunechi 2021-05-15 09:19:12
How can I view a ldf file …
MasterZiv 2021-05-16 08:49:33
Gunechi 2021-05-15 09:18:11
Can one create a view with multiple where statements?

A view can contain almost any select statement.

A select statement can have only one WHERE clause and one HAVING clause.
But it can have any number of subqueries, each of which can have one WHERE and one HAVING.

Plus, you can combine several select statements by means of UNION clause.

So, theoretically , a view can have unlimited number of WHERE-s.

piterden 2021-05-16 10:27:00
MasterZiv 2021-05-16 08:49:33
A view can contain almost any select statement.

A select statement can have only one WHERE clause and one HAVING clause.
But it can have any number of subqueries, each of which can have one WHERE and one HAVING.

Plus, you can combine several select statements by means of UNION clause.

So, theoretically , a view can have unlimited number of WHERE-s.

Limited by dbms limits

eg2710 2021-05-16 19:48:19
Hi , could someone help me , giving feedback on this model er ?

Model er of an e commerce for the sale of products of a company.

The infrastructure company has as attribute type, because in the context you will have a headquarters characterized by peripheral locations and final hubs .

Thanks.

MasterZiv 2021-05-18 10:29:24
eg2710 2021-05-16 19:48:19
Hi , could someone help me , giving feedback on this model er ?

Model er of an e commerce for the sale of products of a company.

The infrastructure company has as attribute type, because in the context you will have a headquarters characterized by peripheral locations and final hubs .

Thanks.

All is more or less fine except one thing: there is no ORDER.
Usually customers tend to order several products at the same time, and this forms the ORDER which a courier may deliver.
You dont have such entity and now a courier can’t even firure out to whom and what he should deliver.

Liran 2021-05-18 11:58:30
How can i create an automatic backup for mysql 5.7?
Curioustolearn 2021-05-18 12:05:24
Liran 2021-05-18 11:58:30
How can i create an automatic backup for mysql 5.7?

https://github.com/naskavinda/Auto-Backup-MySQL-Database

If you are on windows

naskavinda/Auto-Backup-MySQL-DatabaseGitHub
Auto Backup MySQL database using batch file. Contribute to naskavinda/Auto-Backup-MySQL-Database development by creating an account on GitHub.
Curioustolearn 2021-05-18 12:05:35
https://serverguy.com/servers/how-to-backup-mysql-database/

How to Backup MySQL Database (3 Simple Methods)ServerGuy.com
Three quick steps to backup mysql database without losing a single table. How to restore mysql backup to the server with command line and php.
madno 2021-05-18 12:06:35
Hi, Can we partition a table which has foreign keys
Curioustolearn 2021-05-18 12:06:59
Curioustolearn 2021-05-18 12:05:24
https://github.com/naskavinda/Auto-Backup-MySQL-Database

If you are on windows

I did not test any of these methods

MasterZiv 2021-05-18 13:36:07
Liran 2021-05-18 11:58:30
How can i create an automatic backup for mysql 5.7?

Just write a simple script to backup the db and assign it to some time in the system scheduler.

MasterZiv 2021-05-18 13:37:34
madno 2021-05-18 12:06:35
Hi, Can we partition a table which has foreign keys

Most probably yes.

Liran 2021-05-18 14:06:11
MasterZiv 2021-05-18 13:36:07
Just write a simple script to backup the db and assign it to some time in the system scheduler.

what about a crontab with dump command? do you think it’s a good solution for automatic backup?

MasterZiv 2021-05-18 14:21:59
Liran 2021-05-18 14:06:11
what about a crontab with dump command? do you think it’s a good solution for automatic backup?

Brilliant solution

Deb_575 2021-05-18 14:25:03
Liran 2021-05-18 14:06:11
what about a crontab with dump command? do you think it’s a good solution for automatic backup?

That’s the only solution for community edition, Create a script and schedule it in crontab unless you are using some kind of backup utility like Veritas netbackup

Liran 2021-05-18 14:25:37
Great guys, thanks for the help 🙂
madno 2021-05-18 15:26:42
MasterZiv 2021-05-18 13:37:34
Most probably yes.

https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
I think it is not supported

piterden 2021-05-18 17:20:34
madno 2021-05-18 15:26:42
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
I think it is not supported

Not supported partitioning by foreign keys

piterden 2021-05-18 17:21:32
You can partition table which has FKs not by one or more of them
lalit kumar 2021-05-18 18:52:06
somebody suggest me how to learn sql for beginners etc youtube channel
MasterZiv 2021-05-18 19:14:21
lalit kumar 2021-05-18 18:52:06
somebody suggest me how to learn sql for beginners etc youtube channel

Read Martin Gruber’s book , must be called smthn like introduction tio SQL

MasterZiv 2021-05-18 19:14:55
lalit kumar 2021-05-18 18:52:06
somebody suggest me how to learn sql for beginners etc youtube channel

Damn yourtube chanals, all are shit

lalit kumar 2021-05-18 19:15:41
ok bro
Paynalton 2021-05-19 01:23:31
Hi guys. Do you have a favorite Database migration tool???
MasterZiv 2021-05-19 01:51:51
Paynalton 2021-05-19 01:23:31
Hi guys. Do you have a favorite Database migration tool???

Yes I do have.

piterden 2021-05-19 02:10:26
MasterZiv 2021-05-19 01:51:51
Yes I do have.

Is it your right arm?

MasterZiv 2021-05-19 02:28:49
piterden 2021-05-19 02:10:26
Is it your right arm?

Both. And the brain

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
piterden 2021-05-19 17:01:24
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

Yes

piterden 2021-05-19 17:01:42
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

But why?

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.
|