Use `UPDATE IGNORE`:

    update IGNORE bccontacts 
    set mobile_no=&#39;919727048248&#39; 
    where mobile_no=09727048248

More info here: http://dev.mysql.com/doc/refman/5.0/en/update.html

If you have declared the mobile number as the primary key in your table, then you can’t have the same mobile number twice in your table. Have a look at the [MySQL UPDATE documentation](http://dev.mysql.com/doc/refman/5.0/en/update.html).

Inside one of my Angular controllers, I have this:

    // controller A
    $rootScope.$on(&quot;myEventFire&quot;, function(event, reload) {
   		someAction();
    });

In another controller I have this:

    // controller B
    $scope.openList = function(page) {
		$rootScope.$broadcast(&#39;myEventFire&#39;, 1);
  	}

Now, this is a single-page app. When I go to controller A initially and try triggering this event, *someAction()* is going to be executed once. If I navigate away and come back again to controller A and do the same thing, *someAction()* gets executed twice. If I do it again, it happens three times and so on. 
What am I doing wrong here?

AngularJs broadcast repeating execution too many times

I know for linux and Unix machines there is emacs and vi text editor and gcc is built in to compile c code?  what would be the Windows text editor in cmd and are there any compilers built in?


Basic text editor in command prompt?

I created a table that contains a UNIQUE &#39;mobile_no&#39; like

    09727048248
    9727048248
    9824578564
    9898998998

Then I am going to check whether or not the mobile number is valid, and if it&#39;s valid then I want to change it into the proper format like 919727048248.

For that I called update query like..

    update bccontacts 
    set mobile_no=&#39;919727048248&#39; 
    where mobile_no=09727048248

The first time it ran successfully, but the second time it replied

&gt; ERROR 1062 (23000):Duplicate entry &#39;919727048248&#39; for key &#39;mobile_no&#39;

Because there is already a unique key set for the &#39;mobile_no&#39;.

So is there any other query which will `IGNORE DUPLICATE KEY ON UPDATE`?

Update MySQL table and ignore duplicate entries

I created a table that contains a UNIQUE 'mobile_no' like
<pre><code class="hljs">09727048248
9727048248
9824578564
9898998998
</code></pre>
Then I am going to check whether or not the mobile number is valid, and if it's valid then I want to change it into the proper format like 919727048248.
For that I called update query like..
<pre><code class="hljs language-ini">update bccontacts 
set mobile_no='919727048248' 
where mobile_no=09727048248
</code></pre>
The first time it ran successfully, but the second time it replied
> ERROR 1062 (23000):Duplicate entry '919727048248' for key 'mobile_no'
Because there is already a unique key set for the 'mobile_no'.
So is there any other query which will <code>IGNORE DUPLICATE KEY ON UPDATE</code>?

I have a table of users in sql and they each have birth dates. I want to convert their date of birth to their age (years only), e.g. date: `15.03.1999` age: 14 and `15.03.2014` will change to age: `15`

Here I want to show the date of the user:

    if(isset($_GET[&#39;id&#39;]))
    {
        $id = intval($_GET[&#39;id&#39;]);
        $dnn = mysql_fetch_array($dn);
        $dn = mysql_query(&#39;select username, email, skype, avatar, &#39; .
            &#39;date, signup_date, gender from users where id=&quot;&#39;.$id.&#39;&quot;&#39;);
        $dnn = mysql_fetch_array($dn);
        echo &quot;{$dnn[&#39;date&#39;]}&quot;;
    }


Calculate age based on date of birth

I want to convert selected values into a comma separated string in MySQL.

My initial code is as follows:

    SELECT id
    FROM table_level
    WHERE parent_id = 4;

Which produces:
    
    &#39;5&#39;
    &#39;6&#39;
    &#39;9&#39;
    &#39;10&#39;
    &#39;12&#39;
    &#39;14&#39;
    &#39;15&#39;
    &#39;17&#39;
    &#39;18&#39;
    &#39;779&#39;

My desired output would look like this:
    
    &quot;5,6,9,10,12,14,15,17,18,779&quot;


Comma separated string of selected values in MySQL

I am creating for fun, but I still want to approach it seriously, a site which hosts various tests. With these tests I hope to collect statistical data.

Some of the data will include the percentage of the completeness of the tests as they are timed. I can easily compute the percentage of the tests but I would like true data to be returned as I store the various different values concerning the tests on completion.

Most of the values are, in PHP floats, so my question is, if I want true statistical data should I store them in MYSQL as FLOAT, DOUBLE or DECIMAL. 

I would like to utilize MYSQL&#39;S functions such as `AVG()` and `LOG10()` as well as `TRUNCATE()`. For MYSQL to return true data based off of my values that I insert, what should I use as the database column choice.

I ask because some numbers may or may not be floats such as, 10, 10.89, 99.09, or simply 0.
But I would like true and valid statistical data to be returned.

Can I rely on floating point math for this?

**EDIT**

I know this is a generic question, and I apologise extensively, but for non mathematicians like myself, also I am not a MYSQL expert, I would like an opinion of an expert in this field.

I have done my research but I still feel I have a clouded judgement on the matter. Again I apologise if my question is off topic or not suitable for this site.

Storing statistical data, do I need DECIMAL, FLOAT or DOUBLE?

How can I execute any statement in MySQLWorkbench using shortcut? Now I have to press button (yellow lightning). Of course I have read this in the documentation: [Table 14.6 - query menu][1] (Table 14.6 - query menu) but I don&#39;t know what does mean `Modifier+Return` ?

As we can read `Modifier` is `Ctrl` (in Windows) but what is `Return`?


  [1]: https://dev.mysql.com/doc/workbench/en/wb-keys.html#wb-shortcuts-query-menu

Execute statement by shortcut in MySQLWorkbench

I&#39;m getting this error 

`ERROR 2002 (HY000): Can&#39;t connect to local MySQL server through socket &#39;/var/run/mysqld/mysql.sock&#39; (2)
`

even though I have managed to start mysql via command line in ubuntu

    mysql stop/waiting
    mysql start/running, process 17691

However when attempting to access the site I get a database connection error as well as the above error when trying to access mysql via `mysql -u root -p`

I checked my error logs and I saw this

		131029 12:53:34 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be remo$
		131029 12:53:34 [Note] Plugin &#39;FEDERATED&#39; is disabled.
		131029 12:53:34 InnoDB: The InnoDB memory heap is disabled
		131029 12:53:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
		131029 12:53:34 InnoDB: Compressed tables use zlib 1.2.3.4
		131029 12:53:34 InnoDB: Initializing buffer pool, size = 26.0G
		131029 12:53:36 InnoDB: Completed initialization of buffer pool
		131029 12:53:36 InnoDB: highest supported file format is Barracuda.
		131029 12:53:38  InnoDB: Waiting for the background threads to start
		131029 12:53:39 InnoDB: 5.5.34 started; log sequence number 5146431500
		131029 12:53:39 [Note] Server hostname (bind-address): &#39;0.0.0.0&#39;; port: 3306
		131029 12:53:39 [Note]   - &#39;0.0.0.0&#39; resolves to &#39;0.0.0.0&#39;;
		131029 12:53:39 [Note] Server socket created on IP: &#39;0.0.0.0&#39;.
		131029 12:53:39 [Note] Event Scheduler: Loaded 0 events
		131029 12:53:39 [Note] /usr/sbin/mysqld: ready for connections.
		Version: &#39;5.5.34-0ubuntu0.12.04.1-log&#39;  socket: &#39;/var/run/mysqld/mysqld.sock&#39;  port: 3306  (Ubuntu)


It&#39;s the first time I see this error and I&#39;m not sure how to solve this issue, please help me out a bit here.

Thanks



**UPDATE**

Okay I tried glglgl&#39;s solution and after a restart, I get the following in the error log:

		131029 13:17:36 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be remo$
		131029 13:17:36 [Note] Plugin &#39;FEDERATED&#39; is disabled.
		131029 13:17:36 InnoDB: The InnoDB memory heap is disabled
		131029 13:17:36 InnoDB: Mutexes and rw_locks use GCC atomic builtins
		131029 13:17:36 InnoDB: Compressed tables use zlib 1.2.3.4
		131029 13:17:36 InnoDB: Initializing buffer pool, size = 26.0G
		131029 13:17:38 InnoDB: Completed initialization of buffer pool
		131029 13:17:38 InnoDB: highest supported file format is Barracuda.
		131029 13:17:40  InnoDB: Waiting for the background threads to start
		131029 13:17:41 InnoDB: 5.5.34 started; log sequence number 5146431500
		131029 13:17:41 [Note] Server hostname (bind-address): &#39;127.0.0.1&#39;; port: 3306
		131029 13:17:41 [Note]   - &#39;127.0.0.1&#39; resolves to &#39;127.0.0.1&#39;;
		131029 13:17:41 [Note] Server socket created on IP: &#39;127.0.0.1&#39;.  
		131029 13:17:41 [Note] Event Scheduler: Loaded 0 events
		131029 13:17:41 [Note] /usr/sbin/mysqld: ready for connections.
		Version: &#39;5.5.34-0ubuntu0.12.04.1-log&#39;  socket: &#39;/var/run/mysqld/mysqld.sock&#39;  port: 3306  (Ubuntu)

Content Type	Original Author	Original Content on Stackoverflow
Question	Vivek Buddhadev	View Question on Stackoverflow
Solution 1 - Mysql	Zaar Hai	View Answer on Stackoverflow
Solution 2 - Mysql	R R	View Answer on Stackoverflow

Update MySQL table and ignore duplicate entries

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Basic text editor in command prompt?

AngularJs broadcast repeating execution too many times

Attributions