MySQL

테이블끼리 컬럼을 이동하고 싶을 시

ALTER TABLE TABLENAME

ADD something varchar(255);

이런식으로 옮길 테이블에 컬럼을 추가하여 준 후

ref _ https://stackoverflow.com/questions/6856849/sql-move-column-data-to-other-table-in-same-relation

UPDATE users, account_users SET account_users.something =users.somethingWHERE account_users.user_id=users.user_id;

ALTER TABLE TABLENAME

DROP COLUMN something;

마지막으로 필요없는 컬럼을 삭제해주면 된다.

이런식으로 데이터를 옮길 수 있다.

BLOB data type = https://www.tutorialspoint.com/What-is-BLOB-data-type-in-MySQL

A BLOB is binary large object that can hold a variable amount of data. Followings are some points about BLOB data type −

• • BLOB is the family of column type intended as high-capacity binary storage.

  • The actual BLOB column type is of four types-TINYBLOB, BLOB, MEDIUMBLOB and LONGBLOB.

  • The four BLOB types are very similar to each other; the only difference is the maximum amount of data each can store.