I have a SET field which hit the limit of 64 (I was a newbie while I was designing the database few years ago). Now I cannot add more SET values to my department field. I'm thinking to change it into ENUM type. What can I do?
MySQL 5.0.95
Changing SET to ENUM in MySQL?
106 Views Asked by ilhan At
1
There are 1 best solutions below
Related Questions in MYSQL
- MySQL Select Rank
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Push mysql database script to server using git
- Why does mysql stop using indexes when date ranges are added to the query?
- Google Maps API Re-size
- store numpy array in mysql
- Whats wrong with this query? Using ands
- MySQL-Auto increment
- show duplicate values subquery mysql
- Java Web Application Query Is Not Working
- microsoft odbc driver manager data source name not found and no default driver specified
- Setting foreign key in phpMyAdmin
- No responses from google places text search api
- Adding to MAMP database in SQL/PHP
- I want to remove certain parent- and child-divs in all my wordpress posts with php or some other script
Related Questions in DATABASE
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- How to not load all database records in my TListbox in Firemonkey Delphi XE8
- microsoft odbc driver manager data source name not found and no default driver specified
- Cloud Connection with Java Window application
- Automatic background scan if user edit column?
- Jmeter JDBC Connection Configuration Parametrization of Database URL for accessing SQL Database
- How to grant privileges to current user
- MySQL: Insert a new row at a specific primary key, or alternately, bump all subsequent rows down?
- Inserting and returning autoidentity in SQLite3
- Architecture: Multiple Mongo databases+connections vs multiple collections with Express
- SQL - Adding a flag based on results within a query - best practice?
- Android database query not returning any results
- Developing a search and tag heavy website
- Oracle stored procedure wrapping compile error with inline comments
- Problems communicating with mysql in php
Related Questions in ENUMS
- Importing with package name breaking enum comparison in Python
- Http request send child type
- Why can enum arrays be cast to two different IEnumerable<T> types?
- Java use user input to determine enum value
- Is this Java Enumeration Used/Designed Correctly?
- Assigning a random enum value a property
- f.select with enum in rails 3
- Cant bind enum to combobox wpf mvvm
- Entity Framework Search for Enum pulls back all data
- Class which contains an instance of the same class
- How to create enum from a String
- Enum inheritance conflict
- Using enums in an object-orientated way when they apply to many classes
- WPF DataTrigger using enum fails
- Databinding Enum - The name 'StoreLocation' does not exist in the namespace
Related Questions in SET
- Removing duplicates from arraylist using set
- Order-independent Hash Algorithm
- How to count 2 different duplicate values in array - Swift
- CMD specifying columns to save?
- comparison of two sets when repeated in r
- How to use set(data structure) in mongodb console?
- Reversing logic of a product-country mapping
- Storing data in sorted manner in a HashSet
- Generate all combinations of strings and their substrings in a set -- python
- How to access class data in a set of pointers to that class
- Scala set element uniqueness: What to implement for comparison of user defined classes?
- java.util.Set add and remove method signature difference
- retrieve all the smallest strings from a set in python
- Setting a String Variable in SSIS
- Setting a robocopy log file to a variable
Related Questions in MYSQL-5.0
- When i run the below query in MySQL 5.6 it shows 141000 records. but when i run this on MySQL 5.0 it fetches only 91 records
- select everything from a table for a column
- Matching Arrival & Departures from long GPS data (long data to wide data)
- Order by one of the keys of composite primary key
- History field in MySQL database
- Using "TYPE = InnoDB" in MySQL throws exception
- Proper syntax for MySQL 5.0.x FEDERATED table creation?
- What is the best way to store a URL value using MySQL?
- Deadlocks happened when massive inserting executed simultaneously in mysql 5.0
- Python Coding in Blender
- Too much errors with play2.0 + java + mysql5.0
- Changing SET to ENUM in MySQL?
- Upgraded MySql from 5.0 to 5.6 and joomla site will not load
- Is there an alternative to EXTRACTVALUE function in MySql 5.0
- How to package MySQL with the Install4j does Install4j has the facility of creating Installers that can also install MYSQL
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
new column name can be the same as old. values probably should be the same, or at least there should be every old value from set type and some new that you want to add.