image_pdfimage_print

MySQL by examples

mysql

Content

  1. Using what query in MySQL it is possible to display several maximum values?
  2. What does the error ‘Too many connections’ mean?
  3. How to provide access to MySQL Denwer from the local network?
  4. How to delete records from a table if their date is 10 days earlier than the current one?
  5. How to use queries with UPDATE MySQL command?
  6. How to output the data from the primary and subordinated table into one by means of UNION MySQL query?

Using what query in MySQL it is possible to display several maximum values?

Example of query:

SELECT field1 FROM Table ORDER BY field1 DESC LIMIT 5

or if there is one value

SELECT MAX(field) FROM Table

What does the error ‘Too many connections’ mean?

Read more