×
Night mode
Sign up
Login
Create table based on another table with renamed fields
Creates new table 
st
and copies only several fields from 
students
table
CREATE TABLE st AS
SELECT 
    id, 
    first_name AS name,
    last_name AS surname
FROM students
by Valeri Tandilashvili
4 years ago
MySQL
CREATE & SELECT
Full MySQL Course for Beginners
1
Pro tip: use ```triple backticks around text``` to write in code fences