Working with SQL database

You are most welcome to this post.

Really thanks to you for your interest in this topics. :)

I bed no intention to learn you how to create a database from irritate. As beginners, your tasks should exclusive band around adding or updating values to an already existing dataset. Yet, I get a thought that both of you solace screw that avidness to instruct SQL in inflict
to make the intact exercise including the dataset itself. And so, I give start that endeavor of SQL, but retributory sufficiency to helpfulness you jumpstart. The SQL keyword to create a new database is the statement Create DATABASE and this falls under ANSI specification. Let us say you essential to make a new database for junction book of grouping and you require to kinfolk this new database as Contacts. Here is how you are deed to do it.

 

 

Here are some data types, lets learn about them,

CHARACTER

Used to define the number of
characters allowed in the column. No
more, no less.

 

CHARACTER VARYING

Used to define the maximum number
of characters allowed in the column.
Can be less but not more than the
specific value.

 

BINARY

Used to dedicate the column for
hexadecimal data.

 

SMALLINT

Used to store numerical data ranging
from -32, 768 to 32, 767

 

INTEGER

Used to store numerical data ranging
from -2, 147, 483, 648 to 2, 147, 483,
647.

 

BIGINT

Used to store numerical data ranging
from -9, 223, 372, 036, 854, 775, 808
to 9, 223, 372, 036, 854, 775, 807.

 

BOOLEAN

Used to store either TRUE or FALSE
values.

 

DATE

Used to store DAY, MONTH, and
YEAR in the following format:
YYYY-MM-DD.

 

TIME

Used to store SECOND, MINUTE,
and HOUR in the following format:
HH:MM:SS.

 

TIMESTAMP

Used to store both TIME and DATE.