Измените имя таблицы titles_test на titles_2017

CREATE TABLE IF NOT EXISTS titles_test (
    id int(11) not null primary key,
    emp_no int(11) NOT NULL,
    title varchar(50) NOT NULL,
    from_date date NOT NULL,
    to_date date DEFAULT NULL
);

INSERT INTO titles_test VALUES 
    ('1', '10001', 'Chief Engineer', '1986-06-26', '9999-01-01'),
    ('2', '10002', 'Employee', '1996-08-03', '9999-01-01'),
    ('3', '10003', 'Chief Engineer', '1995-12-03', '9999-01-01'),
    ('4', '10004', 'Chief Engineer', '1995-12-03', '9999-01-01'),
    ('5', '10001', 'Chief Engineer', '1986-06-26', '9999-01-01'),
    ('6', '10002', 'Employee', '1996-08-03', '9999-01-01'),
    ('7', '10003', 'Chief Engineer', '1995-12-03', '9999-01-01')
;

ALTER TABLE titles_test RENAME TO titles_2017

ALTER TABLE titles_test RENAME TO titles_2017