How do I change the data type for a column in MySQL?

http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

ALTER TABLE tablename MODIFY columnname INTEGER;

This will change the datatype of given column

Depending on how many columns you wish to modify it might be best to generate a script, or use some kind of mysql client GUI

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. How to use mysqli_query() in PHP?
  3. Access denied for user ‘root@localhost’ (using password:NO)
  4. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  5. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  6. How do I quickly rename a MySQL database (change schema name)?
  7. What does SQL Select symbol || mean?
  8. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  9. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  10. MySQL DROP all tables, ignoring foreign keys
  11. Setting up foreign keys in phpMyAdmin?
  12. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  13. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  14. mysql is not recognised as an internal or external command,operable program or batch
  15. MySQL error code: 1175 during UPDATE in MySQL Workbench
  16. Search for all occurrences of a string in a mysql database
  17. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  18. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  19. Data truncated for column?
  20. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  21. How to update a record using sequelize for node?
  22. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  23. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  24. Convert MySQL to SQlite [closed]
  25. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  26. Convert partially non-numeric text into number in MySQL query
  27. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  28. MySQL: What’s the difference between float and double?
  29. How can I search (case-insensitive) in a column using LIKE wildcard?
  30. MySQL Select Multiple VALUES
  31. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  32. How to unblock with mysqladmin flush hosts
  33. Node.js MySQL – Error: connect ECONNREFUSED
  34. Solution to “subquery returns more than 1 row” error
  35. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  36. How To have Dynamic SQL in MySQL Stored Procedure
  37. MySQL – UPDATE query with LIMIT
  38. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  39. What SQL Query to do a simple find and replace
  40. Scanning Database for malicious Data
  41. how to refresh wordpress permalink settings? (without admin panel)
  42. Ordering posts by day (not time) AND meta value
  43. wpdb->prepare function remove single quote for %s in SQL statment
  44. Problems with DBDelta with FOREIGN key?
  45. Is it useful to turn on MySQL query cache for performance
  46. Programmatically changing role information; editing role name and deleting
  47. Search and replace in post content
  48. How to add 2 hours to the wordpress time formed with current_time(“mysql”, false)?
  49. wpdb insert and boolean fields
  50. What are the issues associated with upgrading MySQL for WordPress?
  51. How to find meta entries with their posts missing via SQL?
  52. Mysql SELECT posts
  53. #1115 – Unknown character set: ‘utf8mb4’
  54. How to add a private user page populated from sql?
  55. Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
  56. Code to remove authors with no posts connected to them
  57. Which is better and faster ? WordPress Queries or SQL Query
  58. SQL Query in WordPress – Getting Impossible WHERE error
  59. WordPress create database not working
  60. Using WPDB->Insert()
  61. Active DB queries in WordPress?
  62. Changing MySQL password via WHM – does this affect WordPress?
  63. database optimization and server errors
  64. Run Username SQL Query from WordPress Child Theme Functions File
  65. SQL syntax error. However, it works normally at phpmyadmin
  66. string literals in query
  67. MySQL query for taxonomy-meta
  68. Editing mysql tables/database with wordpress or other app/cms
  69. Create pages from MySQL database
  70. Sql – Search with serialized Data / better database concept
  71. WordPress unescape text on mysql?
  72. Getting data from Mysql Table..confusing
  73. Exporting completed webiste for another server
  74. SQL Statement – Mass Delete Custom Post Types
  75. Ubuntu 12.04, Nginx and MySQL issue with WordPress Database
  76. querying user bookmarks from a large number of bookmarks
  77. latency problems with wordpress install (from SQL import)
  78. mysql – Delete keyword with link from wordpress post database
  79. Creating dynamic content and pages for 1000’s of locations
  80. Remove duplicate media entries from mysql database
  81. mysqli_sql_exception: Unknown column ‘wp_’ in ‘field list’ PHP 8
  82. In a MySQL query, one of the columns in the LEFT JOIN returns “Unknown column”
  83. DB option update with wp-cli
  84. How to simulate web traffic to test performance of a website
  85. Find locations of all featured images of draft posts via SQL
  86. wpdb insert into point column in db
  87. SQL. Select category descendants
  88. 403 Forbidden home on localhost with nginx server
  89. WPDB delivers wrong results from complex queries
  90. Why is local wordpress install calling live site executions?
  91. How to change link in all posts?
  92. Migration of wordpress database from mariadb 10.0.20 to 5.5.50
  93. #1115 – Unknown character set: ‘utf8mb4’
  94. Get data from 3rd table
  95. Internal error (500) on local & Fatal error on live when trying to access post type edit screen
  96. Why can’t I connect to imported WP DB on local MAMP?
  97. Where other than wp-config can database access details be defined?
  98. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  99. How can I show user’s privileges in MySQL?
  100. Changing host permissions for MySQL users

Leave a Comment