Coding task · SQL and MySQL course · Module 5: Modifying data (DML)

Write in a new book

Use INSERT INTO to write a new scroll onto the ksiazki shelf. List the columns, then the values in the same order.

Task

Write a command that adds to the ksiazki table a new book: tytul 'Geografia', autor_id 3, rok_wydania -200, cena 49.90, dostepna 1. List the columns in the order: tytul, autor_id, rok_wydania, cena, dostepna.