You can modify the `main_menu.xml` file (for me on Ubuntu 12.04 this was in `/usr/share/mysql-workbench/data/`). After you modify it, you&#39;ll need to restart MySQL Workbench.

It&#39;ll look like this

        &lt;value type=&quot;object&quot; struct-name=&quot;app.MenuItem&quot; id=&quot;com.mysql.wb.menu.query.exec&quot;&gt; 
          &lt;link type=&quot;object&quot; key=&quot;owner&quot; struct-name=&quot;app.MenuItem&quot;&gt;com.mysql.wb.menu.query&lt;/link&gt; 
          &lt;value type=&quot;string&quot; key=&quot;caption&quot;&gt;Execute (All or Selection)&lt;/value&gt; 
          &lt;value type=&quot;string&quot; key=&quot;name&quot;&gt;query.execute&lt;/value&gt; 
          &lt;value type=&quot;string&quot; key=&quot;command&quot;&gt;builtin:query.execute&lt;/value&gt; 
          &lt;value type=&quot;string&quot; key=&quot;itemType&quot;&gt;action&lt;/value&gt; 
          &lt;value type=&quot;string&quot; key=&quot;shortcut&quot;&gt;Modifier+E&lt;/value&gt;
        &lt;/value&gt;

The second to last line (Modifier+E) was edited by me. Previously it said &quot;Modifier+Shift+Return&quot;. Note that this is NOT an alias (you cannot have both).

How can I retrieve the word `my` from between the two rounded brackets in the following sentence using a regex in JavaScript?

&gt; &quot;This is (my) simple text&quot;

Get text between two rounded brackets

I saw this interesting question at a comment on [cyberciti.biz](http://www.cyberciti.biz/faq/how-to-redirect-output-and-errors-to-devnull/).

That I found I even can&#39;t find a flexible way to do this in one-line command with sh.

As far my thought for the solution is:

    tmp_file=`mktemp`
    (./script 2&gt;$tmp_file &gt;/dev/null; cat $tmp_file) | ./other-script
    rm tmp_file

But you see, this is not synchronous, and fatally, it&#39;s so ugly.


Welcome to share you mind about this. :)


Shell: redirect stdout to /dev/null and stderr to stdout

Having spent a number of years working primarily with MS SQL Server (and hence SQL Server Management Studio for common tasks), I am now beginning to work with MySql. To date I have been using &lt;em&gt;MySQL Workbench&lt;/em&gt; and am generally happy with it.

I would, however, like to be able to assign &lt;strong&gt;custom keyboard shortcuts&lt;/strong&gt; for certain commands (e.g. commands from &lt;a href=&quot;http://dev.mysql.com/doc/workbench/en/wb-keys.html&quot;&gt;this list&lt;/a&gt;). For example, I&#39;d prefer to stick to the MS-SQL approach of &#39;F5&#39; to execute queries, rather than hitting &#39;Modifier+Return&#39;. I haven&#39;t yet come across a simple way to do this. My questions are then:
&lt;ul&gt;
&lt;li&gt;Is this possible somehow in MySQL Workbench (e.g. additional plugin)?&lt;/li&gt;
&lt;li&gt;If not, do any of the alternatives to MySQL Workbench offer this functionality?&lt;/li&gt;
&lt;/ul&gt;

Environment:
&lt;ul&gt;
&lt;li&gt;Ubuntu 12.04 LTS, 32 bit&lt;/li&gt;
&lt;li&gt;MySQL server version 5.5.24-0ubuntu0.12.04.1&lt;/li&gt;
&lt;li&gt;MySQL Workbench Version 5.2.38, rev 8753&lt;/li&gt;
&lt;/ul&gt;

Cheers!

Customizing Keyboard Shortcuts in MySql Workbench

Having spent a number of years working primarily with MS SQL Server (and hence SQL Server Management Studio for common tasks), I am now beginning to work with MySql. To date I have been using MySQL Workbench and am generally happy with it.
I would, however, like to be able to assign custom keyboard shortcuts for certain commands (e.g. commands from <a href="<a href=" http:="" dev.mysql.com="" doc="" workbench="" en="" wb-keys.html&#x26;quot;&#x26;gt;this&#x22;="">http://dev.mysql.com/doc/workbench/en/wb-keys.html">this</a> list). For example, I'd prefer to stick to the MS-SQL approach of 'F5' to execute queries, rather than hitting 'Modifier+Return'. I haven't yet come across a simple way to do this. My questions are then:
<ul>
<li>Is this possible somehow in MySQL Workbench (e.g. additional plugin)?</li>
<li>If not, do any of the alternatives to MySQL Workbench offer this functionality?</li>
</ul>
Environment:
<ul>
<li>Ubuntu 12.04 LTS, 32 bit</li>
<li>MySQL server version 5.5.24-0ubuntu0.12.04.1</li>
<li>MySQL Workbench Version 5.2.38, rev 8753</li>
</ul>
Cheers!

Any help on this problem will be greatly appreciated.

So basically I want to run a query to my SQL database and store the returned data as Pandas data structure.

I have attached code for query.

I am reading the documentation on Pandas, but I have problem to identify the return type of my query.

I tried to print the query result, but it doesn&#39;t give any useful information.

Thanks!!!! 

```python
from sqlalchemy import create_engine

engine2 = create_engine(&#39;mysql://THE DATABASE I AM ACCESSING&#39;)
connection2 = engine2.connect()
dataid = 1022
resoverall = connection2.execute(&quot;
    SELECT 
       sum(BLABLA) AS BLA,
       sum(BLABLABLA2) AS BLABLABLA2,
       sum(SOME_INT) AS SOME_INT,
       sum(SOME_INT2) AS SOME_INT2,
       100*sum(SOME_INT2)/sum(SOME_INT) AS ctr,
       sum(SOME_INT2)/sum(SOME_INT) AS cpc
    FROM daily_report_cooked
    WHERE campaign_id = &#39;%s&#39;&quot;,
    %dataid
)
```

So I sort of want to understand what&#39;s the format/datatype of my variable &quot;resoverall&quot; and how to put it with PANDAS data structure.

How to convert SQL Query result to PANDAS Data Structure?

Hey all i am trying to figure out how to go about inserting a new record using the following query:

    SELECT user.id, user.name, user.username, user.email, 
      IF(user.opted_in = 0, &#39;NO&#39;, &#39;YES&#39;) AS optedIn  
    FROM 
      user
      LEFT JOIN user_permission AS userPerm ON user.id = userPerm.user_id
    ORDER BY user.id;

My `INSERT` query so far is this:

    INSERT INTO user 
    SELECT * 
    FROM user 
      LEFT JOIN user_permission AS userPerm ON user.id = userPerm.user_id;

However, i  am not sure how to do `VALUE(&#39;&#39;,&#39;&#39;,&#39;&#39;,&#39;&#39;, etc etc)` when using left and inner joins.

So what i am looking to do is this:

`User` table:

    id    | name       | username    | password                 | OptIn
    --------------------------------------------------------------------
    562     Bob Barker   bBarker       BBarker@priceisright.com   1

And also the `user_permission` table

    user_id   | Permission_id
    -------------------------
    562         4

**UPDATE**
So like this?

    INSERT INTO user (name, username, password, email, opted_in) VALUES (&#39;Bbarker&#39;,&#39;Bbarker&#39;,&#39;blahblahblah&#39;,&#39;Bbarker@priceisright.com&#39;,0);
    INSERT INTO user_permission (user_id, permission_id) VALUES (LAST_INSERT_ID(),4);

Insert using LEFT JOIN and INNER JOIN

I&#39;m trying to understand how [`Flask-Login`][1] works.

I see in their documentation that they use a pre-populated list of users. I want to play with a database-stored users list.

However, I don&#39;t understand some things in this [`Flask-Login`][1] module.

&lt;!-- language: lang-py --&gt;

    @login_manager.user_loader
    def load_user(userid):
        #print &#39;this is executed&#39;,userid
        return user(userid, &#39;asdf&#39;)

This code will be called at every request? This is used to load all the details of my user object?

For now, I have this code:

&lt;!-- language: lang-py --&gt;

    @app.route(&#39;/make-login&#39;)
    def make_login():
        username = &#39;asdf&#39;
        password = &#39;asdf&#39;
        user_data = authenticate(username, password)
        user_obj = user(user_data[0], user_data[1])
        login_user(user_obj)
        return render_template(&#39;make-login.html&#39;)

When I access /make-login, I want to log in.

My user class:

&lt;!-- language: lang-py --&gt;

    class user(object):
        def __init__(self, id, username, active=True):
            self.username = username
            self.id = id
            #self.active = active
        def is_authenticated(self):
            return True  
                
        def is_active(self):
            return True
        
        def is_anonymous(self):
            return False
        
        def get_id(self):
            return 5

Also, I wrote another two functions for authenticate/register

&lt;!-- language: lang-py --&gt;

    def authenticate(username, password):
        
        cursor = db.cursor()
        password = md5.md5(password).hexdigest()
        try:
            query = &quot;SELECT * FROM `users` WHERE `username` = %s AND `password` = %s&quot;
            cursor.execute(query, (username, password))
            results = cursor.fetchall()
            #print results[0][0]
            #print &quot;here i am&quot;
            if not results:
                return False
            else:
                user_data = [results[0][0], results[0][1]]
                return user_data
                #self.authenticated = True
                #self.user_id = results[0][0]
                #session[&#39;username&#39;]  = results[&#39;username&#39;]
                #print type(results)
        except db.Error, e:
            return &#39;There was a mysql error&#39;    
    
    def register(username, password, email, *args):
        cursor = db.cursor()
        password = md5.md5(password).hexdigest()
        try:
            #query = &quot;INSERT INTO `users` (`username`, `password`, `email`) VALUES (&#39;%s&#39;, &#39;%s&#39;, &#39;%s&#39;)&quot; % (username, password, email)
            query = &quot;INSERT INTO `users` (`username`, `password`, `email`) VALUES (%s, %s, %s)&quot;
            cursor.execute(query, (username, password, email))
            db.commit()
            return True
        except db.Error, e:
            print &#39;An error has been passed. %s&#39; %e
            db.rollback()
            return False


I don&#39;t know how to make this [`Flask-Login`][1] work with MySQL. Also, I don&#39;t know if the user are logged-in. How can I get the user ID or the username?

Anyone can explain me in some rows how this [`Flask-Login`][1] works?


  [1]: https://flask-login.readthedocs.org/en/latest/

flask-login: can&#39;t understand how it works

What is the easiest way to select data from two tables and rather than join them, have them appear as separate rows. Both tables have similar or matching fields and I want to run some aggregate function on them such as avg all the rows that occurred in the same month, from both tables.

for example I have two tables, one that is shows transactions from one system and another with transactions from a different system. Is there a way to grab all the transactions from both tables as separate rows? if table 1 had twenty records and table 2 have thirty records, I&#39;d like there to be 50 rows on the return.

Select from multiple tables without a join?

How do you get the rows that contain the max value for each grouped set? 

I&#39;ve seen some overly-complicated variations on this question, and none with a good answer. I&#39;ve tried to put together the simplest possible example:

Given a table like that below, with person, group, and age columns, how would you get the oldest person in each group? (A tie within a group should give the first alphabetical result)


    Person | Group | Age
    ---
    Bob  | 1     | 32  
    Jill | 1     | 34  
    Shawn| 1     | 42  
    Jake | 2     | 29  
    Paul | 2     | 36  
    Laura| 2     | 39  

Desired result set:  

    Shawn | 1     | 42    
    Laura | 2     | 39  

Get records with max value for each group of grouped SQL results

Recently, I switched from [Visual Studio][1] to [Eclipse][2]. Now I am missing the shortcut for navigating to the last cursor position in Eclipse. In Visual Studio, the same can be done with the help of the &lt;kbd&gt;Ctrl&lt;/kbd&gt; + &lt;kbd&gt;-&lt;/kbd&gt; shortcut. 

How do I do this in Eclipse?

  [1]: http://en.wikipedia.org/wiki/Microsoft_Visual_Studio
  [2]: http://en.wikipedia.org/wiki/Eclipse_%28software%29


How to navigate to the last cursor position in Eclipse?

Is there a keyboard shortcut to select all the line your cursor is currently on? In Eclipse? Or even in general on Windows/Linux?

A shortcut to select a line in Eclipse?

I had a look at: [Eclipse-Shortcuts][1], but I found nothing for generating a constructor. 

Whats the shortcut for generating a standard constructor?




  [1]: https://docs.google.com/viewer?a=v&amp;q=cache:ONIuWQuH0d0J:eclipse-tools.sourceforge.net/Keyboard_shortcuts_%283.0%29.pdf%20&amp;hl=de&amp;gl=at&amp;pid=bl&amp;srcid=ADGEESiJV5Ksth5keyMfZN72Ww-q1vo728GvYYqXRA5RBS88qV_3y922qUrIKnmvOmRLcr2kkSXgcdFTo5F0xhpe9R39QuRLwDoPXDcHBGhb-T1-_NCgfbujHWiUIoxTosyXyZCGeMvj&amp;sig=AHIEtbR2POLLbNTjEJnxR7oS5S_mL7m-Qw

What is the eclipse shortcut for auto-generating a default and field constructor?

I like to use my mouse as little as possible for health reasons. Almost all the common tasks in IntelliJ I can do via keyboard shortcuts, except for displaying the message of an error. How can I have a keyboard shortcut that will show the tooltip of the highlighted error?

For example, I have an error such as:

![enter image description here][1]

Then I hit [magic-keyboard-command] and I get:

![enter image description here][2]


In Eclipse this is possible by pressing F2. Is there an equivalent in IntelliJ?

  [1]: http://i.stack.imgur.com/DtPGU.png
  [2]: http://i.stack.imgur.com/J71JN.png

Keyboard shortcut to display error in IntelliJ

Is there a way to close all tabs in one go in Sublime Text, but leave the window with the current project open? It is really annoying when I just want to close all open file and start the new task I have to `Cmd-W` them one by one. If I do `Cmd-Opt-W` it will close all tabs and the current project.

Close all tabs, but not the window, in Sublime Text

I know how to remove/change `UISearchBar` background color around search field:

    [[self.searchBar.subviews objectAtIndex:0] removeFromSuperview];
    self.searchBar.backgroundColor = [UIColor grayColor];

![achieved UISearchBar customization][2]

But don&#39;t know how to do this inside it like that:

![desired UISearchBar customization][1]


  [1]: http://i.stack.imgur.com/mQbUj.png
  [2]: http://i.stack.imgur.com/TlLAH.png

This needs to be compatible with iOS 4.3+.



How to change inside background color of UISearchBar component on iOS

I am developing a REST interface for my app using Jackson to serialize my POJO domain objects to JSON representation. I want to customize the serialization for some types to add additional properties to the JSON representation that do not exist in POJOs (e.g. add some metadata, reference data, etc). I know how to write my own `JsonSerializer`, but in that case I would need to explicitly call `JsonGenerator.writeXXX(..)` methods for __each__ property of my object while all I need is just to __add__ an additional property. In other words I would like to be able to write something like:

    @Override
    public void serialize(TaxonomyNode value, JsonGenerator jgen, SerializerProvider provider) {
        jgen.writeStartObject();
        jgen.writeAllFields(value); // &lt;-- The method I&#39;d like to have
        jgen.writeObjectField(&quot;my_extra_field&quot;, &quot;some data&quot;);
        jgen.writeEndObject();
    }

or (even better) to somehow intercept the serialization before the `jgen.writeEndObject()` call, e.g.:

    @Override void beforeEndObject(....) {
        jgen.writeObjectField(&quot;my_extra_field&quot;, &quot;some data&quot;);
    }

I thought I could extend `BeanSerializer` and override its `serialize(..)` method but it&#39;s declared `final` and also I couldn&#39;t find an easy way to create a new instance of `BeanSerializer` without providing it with all the type metadata details practically duplicating a good portion of Jackson. So I&#39;ve given up on doing that.

__My question is__ - how to customize Jackson&#39;s serialization to add additional stuff to the JSON output for particular POJOs without introducing too much of the boilerplate code and reusing as much as possible of the default Jackson behaviour.

Jackson: How to add custom property to the JSON without modifying the POJO

I strain to read the tabs in the source code editor of Visual Studio 2012. 
I don&#39;t even understand what the different colors mean? They seem totally random. Black on brown or black on blue.... who choose that?  

![enter image description here][1]

So I would like to turn off the colouring for the tabs and revert to black on white, or a light grey.

I&#39;ve looked in:

&gt; Options&gt;&gt; Environment (General / Font and Colors)

but I cant see anything relevant. So how can I do this please?


  [1]: http://i.stack.imgur.com/iXHMt.png

VS2012 How to turn off editor tab colouring?

I have been investigating for the whole day as I considered it would be worthwhile spending some time to learn best practice for customizing [Bootstrap](http://twitter.github.io/bootstrap/).


I can see that there is a friendly page available for customizing elements selectively from http://twitter.github.io/bootstrap/customize.html but I want to have more control than this without touching original bootstrap source files.


To start with, I basically wanted to test out changing the grid from 12 to 16 columns and to do this, I created my own variable less file and added @gridColumns:16; only to this file and imported this custom less inside bootstrap.less as follows. 


    // Core variables and mixins
    @import &quot;variables.less&quot;; // Modify this for custom colors, font-sizes, etc
    @import &quot;mixins.less&quot;;
    **@import &quot;../custom-variables.less&quot;; //Override variables**



Then, using [WinLess](http://winless.org/) I compiled the bootstrap.less file to get new bootstrap.css with overridden variable import call and linked the css with html file but the grid won&#39;t change to 16 columns.


Can anyone please point out what I am doing wrong?


Bootstrap variable overriding with LESS

I&#39;ve been trying to customize the toggle button look but with no success.
Here is how I want it to look like:

![enter image description here][1]


  [1]: http://i.stack.imgur.com/0k0xG.png

Can someone give me a tutorial? 

Android toggle button custom look

I am trying to export the DataBase i have at MySQL Workbench but I am having troubles to generate the INSERT statements on the .sql file.

I order to export the data, I do the reverse engineering for the database i want to export. Then, i go to 
&gt;File / Export/ Forward Engineer SQL CREATE Script

And once in there, i select the option **Generate INSERT Statements for Tables**.

The result only generates the code for the create tables.

Is there any way to create the insert statements for the data?

Thanks


Export DataBase with MySQL Workbench with INSERT statements

I&#39;m having a lubuntu-64bit and installed  MySQL-workbench to open the EER model. but it just doesn&#39;t open up.. 

It shows error 

    Error unserializing GRT data
    error unserializing object (invalid struct)

The same EER file opens fine in windows.. I&#39;m new to this I need to create Database using these on this machine please help.. 




mysql workbench error opening EER

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source.

How can I do that?

MySQL: How to allow remote connection to mysql

When I try to export my database through MySQL Workbench remotely from localserver,

I am getting some below version error:

&gt;mysqldump Version Mismatch  [Content] mysqldump.exe is version 5.5.16, but the MySQL Server to be dumped has version 5.6.10-log. Because the version of mysqldump is older than the server, some features may not be backed up properly. It is recommended you upgrade your local MySQL client programs, including mysqldump to a version equal to or newer than that of the target server. The path to the dump tool must then be set in Preferences -&gt; Administrator -&gt; Path to mysqldump Tool

I am trying to find a solution - I searched for solution on google but couldn&#39;t find a good answer to solve the issue.

Does anyone know, how to fix this issue in MySQL Workbench?

mysqlworkbench giving version error on exporting database

**Error Code: 2013. Lost connection to MySQL server during query**

I am using MySQL Workbench. Also, I am running a batch of inserts, about 1000 lines total (Ex. `INSERT INTO mytable SELECT * FROM mysource1; INSERT INTO mytable SELECT * FROM mysource2;...mysource3...mysource4` multiplied 1000 times) Each batch takes a considerable amount of time, some of them, more than 600 seconds.

**How can I configure workbench, to continue working overnight, without stopping and without losing the connection?**

Content Type	Original Author	Original Content on Stackoverflow
Question	sammy34	View Question on Stackoverflow
Solution 1 - Mysql	Tyler Collier	View Answer on Stackoverflow

Customizing Keyboard Shortcuts in MySql Workbench

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Shell: redirect stdout to /dev/null and stderr to stdout

Get text between two rounded brackets

Attributions