--sql-mode은 MySQL의 SQL 모드 설정을 위한 옵션입니다.
SQL 모드는 MySQL이 SQL 문법을 처리하는 방식에 영향을 미칩니다.
--sql-mode을 사용하면 MySQL이 SQL 문법을 더 엄격하게 처리하도록 할 수 있습니다.
--sql-mode의 주요 옵션으로는 strict_mode, no_auto_value_on_zero, no_engine_substitution, no_zero_date, no_zero_in_date, pad_char_to_full_length, sql_big_selects, sql_big_results, sql_low_priority_updates, sql_mode, sql_notes, sql_quote_show_create, sql_select_limit, sql_warnings, lock_wait_timeout, unique_checks, only_full_group_by, pipe, lock_tables, named_pipe, named_pipe_full_access_group, net_buffer_length, net_read_timeout, net_retry_count, net_write_timeout, query_prealloc_size, query_alloc_block_size, max_allowed_packet, max_connect_errors, max_connections, max_delayed_threads, max_error_count, max_heap_table_size, max_insert_delayed_threads, max_join_size, max_sort_length, max_rows, max_update_delayed_threads, max_user_connections, max_value_length, max_write_lock_count, myisam_sort_buffer_size, net_buffer_length, net_read_timeout, net_retry_count, net_write_timeout, query_prealloc_size, query_alloc_block_size, read_buffer_size, read_rnd_buffer_size, sort_buffer_size, table_definition_cache, table_open_cache, thread_stack, tmp_table_size, tmpdir, wait_timeout, innodb_adaptive_flushing_lwm, innodb_adaptive_flushing_target, innodb_adaptive_hash_index, innodb_adaptive_max_sleep_delay, innodb_additional_mem_pool_size, innodb_autoextend_increment, innodb_autoinc_lock_mode, innodb_buffer_pool_instances, innodb_buffer_pool_size, innodb_change_buffer_max_size, innodb_change_buffering, innodb_checksums, innodb_commit_concurrency, innodb_concurrency_tickets, innodb_data_file_path, innodb_data_path, innodb_disable_sort_file_cache, innodb_doublewrite, innodb_doublewrite_buffer_size, innodb_fast_shutdown, innodb_file_format, innodb_file_format_check, innodb_file_format_max, innodb_file_per_table, innodb_flush_log_at_trx_commit, innodb_flush_method, innodb_force_load_corrupted, innodb_force_recovery, innodb_io_capacity, innodb_io_capacity_max, innodb_large_prefix, innodb_lock_wait_timeout, innodb_locks_unsafe_for_binlog, innodb_log_buffer_size, innodb_log_file_size, innodb_log_files_in_group, innodb_log_group_home_dir, innodb_max_dirty_pages_pct, innodb_max_dirty_pages_pct_lwm, innodb_max_purge_lag, innodb_max_purge_lag_delay, innodb_mirrored_log_groups, innodb_old_blocks_time, innodb_rollback_on_timeout, innodb_sort_buffer_size, innodb_stats_method, innodb_status_output, innodb_status_output_locks, innodb_support_xa, innodb_sync_spin_loops, innodb_table_locks, innodb_thread_concurrency, innodb_thread_sleep_delay, innodb_use_native_aio, innodb_use_sys_malloc, innodb_version, innodb_write_io_threads, innodb_read_io_threads, innodb_buffer_pool_dump_at_shutdown, innodb_buffer_pool_dump_now, innodb_buffer_pool_dump_pct, innodb_buffer_pool_instances, innodb_buffer_pool_size, innodb_change_buffer_max_size, innodb_change_buffering, innodb_checksums, innodb_commit_concurrency, innodb_concurrency_tickets, innodb_data_file_path, innodb_data_path, innodb_disable_sort_file_cache, innodb_doublewrite, innodb_doublewrite_buffer_size, innodb_fast_shutdown, innodb_file_format, innodb_file_format_check, innodb_file_format_max, innodb_file_per_table, innodb_flush_log_at_trx_commit, innodb_flush_method, innodb_force_load_corrupted, innodb_force_recovery, innodb_io_capacity, innodb_io_capacity_max, innodb_large_prefix, innodb_lock_wait_timeout, innodb_locks_unsafe_for_binlog, innodb_log_buffer_size, innodb_log_file_size, innodb_log_files_in_group, innodb_log_group_home_dir, innodb_max_dirty_pages_pct, innodb_max_dirty_pages_pct_lwm, innodb_max_purge_lag, innodb_max_purge_lag_delay, innodb_mirrored_log_groups, innodb_old_blocks_time, innodb_rollback_on_timeout, innodb_sort_buffer_size, innodb_stats_method, innodb_status_output, innodb_status_output_locks, innodb_support_xa, innodb_sync_spin_loops, innodb_table_locks, innodb_thread_concurrency, innodb_thread_sleep_delay, innodb_use_native_aio, innodb_use_sys_malloc, innodb_version, innodb_write_io_threads, innodb_read_io_threads, innodb_buffer_pool_dump_at_shutdown, innodb_buffer_pool_dump_now, innodb_buffer_pool_dump_pct, innodb_buffer_pool_instances, innodb_buffer_pool_size, innodb_change_buffer_max_size, innodb_change_buffering, innodb_checksums, innodb_commit_concurrency, innodb_concurrency_tickets, innodb_data_file_path, innodb_data_path, innodb_disable_sort_file_cache, innodb_doublewrite, innodb_doublewrite_buffer_size, innodb_fast_shutdown, innodb_file_format, innodb_file_format_check, innodb_file_format_max, innodb_file_per_table, innodb_flush_log_at_trx_commit, innodb_flush_method, innodb_force_load_corrupted, innodb_force_recovery, innodb_io_capacity, innodb_io_capacity_max, innodb_large_prefix, innodb_lock_wait_timeout, innodb_locks_unsafe_for_binlog, innodb_log_buffer_size, innodb_log_file_size, innodb_log_files_in_group, innodb_log_group_home_dir, innodb_max_dirty_pages_pct, innodb_max_dirty_pages_pct_lwm, innodb_max_purge_lag, innodb_max_purge_lag_delay, innodb_mirrored_log_groups, innodb_old_blocks_time, innodb_rollback_on_timeout, innodb_sort_buffer_size, innodb_stats_method, innodb_status_output, innodb_status_output_locks, innodb_support_xa, innodb_sync_spin_loops, innodb_table_locks, innodb_thread_concurrency, innodb_thread_sleep_delay, innodb_use_native_aio, innodb_use_sys_malloc, innodb_version, innodb_write_io_threads, innodb_read_io_threads, innodb_buffer_pool_dump_at_shutdown, innodb_buffer_pool_dump_now, innodb_buffer_pool_dump_pct, innodb_buffer_pool_instances, innodb_buffer_pool_size, innodb_change_buffer_max_size, innodb_change_buffering, innodb_checksums, innodb_commit_concurrency, innodb_concurrency_tickets, innodb_data_file_path, innodb_data_path, innodb_disable_sort_file_cache, innodb_doublewrite, innodb_doublewrite_buffer_size, innodb_fast_shutdown, innodb_file_format, innodb_file_format_check, innodb_file_format_max, innodb_file_per_table, innodb_flush_log_at_trx_commit, innodb_flush_method, innodb_force_load_corrupted, innodb_force_recovery, innodb_io_capacity, innodb_io_capacity_max, innodb_large_prefix, innodb_lock_wait_timeout, innodb_locks_unsafe_for_binlog, innodb_log_buffer_size, innodb_log_file_size, innodb_log_files_in_group, innodb_log_group_home_dir, innodb_max_dirty_pages_pct, innodb_max_dirty_pages_pct_lwm, innodb_max_purge_lag, innodb_max_purge_lag_delay, innodb_mirrored_log_groups, innodb_old_blocks_time, innodb_rollback_on_timeout, innodb_sort_buffer_size, innodb_stats_method, innodb_status_output, innodb_status_output_locks, innodb_support_xa, innodb_sync_spin_loops, innodb_table_locks, innodb_thread_concurrency, innodb_thread_sleep_delay, innodb_use_native_aio, innodb_use_sys_malloc, innodb_version, innodb_write_io_threads, innodb_read_io_threads, innodb_buffer_pool_dump_at_shutdown, innodb_buffer_pool_dump_now, innodb_buffer_pool_dump_pct, innodb_buffer_pool_instances, innodb_buffer_pool_size, innodb_change_buffer_max_size, innodb_change_buffering, innodb_checksums, innodb_commit_concurrency, innodb_concurrency_tickets, innodb_data_file_path, innodb_data_path, innodb_disable_sort_file_cache, innodb_doublewrite, innodb_doublewrite_buffer_size, innodb_fast_shutdown, innodb_file_format, innodb_file_format_check, innodb_file_format_max, innodb_file_per_table, innodb_flush_log_at_trx_commit, innodb_flush_method, innodb_force_load_corrupted, innodb_force_recovery, innodb_io_capacity, innodb_io_capacity_max, innodb_large_prefix, innodb_lock_wait_timeout, innodb_locks_unsafe_for_binlog, innodb_log_buffer_size, innodb_log_file_size, innodb_log_files_in_group, innodb_log_group_home_dir, innodb_max_dirty_pages_pct, innodb_max_dirty_pages_pct_lwm, innodb_max_purge_lag, innodb_max_purge_lag_delay, innodb_mirrored_log_groups, innodb_old_blocks_time, innodb_rollback_on_timeout, innodb_sort_buffer_size, innodb_stats_method, innodb_status_output, innodb_status_output_locks,
2025-07-12 04:43