    SELECT some_cols
    FROM prefix_users
    WHERE (some conditions)
    ORDER BY pic_set DESC, last_activity;

&gt;**Note** that we can place `ASC` or `DESC` after each column (like above does for `pic_set`), or leave it to default (like above&#39;s `last_activity`-column).

Sort by picture and then by activity:

    SELECT some_cols
    FROM `prefix_users`
    WHERE (some conditions)
    ORDER BY pic_set, last_activity DESC;



    SELECT id, user_id, video_name
    FROM sa_created_videos
    ORDER BY LENGTH(id) ASC, LENGTH(user_id) DESC

I&#39;m using git 1.7.1 on Ubuntu 10.10 amd64, and I&#39;m trying to extract the hash of my repository HEAD to use it in an automated version information that I compile into my project.

In the past, this always worked by using 

    git describe --tags

however, git is now throwing 

    fatal: No names found, cannot describe anything.
at me. Does anyone have a clue what that means?

Google showed only few hits and no solution.

git describe fails with &quot;fatal: No names found, cannot describe anything.&quot;

I&#39;m making a search page, where you type a search query and the form is submitted to `search.php?query=your query`. What PHP function is the best and that I should use for encoding/decoding the search query?


How to properly URL encode a string in PHP?

Is it possible to order by multiple rows? 

I want my users to be sorted by `last_activity`, but at the same time, I want the users with pictures to appear before the ones without

Something like this:

    SELECT some_cols
    FROM `prefix_users`
    WHERE (some conditions)
    ORDER BY last_activity, pic_set DESC;



MySQL query order by multiple items

Is it possible to order by multiple rows?
I want my users to be sorted by <code>last_activity</code>, but at the same time, I want the users with pictures to appear before the ones without
Something like this:
<pre><code class="hljs language-sql">SELECT some_cols
FROM `prefix_users`
WHERE (some conditions)
ORDER BY last_activity, pic_set DESC;
</code></pre>

I want to define table which will have 2 TIMESTAMP fields, someting like this:

    CREATE TABLE `msgs` (
        `id` INT PRIMARY KEY AUTO_INCREMENT,
        `msg` VARCHAR(256),
        `ts_create` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        `ts_update` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    )

How to do this avoiding error:

    ERROR 1293 (HY000): Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

Point is to keep desired behavior of `ts_create` and `ts_update` in table schema.

MySQL CURRENT_TIMESTAMP on create and on update

How to drop multiple tables from one single database at one command.
something like,

    &gt; use test; 
    &gt; drop table a,b,c;

where a,b,c are the tables from database test.




Drop multiple tables in one shot in MySQL

I want to take the whole database. Where do I find the database file?

And is there a way to write the whole database with all data to a text file (like the one in SQL Server)?


How to generate the whole database script in MySQL Workbench?

I&#39;m building a website with MySQL.  I&#39;m using TOAD for MySQL and suddenly I can&#39;t connect to the database as I&#39;m getting an error:

&gt; **&quot;Too many connections&quot;**

Is there any way in Toad for MySQL to view existing connections to be able to kill them or simple close all connections all together?

How to kill MySQL connections

I am working on a moderately complex schema in MySQL Workbench, and the single page of the EER diagram is now full up. Does anyone know how to enlarge it to two or more pages?

How do I enlarge an EER Diagram in MySQL Workbench?

I have an object that looks something like this:

    public class Student
    {
        public string Name { get; set; } 
        public int Grade { get; set; }
    }

I would like to create the following query: group grades by student name, order each student group by grades, and order groups by max grade in each group.

So it will look like this: 

    A 100
    A 80
    B 80
    B 50
    B 40
    C 70
    C 30

I created the following query:

    StudentsGrades.GroupBy(student =&gt; student.Name)
        .OrderBy(studentGradesGroup =&gt; studentGradesGroup.Max(student =&gt; student.Grade));
But that returns `IEnumerable` `IGrouping`, and I have no way to sort the list inside, unless I do that in another `foreach` query and add the results to a different list using `AddRange`.

Is there a prettier way to do that?



Linq order by, group by and order by each group?

I need to find the latest post for each author and then group the results so I only a single latest post for each author.


    SELECT wp_posts.* FROM wp_posts
			WHERE wp_posts.post_status=&#39;publish&#39;
			AND wp_posts.post_type=&#39;post&#39;
			GROUP BY wp_posts.post_author			
			ORDER BY wp_posts.post_date DESC


This is correctly grouping the output so I only get one post per author, but it is ordering the results after they have been grouped and not before they have been selected.

MySQL Order before Group by

I have a very small script to get all records from a database table, the code is below.

    $query = $this-&gt;db-&gt;get($this-&gt;table_name);
    return $query-&gt;result();

Using this syntax, how would I add a `ORDER BY &#39;name&#39;` clause to my select query?

I get errors every time I stick the order by bit on the end.

How to add an ORDER BY clause using CodeIgniter&#39;s Active Record methods?

I&#39;m sure this will be a relatively simple one.

I have a LINQ query that I want to order by the most recently created date.

See:

            var itemList = from t in ctn.Items
                            where !t.Items &amp;&amp; t.DeliverySelection
                            orderby t.Delivery.SubmissionDate descending
                            select t;

I have also tried:

           var itemList = (from t in ctn.Items
                            where !t.Items &amp;&amp; t.DeliverySelection
                            select t).OrderByDescending();

but this gives an error :

&gt; No overload for method
&gt; &#39;OrderByDescending&#39; takes 0 arguments

From what I&#39;ve read, I&#39;m fairly sure the first way I&#39;ve done it should work. I&#39;ve tried changing descending to ascending just to see if it does anything but it stays the same. 

I&#39;d be grateful if someone could take a look at the query and see if I&#39;m doing anything wrong. Thanks :)


LINQ Orderby Descending Query

After executing the following statement:

    SELECT  Category  FROM MonitoringJob ORDER BY CreationDate DESC

I am getting the following values from the database:

    test3
    test3
    bildung
    test4
    test3
    test2
    test1

but I want the duplicates removed, like this:

    bildung
    test4
    test3
    test2
    test1

I tried to use DISTINCT but it doesn&#39;t work with ORDER BY in one statement. Please help.

Important:

1. I tried it with:

        SELECT DISTINCT Category FROM MonitoringJob ORDER BY CreationDate DESC

    it doesn&#39;t work.

2. Order by CreationDate is very important.

Content Type	Original Author	Original Content on Stackoverflow
Question	Alexander	View Question on Stackoverflow
Solution 1 - Mysql	ihorko	View Answer on Stackoverflow
Solution 2 - Mysql	eumiro	View Answer on Stackoverflow
Solution 3 - Mysql	Pankaj Yadav	View Answer on Stackoverflow

MySQL query order by multiple items

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

How to properly URL encode a string in PHP?

git describe fails with "fatal: No names found, cannot describe anything."

Attributions