select  concat(firstname,' ',surname) fullname,
  date_format(dob, '%M %d, %Y') dob,
  case relation
  when 'A' then 'Wife'
  when 'B' then 'Dependent'
  when 'C' then 'Disabled'
  when 'D' then 'Children'
  end
  as relation
from test
where gwl = '1234567890'
order by relation

-- To rename the table from t1 to t2:
ALTER TABLE t1 RENAME t2;

-- To change column a from INTEGER to TINYINT NOT NULL (leaving the name the same), and to change column b from CHAR(10) to CHAR(20) as well as renaming it from b to c:
ALTER TABLE t2 MODIFY a TINYINT NOT NULL, CHANGE b c CHAR(20);

-- To add a new TIMESTAMP column named d:
ALTER TABLE t2 ADD d TIMESTAMP;

-- To add an index on column d and a UNIQUE index on column a:
ALTER TABLE t2 ADD INDEX (d), ADD UNIQUE (a);

-- To remove column c:
ALTER TABLE t2 DROP COLUMN c;

-- To add a new AUTO_INCREMENT integer column named c:
ALTER TABLE t2 ADD c INT UNSIGNED NOT NULL AUTO_INCREMENT,
  ADD PRIMARY KEY (c);
We indexed c (as a PRIMARY KEY) because AUTO_INCREMENT columns must be indexed, and we declare c as NOT NULL because primary key columns cannot be NULL.

-- drop column from table:
ALTER TABLE t2 DROP COLUMN c, DROP COLUMN d;

-- move columns inside table, and rename:
ALTER TABLE test change column test1 test2 varchar(20) first;