×
Night mode
Sign up
Login
Create VIEW "student_notes"
Creates 
VIEW
called 
student_notes
that selects all notes with their authors
CREATE VIEW IF NOT EXISTS student_notes AS
SELECT 
    students.first_name,
    students.last_name,
    notes.*
FROM students
JOIN notes ON notes.student_id = students.id
After creating the 
VIEW
then we can use it as regular table like this example:
SELECT * 
FROM student_notes
by Valeri Tandilashvili
5 years ago
MySQL
Views
Full MySQL Course for Beginners
1
Pro tip: use ```triple backticks around text``` to write in code fences