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

Data Types in SQL

Numerical data types
Integer data types
3. integer – inserting data
Floating point data types
Decimal data types
Summary

Instruction

Great! Remember that numbers don't take quotation marks in SQL statements. For example:

INSERT INTO premium_account VALUES (6);

This will simply insert a 6 into the only column of the premium_account table. We did not need to place the 6 in quotes, as we did earlier with text. The same applies for any other SQL statement with numbers.

Exercise

A user (with the user_id of 3) has bought a premium account! Add that person to the table premium_account.