3. fk를 추가할 떄 ALGORITHM=INPLACE가 안된다면!

   MySQL 옵션 중 FOREIGN_KEY_CHECKS를 DISABLE 하는 방법이 있다.

   SET FOREIGN_KEY_CHECKS = 0;
   # ALTER QUERY
   SET FOREIGN_KEY_CHECKS = 1;
   

   혹은 ALTER QUERY에 ALGORITHM=INPLACE 대신 ALGORITHM=COPY를 사용하면 된다.

   read more

   There are comments.

4. UPDATE 시에 SAFE MODE 라며 안될 때

   SET SQL_SAFE_UPDATES = 0;
   UPDATE QUEYR
   SET SQL_SAFE_UPDATES = 1;
   

   read more

   There are comments.

5. SELECT 결과를 버티컬하게 보기

   MariaDB [mysql]> SELECT * FROM user;
   +-----------+------------------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+------------------+---------+--------------+--------------------+
   | Host      | User             | Password                                  | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string | password_expired | is_role | default_role …

   read more

   There are comments.

« Page 3 / 3