sql int vs integer 1

sql int vs integer

INT is a synonym for INTEGER

SQL defines distinct data types named by the following keywords: 
CHARACTER, CHARACTER VARYING, BIT, BIT VARYING, NUMERIC, DECIMAL, 
INTEGER, SMALLINT, FLOAT, REAL, DOUBLE PRECISION, DATE, TIME, TIMESTAMP, 
and INTERVAL.

Here is what the above code is Doing:
1. We’re creating a table called “users” with a column called “name” that is a string.
2. We’re creating a table called “users” with a column called “num_friends” that is an integer.
3. We’re creating a table called “users” with a column called “num_gummies” that is a float.

Similar Posts