Class Eleven; Text (Introduction to Structured Query Language (SQL))

Creating Database and Table

CREATE DATABASE (Name of the database)

CREATE TABLE (Name of the table) (

Names   varchar (50),

Age            int,  

Gender      char(10),

Phone        bigint,

Emails       varchar (200),

Address       varchar (50)

);

Populating the table

    INSERT INTO [Table Name]

Values

(‘Akpos Manuel’, 30, ‘male’, 08123456789, ‘[email protected]’, ’15b wire road b/city’)

Difference between integers and bigintegers

•      Integer data type can store integers up to a certain size while

•      Big-integer can store integers of any size.

•      Difference between Variable(var) and Variable-character(varchar)

•      Variable (var) can only store a data of a specific length while

•      Variable-character(varchar) can store data of any length

Reasons for Integers and Big-integers not having specifications like other data types

•      That’s because the “INT” and “BIGINT” data types don’t have a length specification like the other data types. That’s because the length of the “INT” and “BIGINT” data types is determined by the specific SQL implementation you’re using. Different implementations of SQL have different maximum lengths for the “INT” and “BIGINT” data types.