If I understand your question, you want to rename the existing enum value `NEWS` to `FEATURED_COVERAGE`. If so, you need to follow below steps,

 1. Alter the table and add the new enum value to the column, so that you will have 3 enums

        ALTER TABLE `content` CHANGE `pagetype` `pagetype`
        ENUM(&#39;FEATURED_COVERAGE&#39;,&#39;PRESS_RELEASE&#39;, &#39;NEWS&#39;) CHARACTER SET utf8
        COLLATE utf8_general_ci NOT NULL;
 2. Set the old enum value to new value for all records.

        UPDATE `content` set `pagetype` = &#39;FEATURED_COVERAGE&#39; where
        `pagetype` = &#39;NEWS&#39;;

 3. Alter the table and drop the old enum value.
    
        ALTER TABLE `content` CHANGE `pagetype` `pagetype`
        ENUM(&#39;FEATURED_COVERAGE&#39;,&#39;PRESS_RELEASE&#39;) CHARACTER SET utf8 COLLATE
        utf8_general_ci NOT NULL;

MySQL&#39;s enum always has a hidden option which is 0 as integer and &#39;&#39; as string. When you try to assign an invalid value it uses the hidden one. 

Assuming all your empty values were &#39;NEWS&#39; before the update you can change them with

    UPDATE content SET pagetype = &#39;FEATURED_COVERAGE&#39; WHERE pagetype = 0

I think default might have helped.

    ALTER TABLE `content`
    CHANGE `pagetype` `pagetype` ENUM(&#39;FEATURED_COVERAGE&#39;,&#39;PRESS_RELEASE&#39;) 
       CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULt &#39;FEATURED_COVERAGE&#39;;


Now you have to blindly to an update 


And never use an enum column if your value set is changing. 

Since you have changed only one enum it will not be difficult for you

Try using this

    UPDATE content SET pagetype = &#39;FEATURED_COVERAGE&#39; WHERE pagetype = 0

I have two concise questions:

 - How I can track files but without staging them ?
 - How I can unstage files for commit without untracking them ?

**NOTE:** *I know that I can do an initial commit to track the files and start from there with my files tracked. But is possible to specifically do what I&#39;m asking above ?*

I tried to use `git add -N &lt;expr&gt;` but it tracks the file and add it for commit:

    PS C:\&gt; git add -N fileA
    PS C:\&gt; git status
    # On branch master
    # Changes to be committed:
    #   (use &quot;git reset HEAD &lt;file&gt;...&quot; to unstage)
    #
    #       new file:   fileA
    #
    # Changes not staged for commit:
    #   (use &quot;git add &lt;file&gt;...&quot; to update what will be committed)
    #   (use &quot;git checkout -- &lt;file&gt;...&quot; to discard changes in working directory)
    #
    #       modified:   README.md
    #       modified:   composer.lock
    #       modified:   fileA
    #

If I do `git reset HEAD fileA` or `git rm --cached fileA` unstages it but also untracks the file.
This command `git rm fileA` suggest me to use the flag -f that removes the file fisically.

So, It is possible to only track but not stage, and to only unstage but not untrack files ?

How to track but not stage and how to unstage but not untrack?

Considering the [following code][1] (and the fact that [`VirtualAlloc()` returns a `void*`][2]):

    BYTE* pbNext = reinterpret_cast&lt;BYTE*&gt;(
        VirtualAlloc(NULL, cbAlloc, MEM_COMMIT, PAGE_READWRITE));

why is `reinterpret_cast` chosen instead of `static_cast`?

I used to think that `reinterpret_cast` is OK for e.g. casting pointers to and from integer types (like e.g. `DWORD_PTR`), but to cast from a `void*` to a `BYTE*`, isn&#39;t `static_cast` OK?

Are there any (subtle?) differences in this particular case, or are they just both valid pointer casts?

Does the C++ standard have a preference for this case, suggesting a way instead of the other?



  [1]: http://blogs.msdn.com/b/oldnewthing/archive/2005/05/19/420038.aspx
  [2]: http://msdn.microsoft.com/en-us/library/windows/desktop/aa366887%28v=vs.85%29.aspx

Proper way of casting pointer types

I have a MySQL table &quot;`content`&quot; which has a column `page_type` of type `ENUM`. The `ENUM` values are `NEWS` &amp; `PRESS_RELEASE`.  I need to replace `NEWS` with `FEATURED_COVERAGE`:

    ALTER TABLE `content` CHANGE `pagetype` `pagetype` ENUM(&#39;FEATURED_COVERAGE&#39;,&#39;PRESS_RELEASE&#39;) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

But now the records in the table, which earlier had page_type `NEWS` are now empty, and there is no way that I can identify which records are `NEWS`, so that I can rename those to `FEATURED_COVERAGE`.

How to resolve such issues?

MySQL Change a column ENUM value

I have a MySQL table "<code>content</code>" which has a column <code>page_type</code> of type <code>ENUM</code>. The <code>ENUM</code> values are <code>NEWS</code> &#x26; <code>PRESS_RELEASE</code>. I need to replace <code>NEWS</code> with <code>FEATURED_COVERAGE</code>:
<pre><code class="hljs language-sql">ALTER TABLE `content` CHANGE `pagetype` `pagetype` ENUM('FEATURED_COVERAGE','PRESS_RELEASE') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
</code></pre>
But now the records in the table, which earlier had page_type <code>NEWS</code> are now empty, and there is no way that I can identify which records are <code>NEWS</code>, so that I can rename those to <code>FEATURED_COVERAGE</code>.
How to resolve such issues?

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

I have a MySQL database and I am trying to find a way to export its structure only, without the auto increment values. `mysqldump --no-data` would almost do the job, but it keeps the auto_increment values. Is there any way to do it without using PHPMyAdmin (that I know it can do it)?

mysqldump - Export structure only without autoincrement

For some reason, I&#39;ve been unable to connect remotely to my MySQL server. I&#39;ve tried everything and I&#39;m still getting errors.

    root@server1:/home/administrator# mysql -u monty -p -h www.ganganadores.cl
    Enter password:
    ERROR 1045 (28000): Access denied for user &#39;monty&#39;@&#39;server1.ganganadores.cl&#39; (using password: YES)

Now, I&#39;ve tried running 

     GRANT ALL ON *.* to monty@localhost IDENTIFIED BY &#39;XXXXX&#39;; 
     GRANT ALL ON *.* to monty@&#39;%&#39; IDENTIFIED BY &#39;XXXXXX&#39;;` 

and still nothing!
What I&#39;m doing wrong?

**EDIT**: `my.cnf` has commented out the bind ip .


Remote Connections Mysql Ubuntu

MyISAM is designed with the idea that your database is queried far more than its updated and as a result it performs very fast read operations. If your read to write(insert|update) ratio is less than 15% its better to use MyISAM.


InnoDB uses row level locking, has commit, rollback, and crash-recovery capabilities to protect user data. It supports transaction and fault tolerance

above differences is correct between MyISAM and InnobDB? **please guide if any other limitations are there for MYISAM and InnobDB. when should i use MyiSAM or when Innodb?** Thank you!

When to use MyISAM and InnoDB?

I am fairly new to MySQL and I am getting a pretty interesting error on which I cannot find any help via google and the stackoverflow search.

I am running a local server of MySQL 5.6.10 on MacOS 10.8.3 and manage my database via Navicat essentials for MySQL.

The error I get is that after running and managing my database just fine for a couple of days/weeks something triggers to (it appears incompletely) delete some of the tables I created using queries from within Navicat.

When I try to run queries using these tables, Navicat then warns me that the particular table does not exist. So far so good - here comes the good part:

When I try to CREATE the table, e.g. named &quot;temp&quot;, that was previously there, I get the following error message:
    
    Error : Tablespace for table &#39;`database`.`temp`&#39; exists. Please DISCARD the tablespace before IMPORT.

However, if I try to drop the table, or try to discard the tablespace for this table, using

    DROP TABLE temp;
    ALTER TABLE temp DISCARD TABLESPACE;

I get the following error messages:

    Error : Unknown table &#39;database.temp&#39;
    Error : Table &#39;database.temp&#39; doesn&#39;t exist

So that means that I am advised to discard the table space but when I try to do so the table does not exist. Is it possible that there is some type of remnant of this table at a different place where the DISCARD query isn&#39;t checking? And does anybody have an idea what could trigger all that - completely randomly as it seems?

As I said, I&#39;m new to the subject and pretty much clueless. I suspect that re-booting my laptop, i.e. resetting my local MySQL server, or maybe user permission rights might have to do with it, but I am just hypothesizing here.

Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT

I was trying to understand how Java enum really works and I have come to the conclusion that it is very similar to a normal Java class that has its constructor declared private.

I have just come to this conclusion and it isn&#39;t based on much thinking, but Id like to know whether I miss anything.

So below is an implementation of a simple Java enum and an equivalent Java class.

    public enum Direction {
        ENUM_UP(0, -1),
        ENUM_DOWN(0, 1),
        ENUM_RIGHT(1, 0),
        ENUM_LEFT(-1, 0);
        

        private int x;
        private int y;
        
        private Direction(int x, int y){
            this.x = x;
            this.y = y;
        }
        public int getEnumX(){
            return x;
        }
        public int getEnumY(){
            return y;
        }
    }

What is the difference in meaning between the code above and below?

    public class Direction{
        public static final Direction UP = new Direction(0, -1) ;
        public static final Direction DOWN = new Direction(0, 1) ;
        public static final Direction LEFT = new Direction(-1, 0) ;
        public static final Direction RIGHT = new Direction(1, 0) ;


        private int x ;
        private int y ;
    
        private Direction(int x, int y){
            this.x = x ;
            this.y = y ;
        }
        public int getX(){
            return x;
        }
        public int getY(){
            return y;
        }
    }

  

What are the differences between a Java enum and a class with private constructor?

Is there an &quot;official&quot; recommendation of how to name Java enums?

    enum Protocol { HTTP, HTTPS, FTP }
or

    enum Protocols { HTTP, HTTPS, FTP }

I know in the .Net world the recommendation is to use singular except for enums that represent bit flags. Just curious if there is something similar in Java.

A related question that seems to be .Net specific: https://stackoverflow.com/questions/1335959/singular-or-plural-for-enumerations

Naming of enums in Java: Singular or Plural?

I&#39;ve got a Category Hibernate model:

    @Entity
    @Table(name = &quot;category&quot;)
    public class Category {
    
        @Id
        @GeneratedValue(strategy=GenerationType.AUTO)
        @Column(name = &quot;id&quot;)
        private long id;
    
        @Column(name = &quot;type&quot;)
        private String type;

which have a type string field. Also I&#39;ve got a Java enum which represent a type of a category:

    public enum CategoryType {
        INCOME, OUTCOME;
    }

which I would like to use instead of the string type. The SQL accepts two distinct values in the varchar parameter: either `CategoryIncome` or `CategoryOutcome`. I would like the Category model class to accept an enum variable - and map it somehow to the string whenever hibernate asks for it.

Is it possible?

Mapping enum to string in hibernate

I would like to fill a list with all possible values of an enum&lt;br&gt;
Since I recently fell in love with `EnumSet`, I leveraged `allOf()`&lt;br&gt;

    EnumSet&lt;Something&gt; all = EnumSet.allOf( Something.class);
    List&lt;Something&gt; list = new ArrayList&lt;&gt;( all.size());
    for (Something s : all) {
    	list.add( s);
    }
    return list;

**Is there a better way** (as in non obfuscated one liner) to achieve the same result?

Filling a List with all enum values in Java

You know in Cocoa there is this thing, for example you can create a `UIView` and do:

    view.autoresizingMask = UIViewAutoresizingFlexibleWidth | UIViewAutoresizingFlexibleHeight;

I have a custom `UIView` with multiple states, which I have defined in an `enum` like this:

    enum DownloadViewStatus {
      FileNotDownloaded,
      FileDownloading,
      FileDownloaded
    };

For each created subview, I set its `tag`: `subview1.tag = FileNotDownloaded;`

Then, I have a custom setter for the view state which does the following:

    for (UIView *subview in self.subviews) {
      if (subview.tag == viewStatus)
        subview.hidden = NO;
      else
        subview.hidden = YES;
    }

But **what I am trying to do**, is to allow this:

    subview1.tag = FileNotDownloaded | FileDownloaded;

So my `subview1` shows up in two states of my view. Currently, it doesn&#39;t show up in any of those two states since the `|` operator seems to add the two enum values. 

Is there a way to do that?

Content Type	Original Author	Original Content on Stackoverflow
Question	Sangram Anand	View Question on Stackoverflow
Solution 1 - Mysql	Abimaran Kugathasan	View Answer on Stackoverflow
Solution 2 - Mysql	Vatev	View Answer on Stackoverflow
Solution 3 - Mysql	georgecj11	View Answer on Stackoverflow
Solution 4 - Mysql	alwaysLearn	View Answer on Stackoverflow

MySQL Change a column ENUM value

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Solution 3 - Mysql

Solution 4 - Mysql

Proper way of casting pointer types

How to track but not stage and how to unstage but not untrack?

Attributions