You can check your current 
server setting with:

```MySQL
SHOW VARIABLES LIKE &#39;max_allowed_packet&#39;;
```

This gives you the answer in bytes. for e.g `max_allowed_packet=1048576` or `1 MiB`

To increase the `max_allowed_packet`, open 
    
`my.ini/my.cnf` under `[mysqld]` section. 
 
Once the change is done you would have to restart the server.

I&#39;m making a URL fetcher in Go and have a list of URLs to fetch. I send `http.Get()` requests to each URL and obtain their response.

    resp,fetch_err := http.Get(url)

How can I set a custom timeout for each Get request? (The default time is very long and that makes my fetcher really slow.) I want my fetcher to have a timeout of around 40-45 seconds after which it should return &quot;request timed out&quot; and move on to the next URL.

How can I achieve this?

How to set timeout for http.Get() requests in Golang?

I want to create an Eclipse style shortcut &lt;kbd&gt;Ctrl&lt;/kbd&gt;+&lt;kbd&gt;MouseClick&lt;/kbd&gt; to open the function/method. Sublime Text 3 has already this function called `goto_definition` but it is bound to &lt;kbd&gt;F12&lt;/kbd&gt;. 

![][1]

But I&#39;m not sure how to create this binding. I looked [here][2] for documentation but it was too complex. Can you one help me out with this simple key binding?

**Edit:** Following this article I was told to do this: [http://webtempest.com/better-definition-navigation-in-sublime-text-3/][3]

    [
        {
            &quot;button&quot;: &quot;button1&quot;, 
            &quot;count&quot;: 1, 
            &quot;modifiers&quot;: [&quot;super&quot;, &quot;shift&quot;],
            &quot;press_command&quot;: &quot;drag_select&quot;,
            &quot;command&quot;: &quot;goto_definition&quot;
        }
    ]

This doesn&#39;t seem to work, &lt;kbd&gt;ctrl&lt;/kbd&gt;+&lt;kbd&gt;shift&lt;/kbd&gt;+&lt;kbd&gt;click&lt;/kbd&gt; executes nothing.


  [1]: http://i.stack.imgur.com/hVNDJ.jpg
  [2]: http://www.sublimetext.com/docs/3/vintage.html
  [3]: http://web.archive.org/web/20130511063525/http://webtempest.com/better-definition-navigation-in-sublime-text-3

Sublime 3 - Set Key map for function Goto Definition

What is maximum query size for mysql? Some times the server stops working when I fire a too long query.


What is maximum query size for mysql?

<p>What is maximum query size for mysql? Some times the server stops working when I fire a too long query.</p>


I have an insert query (active record style) used to insert the form fields into a MySQL table. I want to get the last auto-incremented id for the insert operation as the return value of my query but I have some problems with it.

Inside the controller:

    function add_post(){
		$post_data = array(
			&#39;id&#39;			=&gt; &#39;&#39;,
			&#39;user_id&#39;	=&gt;	&#39;11330&#39;,
			&#39;content&#39;	=&gt;	$this-&gt;input-&gt;post(&#39;poster_textarea&#39;),
			&#39;date_time&#39;	=&gt; date(&quot;Y-m-d H:i:s&quot;),
			&#39;status&#39;		=&gt;	&#39;1&#39;
		);
		return $this-&gt;blog_model-&gt;add_post($post_data);
	}
And inside model:

    function add_post($post_data){
	    $this-&gt;db-&gt;trans_start();
	    $this-&gt;db-&gt;insert(&#39;posts&#39;,$post_data);
	    $this-&gt;db-&gt;trans_complete();
	    return $this-&gt;db-&gt;insert_id();
	}
I get nothing as the return of the add_post in model

how to get last insert id after insert query in codeigniter active record

I&#39;m in the process of moving my files onto another computer, and one thing I would like to do is to transfer the data in my MySQL database. I want to dump the databases into .sql files, but also have the create database db_name including in the file, that way I just have to import the file to mysql without having to manually create the databases. Is there a way to do that?

mysqldump with create database line

I want to run a set of queries to insert some data into an SQL table but only if the record satisfying certain criteria are met. The table has 4 fields: `id` (primary), `fund_id`, `date` and `price`

I have 3 fields in the query: `fund_id`, `date` and `price`.

So my query would go something like this:

    INSERT INTO funds (fund_id, date, price)
        VALUES (23, &#39;2013-02-12&#39;, 22.43)
        WHERE NOT EXISTS (
           SELECT * 
           FROM funds 
           WHERE fund_id = 23
             AND date = &#39;2013-02-12&#39;
        );

So I only want to insert the data if a record matching the `fund_id` and `date` does not already exist. If the above is correct it strikes me as quite an inefficient way of achieving this as an additional select statement must be run each time.

Is there a better way of achieving the above?

Edit: For clarification neither `fund_id` nor `date` are unique fields; records sharing the same fund_id or date will exist but no record should have both the same fund_id and date as another.

SQL Insert into table only if record doesn&#39;t exist

Is it possible to write join query without `ON` statement? and how do these joins differ `LEFT JOIN, RIGHT JOIN` works.

How to use mysql JOIN without ON condition?

I can connect to my local mysql database from python, and I can create, select from, and insert individual rows.

My question is: can I directly instruct mysqldb to take an entire dataframe and insert it into an existing table, or do I need to iterate over the rows? 

In either case, what would the python script look like for a very simple table with ID and two data columns, and a matching dataframe?

How to insert pandas dataframe via mysqldb into database?

I just recently downloaded WAMP Server to view and edit php webpages but now I would also like other people in my network (connected to the same wifi) to be able to access localhost and all the files that I have saved. I have already tried to access localhost and my WAMP server was already online, however that didn&#39;t work. Can someone help me out? Thanks in advance!

How can I access localhost from another computer in the same network?

I&#39;m using WAMP Server 2.2 on a PC. In phpMyAdmin (version 5.5.24) I edited the &#39;root&#39; user (with &#39;localhost&#39; host) and gave it a password of &#39;root&#39;. This turned out to be a big mistake that I&#39;m trying to revert. Now when I go to **localhost/phpmyadmin/** I get the menu of databases on the left, but the main frame has an error that reads:

    #1045 - Access denied for user &#39;root&#39;@&#39;localhost&#39; (using password: NO)
    phpMyAdmin tried to connect to the MySQL server, and the server rejected the 
    connection. You should check the host, username and password in your 
    configuration and make sure that they correspond to the information given 
    by the administrator of the MySQL server.

If I go to **127.0.0.1/phpmyadmin**, I do *not* get the error and everything works fine.

I tried changing the user&#39;s password back to no password; I tried modifying config.inc.php file to add the new password (but that made phpMyAdmin error-out completely); I tried removing and recreating the root/localhost user. Nothing seems to work. The root/localhost user appears to have no password and all privileges, but the error remains.

Any ideas or how I can get this user&#39;s access back to normal without having to reinstall WAMP?

Fix Access denied for user &#39;root&#39;@&#39;localhost&#39; for phpMyAdmin

I am new to symfony2 and reading [symblog][1]. In third chapter while trying with data-fixtures I tried the command: 

`php composer.phar update` 

but I got the error: 

`Could not open input file: composer.phar`

So I googled a little and tried 

    php composer.phar install

but still getting the same error. So please guide how to deal with this composer to install new extentions or bundles like data-fixtures in symfony2 using wamp.

  [1]: http://tutorial.symblog.co.uk/#tutorial-parts

Running Composer returns: &quot;Could not open input file: composer.phar&quot;

I am installing the Wamp Server on another computer to run a mid-sized database and UI. I have been successful in blocking IIS and routing the server to Localhost:8080. But whenever I try to access on of my projects from the localhost homepage, in the www file; I get redirected to a Page not found error. 

When I hover above the links the directory always comes up &quot;http:// ProjectFolderNameHere /&quot;. when it&#39;s supposed to be &quot;http:// LocalHost:8080 / ProjectFolderNameHere /&quot;. What can I do to get the links working properly?

My Machine runs on Windows 7 Home Edition 64-bits, and I already have Microsoft&#39;s IIS disabled.

Project Links do not work on Wamp Server

First of all, I read at least 20 articles about this topic, and not one of them can match up the scenario and I screwed up the process numerous times. So I turn help by offering my specific scenario if any help will be appreciated.

Laptops or other devices are connected through a wireless router.

I&#39;ve tried:

- Enable Port 80 on firewall. nothing happened.
- Run `ping`, `ipconfig` and tried IPv4 address there, denied access or bring me to verizon (my ISP), router config page.
- Tried config Apache, was a mess, never get all the authorization setup in numerous posts and tried one of promising one, which crashed my WAMP, have to went through all the trouble and reinstall.

What I really tried to accomplish is really simply allow all users connect to that wireless router be able to acces my Win8 hosted WAMP sites.

I wonder if there is any specific steps that I can walk through to make it really work?

WAMP 2.4 on Win8.1.
Laptop host local sites.

Content Type	Original Author	Original Content on Stackoverflow
Question	Hemal Kachhadiya	View Question on Stackoverflow
Solution 1 - Mysql	kiriloff	View Answer on Stackoverflow
Solution 2 - Mysql	user2045846	View Answer on Stackoverflow

What is maximum query size for mysql?

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Sublime 3 - Set Key map for function Goto Definition

How to set timeout for http.Get() requests in Golang?

Attributions