How to write a formula in mysql?

Question

MySQL

There is a table
ev_id
|ev_cl|ev_star
1|2|4.3
2|2|3.0
3|2|1.0
I need to calculate the average score from all ratings, preferably in a single mysql query.

Answer 1

AVG()

Answer 2

Someone else's landing / site can be downloaded using webcloner.ru , if you want to upload your own from the server, then filezilla will help. But if the constructor is: tilde, wix, yukoz, then only through services. Because they do not allow to unload the entire site.

Answer 3

wget -r?

Answer 4

Try "Cyotek WebCopy".
www.cyotek.com/cyotek-webcopy

Answer 5

You can also try this site download system - https://ru.archivarix.com
The service downloads the site online, then sends the finished site to the email in a zip file along with the CMS. It will be a workable site, with a loader and the ability to edit files, and not just a set of html files and pictures, which is usually obtained when downloaded by other downloaders. This is the main difference between the service, in fact, it imports the downloaded site to its CMS from any other, this gives great opportunities for subsequent content editing, such as removing broken links, counters and ads, creating new pages in the downloaded site based on existing ones, etc.
In order to view the site on your computer, you will need to install a local Apache server, for example this one -https://www.apachefriends.org/en/index.html

Answer 6

If you are unable to download the site catalog using programs, can you then try to do this through online services? And this will be the first option, how you can copy the entire site. The second option is to find a freelance specialist who will parse these same files for you. You can also try to copy it yourself using a php script. Of course, there are options for how to copy a site completely, and there are more than one of them, not only with the help of programs, you can do it. And so, I would advise you to immediately look for specialists, since it is not a fact that the script will give a better result than a specially designed program. Google for related queries like "copy site online service". Now, I think that it will not be difficult to find someone who will copy the entire site for you and for a reasonable price. For example, during a cursory search, I was given sitecopy.pro - a service for copying landing pages and... . You need something like that, where they will make a copy for you and not be lost, as is the case with freelancing. By the way, before you try to copy what you want, find out in advance, consult, ask to make a copy for verification. Paying money for an unknown result, of course, is not worth it. In theory, you should either confirm that the files are not copied, or make a copy and send a link to it.

Answer 7

I tried webparse.ru - you can download the mobile version and the desktop one. Various rates are available. Test download is free

Answer 8

I downloaded sites using the Offline Explorer program .
Downloaded without any problems with all pages and resources.
There are many cracked versions of this program on the rutracker.

Answer 9

There is also saveweb2zip.com , you can copy the site to the archive for free, and then do whatever you want with it.

Answer 10

Teleport Pro, WinHTTrack

Answer 11

Well, it means you don't have access to this folder.

Answer 12

FileZilla

Answer 13

https://webparse.ru/site2zip.com/ru
_

Answer 14

Is there a WGET command to download the site? the day was swinging I don’t have time to download everything, I want to continue tomorrow