I have following data structure in MySQL database:  { date: text name: text }   and a data set:  "2016-01-01" "a1" "2016-01-02" "a2" "2016-01-02" "a3" "2016-01-03" "a4"   I would like to combine "name" field, if the "date" is a same in different rows. So at the end to have something like:  "2016-01-01" "a1" "2016-01-02" "a2, a3" "2016-01-03" "a4"   Of course I could iterate over results-array and build a new structure, like this one, programmatically.. but maybe its a faster way to do this directly in SQL Query?
Basically the question is how to get from this:   foo_id   foo_name 1        A 1        B 2        C   to this:   foo_id   foo_name 1        A B 2        C
"Started to work" vs "Started working" Will I lose previous purchases when I change country in iTunes I lived in country A for a few years, and made a number of purchases on the iTunes store for that country. I have now moved to country B, and want to start using the iTunes store from country B. If I change the country in my account settings, will I lose all my previous purchases, or will I still be able to re-download my purchases from country A from iCloud? "+-=,;..." math characters in DejaVu Sans (with mathspec) the following MWE  \documentclass{minimal} \usepackage{mathspec} \setmainfont{DejaVu Sans} \setmathsfont(Digits,Latin,Greek){DejaVu Sans} \setmathrm{DejaVu Sans} \begin{document} \(\mathrm{e}^{\mathrm{i}\pi}=-1\) = -1 \end{document}   typesets with xelatex into    How can I turn the = and - signs in math mode to DejaVu Sans ? How to use AT commands in Android by 'root' the phone We have various Android devices from Spike, Samsung, Micromax, etc. How can we issue AT commands from Android to the modem? We searched in Google Play but did not find any app related to this.   suggests:     [F]irst you have to root the phone...`    How can we do this? C: pointer to struct in the struct definition How can I have a pointer to the next struct in the definition of this struct:  typedef struct A {   int a;   int b;   A*  next; } A;   this is how I first wrote it but it does not work. Windows Logs Application is full of "Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: ****]" I have Windows Server 2016, with SQL Server 2017, and found Windows Log Application is full of Login failed messages (as follows) :     Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: ****]    Client's IP addresses are various. I don't have any maintenance plan in SQL Server     What's the problem? What are the reputation requirements for privileges on sites, and how do they differ per site? Formerly Reputation requirements compared. What are the reputation requirements for privileges on the various sites in the network? Also, how do reputation requirements for various privileges compare on different Stack Exchange sites? Specifically, the following types of sites:  Designed sites e.g. Stack Overflow, Ask Ubuntu, Gaming, etc. Public beta and non-designed sites Private beta sites  ...as well as any site-specific differences. Must an ideal contain the kernel for its image to be an ideal? How can I store and retrieve a custom list in a blend file? I am trying to create a script that will allow me to generate a list and store it in the blend file. The list starts out blank and then strings get added to the list, resulting in: [&quot;test1&quot;,&quot;test2&quot;,&quot;test3&quot;] I create a PropertyGroup Class for the enum, define a new scene property as a CollectionProperty type with access to that enum Class, before appending a new item into the enum: import bpy  class item_set(bpy.types.PropertyGroup):     myItems = []     enums = bpy.props.EnumProperty(name=&quot;My Items&quot;, items=myItems) bpy.utils.register_class(item_set)  bpy.types.Scene.myItemSet = bpy.props.CollectionProperty(type=item_set)      newItem = bpy.context.scene.myItemSet.add() newItem.myItems.append(&quot;test&quot;)    I need to be able to add items to the list, save the blend file, re-open the file, run the script again and retrieve the list from the scene. However, the  states:  One thing to keep in mind is that after saving and reloading your blend-file, your new property will have disappeared...    ...To make the values you assigned in a previous session available again, you need to redefine the property. So after reopening the blend-file you need to rerun: bpy.types.Object.myProperty = bpy.props.StringProperty()   I can do the appending into and retrieval of the property values absolutely fine upon an initial run, but as the documentation states, the property is unavailable when trying to view it's contents on a reload of the file (after having run the script, saved and re-opened the file), but I am unsure how to redefine it without clearing all it's values. If I redefined the scene property, it would presumably also need the enum Class to be available, which would currently set myItems back to [] (empty). Do I need to change the way I am initially setting the items in the class or am I on entirely the wrong track with all of this? All I need to do is store a list in the blend file, so if there is a better way please let me know. Thanks. (I would hope, eventually, to be able to store sub lists [[&quot;a&quot;,&quot;b&quot;],[&quot;c&quot;,&quot;d&quot;],[&quot;e&quot;,&quot;f&quot;]], I'm just trying to get normal lists to work first.) How to change the size of desktop icons? I tried gconf-editor as given at  .  I am not getting the option for changing size at app &gt; nautilus &gt; icon_view.  I am using Ubuntu 11.10. Kindly help me in changing default icon size.   I want to make them small. Why is my profile image different? When I first signed up on a Stack Exchange site and got a profile image, it was this one (see my current user card I'm actually not sure what I look like any more):     Later, I got  and SEDE profiles, and my user image there was a different identicon. Because . I would have a picture of it, but that's the problem. ... Thanks to , I have a picture:     On those two sites, it changed from that purple one to this new one recently:   I don't know when the change happened exactly, but I KNOW I didn't change it (I don't know how to change it, otherwise I would have changed it to my main pink one).  Why did this change? Can I get my other icon back or will I be stuck with this new one?   Also, are the gravatars at Area 51 and SEDE securely generated?    After looking in my profile settings, I really confused (I am seeing my wrong avatar in more and more places since I first posted this.):        Seriously.......    What...?    (I'm using this , but be warned that they will try to IP block you after a certain number of requests to force you to pay... May look for a better alternative later.) I have a ListBox DataTemplate in WPF. I want one item to be tight against the left side of the ListBox and another item to be tight against the right side, but I can't figure out how to do this.  So far I have a Grid with three columns, the left and right ones have content and the center is a placeholder with it's width set to "*". Where am I going wrong?  Here is the code:  &lt;DataTemplate x:Key="SmallCustomerListItem"&gt;     &lt;Grid HorizontalAlignment="Stretch"&gt;         &lt;Grid.RowDefinitions&gt;             &lt;RowDefinition/&gt;         &lt;/Grid.RowDefinitions&gt;         &lt;Grid.ColumnDefinitions&gt;             &lt;ColumnDefinition/&gt;             &lt;ColumnDefinition Width="*"/&gt;             &lt;ColumnDefinition/&gt;         &lt;/Grid.ColumnDefinitions&gt;         &lt;WrapPanel HorizontalAlignment="Stretch" Margin="0"&gt;             &lt;!--Some content here--&gt;             &lt;TextBlock Text="{Binding Path=LastName}" TextWrapping="Wrap" FontSize="24"/&gt;             &lt;TextBlock Text=", " TextWrapping="Wrap" FontSize="24"/&gt;             &lt;TextBlock Text="{Binding Path=FirstName}" TextWrapping="Wrap" FontSize="24"/&gt;          &lt;/WrapPanel&gt;         &lt;ListBox ItemsSource="{Binding Path=PhoneNumbers}" Grid.Column="2" d:DesignWidth="100" d:DesignHeight="50"      Margin="8,0" Background="Transparent" BorderBrush="Transparent" IsHitTestVisible="False" HorizontalAlignment="Stretch"/&gt;     &lt;/Grid&gt; &lt;/DataTemplate&gt; Why is gravity stronger than other forces at the macroscopic level, yet weaker than other forces at the quantum level? Is there an explanation? Strange arrow mark with TikZ edge and anchors. When I draw an edge between two nodes with anchors and globally set option [-&gt;], I get an additional arrow tip symbol at the beginning of the last edge in the path. For example in  \documentclass{article} \usepackage{tikz}  \begin{document} \begin{tikzpicture}     \node (A) at (0,0) {$A$};     \node (B) at (1,0) {$B$};      \draw[-&gt;] (A.north east) edge (B.north west);      \draw (A.south east) edge[-&gt;] (B.south west); \end{tikzpicture} \end{document}   the first \draw command produces incorrect output, while the second produces correct output:    Am I doing something wrong, or is this a bug in TikZ? Is it physically possible to build a long zoom (17-300 mm for example) at an aperture value of around 1.4 or 1.2? I'm curious if the physics allow a company to build such a lens of course with good IQ, minimal color aberration, maximum sharpness, and little to none lens vignetting or edge softness How do I find the common ratio of a geometric sequence? A geometric sequence has its first term equal to $12$ and its fourth term equal to $-96$.   How do I find the common ratio? And find the sum of the first $14$ terms Does payment in goods count as "income" for tax purposes? Can someone help me elucidate the definition of "income" from a tax perspective? More specifically, if Joe is paid for his work in avocados instead of dollars, then would Joe be exempt from paying any income tax for the year? Or would the value of avocados earned for the year be translated into dollars which would then be considered Joe's annual income? If so, what guidelines would one use to make this translation? (Make the assumption that Joe does not sell the avocados (for dollars) at a later date and either eats them or trades them for other real property)  What if he was paid in gold instead of avocados? Python rounding error with float numbers Proving $\left(1+\dfrac{1}{1^3}\right)\left(1+\dfrac{1}{2^3}\right)\cdots\left(1+\dfrac{1}{n^3}\right)<3$ for all positive integers $n$ Prove that $\left(1+\dfrac{1}{1^3}\right)\left(1+\dfrac{1}{2^3}\right)\cdots\left(1+\dfrac{1}{n^3}\right)&lt;3$   for all positive integers $n$   This problem is copied from Math Olympiad Treasures by Titu Andreescu and Bogdan Enescu.They start by stating that induction wouldn't directly work here since the right hand side stays constant while the left increases.They get rid of this problem by strengthening the hypothesis.$$\left(1+\dfrac{1}{1^3}\right)\left(1+\dfrac{1}{2^3}\right)\cdots\left(1+\dfrac{1}{n^3}\right)\le3-\dfrac{1}{n}$$ and then proceed by induction.  The problem is that I can't find a motivation for the above change.I mean,we could have subtracted a lot of things from the RHS but what should nudge us to try $\dfrac{1}{n}$?The rest of the proof is quite standard,but I can't see how I am supposed to have thought of it.Is it just experience?Or is it a standard technique?A little guidance and motivation will be appreciated. Do I need a visa for Georgia? I am a Nigerian, holding a valid schengen visa issued by the French embassy, and a multiple entry visa for the United States. Will I be allowed to enter Tbilisi in Georgia?