怎么用sql修改mysql表名

ALTER TABLE name RENAME TO new_name
例如:
ALTER TABLE register RENAME TO member