MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tbl_00 
   (card_flg_visa TINYINT, card_flg_jcb TINYINT);
   
SHOW CREATE TABLE tbl_00;


Table
Create Table


tbl_00
CREATE TABLE `tbl_00` (
  `card_flg_visa` tinyint(4) DEFAULT NULL,
  `card_flg_jcb` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1


ALTER TABLE tbl_00 
ALTER card_flg_visa SET DEFAULT 0,
ALTER card_flg_jcb SET DEFAULT 1;

Records: 0  Duplicates: 0  Warnings: 0


SHOW CREATE TABLE tbl_00;


Table
Create Table


tbl_00
CREATE TABLE `tbl_00` (
  `card_flg_visa` tinyint(4) DEFAULT '0',
  `card_flg_jcb` tinyint(4) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1