Can I change data type from BIGINT to VARCHAR?

Can I change data type from BIGINT to VARCHAR?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Yes.  The basic command is 'ALTER TABLE <table> MODIFY COLUMN <column> <new_data_type>;'.  In your case, the new data type would be 'varchar(0)'.  Note that the number in the varchar doesn't really matter.  

    Like
Like Follow
  • Status Answered
  • 1 yr agoLast active
  • 1Replies
  • 142Views
  • 2 Following