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
5. Numbers out of range
Floating point data types
Decimal data types
Summary

Instruction

Nice try! As you can see, it's not possible to enter a text value into a number column. Numbers don't provide as much space as text data, so text information simply doesn't fit into number columns!

Now, how about numbers outside the data type's range?

Exercise

Can we put a number that's bigger than the maximum or smaller than the minimum in an integer column? Remember, integer stores numbers from -2147483648 to 2147483647.

Try to insert a number outside of these limits into the premium_account table. (See the template.)