Introduction
Numbers
Boolean
Date and time
Summary

Instruction

Great! You may wonder how to write decimal numbers in SQL and the answer is simple - just as you write floating point numbers. 1.5 still stands for one and a half. Quite convenient, isn't it?

Exercise

We've got a new payment from the user with user_id 13. He made a payment in the amount of 314.27. Insert this data into table payment.

Stuck? Here's a hint!

Type

INSERT INTO payment VALUES (13, 314.27);

Console

Code editor

Result

TableConsole