Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Creating Tables in SQL

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);