Notes

Xtensible hyper text markup language

(Features of MY SQL):
MY STRUCTURE QUERY LANGUAGE
cost=MYSQL -zero
open source software
Fast-performance
scalability:
deeply embedded data app UPTO 1MB
#(FEAYURE OF MY SQL):
.COST
.PERFORMANCE
.SIMPLICITY
.SCALIBILITY
.HIGH PERFORMANCE-full index can be cover over here or can store
.DATA SECURITY- supports all languages java,php,c+
.APPLICATION SUPPORT-

(start+all pogrames+MYSQL+MYSQOL server 5.1+MYSQL COMMAND LINE CLIENT)



DATA TYPE IN MYSQL:::::::
1>NUMERIC:BIT 1-64 bites wide
BIGINT:
1>integer value
-9223372036854775808-----------------807+
2>if unsingned:
0-218446744073709551615
BOOLEAN(BOOL):indication that shows any error and ignitions
FLAG ON/OFF
DECIMAL
DEC(.025to.1528)max value on floating
DOUBLE-FLOATING VALUE DUBLE
FLOAT-FLOATING VALUE SINGLE
:INT-INTEGER
-2147483648 TO +_____________________647
UNSIGHNED VALUES OF INTEFERS
0 TO 4294967295
REAL:
4BYTES-FLOATING POINT


2>STRING:
.FIXED LENGHT
.VARIABLE LENGHT
NAME, ADDRESS, PHONE NUMBER, ZIP-CODE
DATA TYPE:
>CHAR-CHRACTER
>>>>>FIXED AND VARIABLE LENGTH STRING
.1 TO 255 CHARS LONG
.<SIZE>SPECIFIC AT CREAT TIME
.BY DEFAULT VALUE:1
>ENUM-PREDIFINED VALUE UPTO 64K AND NO COPYRIGNT ISSUES
>LONGTEXT-MAX SIZE UPTO 4GB
>MEDIUM TEXT-MAX SIZE UPTO 16K

>SET-ONLY SET CAN ACCEPT ZERO/PREDFINED SETS UPTO 64 STRINGS
>TEXT-VARIABLE LENGHT WILL BE 64K
>TINY TEXT-SAME AS TEXTS BUT SIZE UOTO 255BYTES
>VARCHAR-SAME AS CHRACTER BUT STORES JUST THE TEXT/BUT SIZE WILL BE MAX (INFINITE)

3>DATE $TIME:SPECIAL DATA TYPE FOR STORAGE OF DATE$TIMES VALUE
##DATA TYPE:
.DATE-(1000-01-01 TO 9999-12-31)
.DATE$TIME-COMBINATION OF DATE$TIME
.TIME STAMP-FUNCTIONALLY EQUIVALENT TO DATE$TIME(BUT WITH SMALL TIME RANGE)
.TIME-HH.MM.S
.YEAR-A 2 OR 4 DIGIT YR. SUPPORT RANGE OF 70(1970)TO69(2069) 4 DIGIT YR. SUPPORT RANGE OF 1901 TO 2155

4>BOOLENS-BINARY DATA TYPE BOTH ARE SAME (USED TO STORE ALL SORT/SHORT OF DATA WHICH INCLUDES IMAGES,GHRAPHICS,ANIMATION AND WORD PROCESSOR DOC.
;;;DATA TYPE:(BINARY LARGE OBJECT)
.BLOB-64K
.MEDIUMBLOB-16MB
.LONGBLOB-4GB
.TINYBLOB-255BYTES

#NULL VALUES:(UNRECOGANISED,UNSIGNED,UNKNOWN VALUES)
THE VALUE IS NOT SAME AS 0 TO BLANK(IT IS A CHRACTER).

#$$#HYPERLINK:
one web page is linked with another web page.

#WAMP=WINDOW,APACHE,MYSQL,PHP
#MPEG=MOVING PICTURE EXPERT GROUP
#LINK=CONNECTING TWO OR MORE PAGES ON INTERNET


#$#$TYPES OF LINKS:
.INTERNAL:alreday exists in the system that takes us to the another web page
.EXTERNAL:redirect us from one web page to another web page

##DATA:RAW material
##INFORMATION:


#DATA#
.DATA BASED
.ALPHA
.FIGURES
.INFORMATION

#INTIGRITY:Uniformity of several files into a single file

INCONSTANCY CAN BE AVOIDED


external link double decimal redirect external link rebusshing statement boolean


##COMMENTS:
non executable statements that are used to understand a programe or to read a programe.
**2TYPES OF COMMENTS:
.SINGLE LINE COMMENT:it starts with"(end of current line)
.MULTIPLE LINE COMMENT:it starts with /* and ends with*/
*OPEN MULTIPLE LINE COMMENT:/*calculate
sum of two numbers*/


(SIGHNS USED IN CODEING)::::
OPERATOR:
= =:EQUAL TO
! =:NOT EQUAL TO
< :LESS THAN
<= :LESS THAN EQUAL TO
> :GREATER THAN
>= :GREATER THAN EQUAL TO
= = =:STRICTLY EQUAL TO
! = :STRICTLY NOT EQUAL
&& :LOGICALLY AND
" :LOGICAL OR
"
! :LOGICALLY NOT

##PLSQUL:PROCEDURAL LANGUAGE STRUCTURE QUERY LANGUAGE(IT'S THE EXTENSION FOR THE SQL)FOR RDBMS.

>>USAGE OF THE CODEING:6

MPEG-MOVING PICTURES EXPERT GROUP
WAMP-WINDOW APACHE MYSQL PHP


##THERE ARE TWO TYPES OF SOFTWARE:
.SYSTEM SOFTWARE
.APPLICATION SOFTWARE

#ARPANET:
ADVANCE RESERCH PROJECT AGGENCY NETWORK


^^VIRUS:
VITAL INFO9RMATION RESOURCES UNDER SEIZE

#WEB BROWSER:
IT IS A 0APPLICATION SOFTWARE.

####parts of DCL:
>GRANT=allow someone to access our data
>REVOK=to take back the given data
USE MYSQL
SELECT USER FROM USER.

SYNTAX=
Creat-user-user-identify-by-password;
eg. creat user sameer identify by ABC

EMP1

*TRIGGERS:
it defines the action that a data base should take when some data base related events occures.
3typrs:
row-a row level will be fired each time in a row when it is affected by a triggered statement
statement- it will be fired only once on the behalf of triggering statement
before/after-before will be fired before the begining statement and after trigger will be used after the begning statement