-- MySQL SELECT column1 AS name1, column2 AS name2 FROM table1; -- AS allows your to replace the name of a column when outputting but does not -- actually change the column name within the database.