Notes

.*DOMAIN PARTS- USER PART and DOMAIN PART
IP ADDRESS- 32 bits

*GRANT- Allow someone to access our data.{ Use MYSQL Select User from User}
*REVOKE- To take back the given permissions.

*SYNTAX-
CREATE-USER-USER IDENTIFY-BY-PASSWORD;
EG. CREATE USER RAVEENA IDENTIFY BY ABC

*TRIGERS- It defines the action that a database should take when some database related event occurs.
3TYPES-
-ROW - {A row level will be fired each time in a row when it is affected by a trigered statement}
-STATEMENT - {The statement level triger will be fired only once on the behalf of begining statement}
-BEFORE/AFTER - {Before triger will be fired before the begining statement and after statement will be fired after the begining statement}

*ASP- Active server page

MYSQL= native lang of SQLmysql and sql used for DBMS and DATABASE SERVER
MYSQL server is 5.1

*FEATURES OF MYSQL
-cost- zero(open source software
-fast- performance
-Scalability- holds deeply embeded data upto 1MB
-Simplicity
-High performance - {can cover full index}
-Application support - {supports all languages like java c+ php}

*HOW TO START MYSQL
START-ALL PROGRAMS-MYSQL-MYSQL SERVER 5.1-MYSQL COMMAND LINE CLIENT

*DATATYPE IN MYSQL
1-Numeric
2-String
3-Date and Time
4-Boolean

*NUMERIC-
-BIT {1-64 bits wide}
-BIGINT -9223372036854775808 to +9223372036854775807{singned value} 18446744073709551615{unsigned value}
-BOOLEAN (bool -flag on/of){indication regarding errors}
-DECIMAL (Dec){terms .025 to .1528}{max values on floating}
-DOUBLE {Floating point values double}
-FLOAT {Floating value single}
-INTEGER (INT) -2147483648 to +21474863647 {unsigned values of integers 0 to 4294967295}
-REAL (4 bytes floating point)

*STRING
-Name -Address -ph. no. -zip code
-2 types{fix length and variable length}

*DATA TYPE
-CHAR - {fixed legth string- 1 to 255 chars long. Size specific at create time {default value=1}
-ENUM - {upto 64k strings can be entered}{no copyright issues}
-LONGTEXT - {max size upto 4gb}
-MEDIUM TEXT - {max size upto 16k}
-SET - {accepts zero/predefined sets upto 64 strings}
-TEXT - {variable length will be upto 64k}
-TINY TEXT - {same as text but size upto 255bytes}
-VAR CHAR - {same as character but stores just the text}{size will in max i.e infinite}


*DATE AND TIME
-Special data type for storage of date and time values.

*DATA TYPE
-DATE -{1000-01-01 to 9999-12-31}
-DATETIME - {combination of date and time}
-TIME STAMP - {functionally equivalent to date time(but with small range)}
-TIME - {H.H. M.M. S.S}
-YEAR - {A 2 or 4 digit year, 2 digit year support range of 70(1970) to 69 (2069), 4 digit year support range of 1901 to 2155}


*BOOLEAN
-Also called binary data type {used to sotre all sorts of data, which includes images, graphics, animations and word processor docs}

*DATA TYPE
-BLOB - {64k}[Binary large object]
-MEDIUMBLOB - {16MB}
-LONGBLOB - {4GB}
-TINYBLOB - {255 bytes}


*NULL VALUES
-Unrecognized/unavailable/unsigned/unknown values.
-A null values is not same as zero or blank. (coz zero is a number and space/blank is a character).


*HYPERLINK
-{web page_ redirect _web page}


*WAMP
-WINDOWS
-APACHE
-MYSQL
-PHP

*MPEG - {Moving picture expert group}

*LINKING- {Connecting 2 or more pages on internet}
-TYPES
-INTERNAL LINK - {Already exists in the system}
-EXTERNAL LINK - {web page(hyperlinking)}

*DBMS
-DATA--INPUT--PROCESSOR--OUTPUT--INFORMATION


*COMMENTS
-Non executable statements that are used to understand a program or can be used to read a program.
-TYPES OF COMMENTS
-Single line comment - {starts with// [// means END OF CURRENT LINE]}
-Multiple line comment - {starts with/* and ends with*/}

/* calculate
sum of two numbers*/

*SIGNS IN CODING AND THEIR MEANINGS-0


OPERATOR MEANING
= = Equal to
!= Not equal to
< Less than
<= Less than equal to
> Greater than
>= Greater than equal to
= = = Strictly equal
! = = Strictly not equal
& & Logical and
"
" Logical or
! Logical not


*PLSQL- [PROCEDURAL LANGUAGE STRUCTURE QUERY LANGUAGE]
-Serves as an extention for SQL {used for RDBMS}{Oracle is a server that manages DBMS & RDBMS}

*BLOCK STRUCTURE-
-D - Declare {memory variables and user defined exceptions}
-B - Begin {Begin with SQL and+ PLSQL statements}
-E - Exception {handling of error that arise during the execution of code block}
-E - End {end of PLSQL block structure}
-Begin and End are mandatory and rest are optional.

*Softwares are of two types SYSTEM SOFTWARE and APPLICATION SOFTWARE.

*ARPANET:{Advance research project agency network}
*VIRUS: {Vital information resources under seize}