XML Project

XML
XML language is developed by WORLD WIDE WEB

CONSORTIUM . It is a type of mark up language.
XML is also used like HTML to display and store
data. XML is also used to exchange information
on internet. Tags written in XML are designed
as it can easily understood by used human &
machines. It is a self descriptive language and
it is a subset of SGML (Standard generalised
markup language). This makeup language is used
to design storage of big amount of data.
FEATURES OF XML
1) Capable to handle complex & abnormal data.
2) Keeps detail of text data
3) To store data for long time and perfect for
reusing data
4) According users & format of computer and user
5) Description of data in mark-up language
DECLARATION OF XML
<?XML version= “1.0” encoding = “UTF-8”?>
RULES OF XML DECLARATION

1) XML declaration always written in first line of
XML document
2) Version is compulsory to write in declaration
3) Name of parameter and its value are case
sensitive
4) Parameter name is written in small letters
5) Single quote and double quotes can be used
6) Closing tag (/?XML) is not included in XML
declaration
MYSQL DATABASE
mysql>create database 123;
query ok, 1 row affected(0,01 sec)
mysql>use 123;
database changed
mysql>create table student
(sId int,
sName varchar(20),
sAddress varchar(20),
sDOB date,
sCity varchar(20));
query ok, 0 rows affected(0.12 sec)
mysql>describe student;
Field Type Nul Ke Defaul Extr
l y t a
sId Int Yes Null
sName Varchar(20 Yes Null
)
sAddres Varchar(20 Yes Null
s )
sDOB Date Yes Null
sCity Varchar(20 Yes Null
)
5 rows in set(0.10 sec)
mysql> insert into student
values(12345,’pranav’,’ram vihar’,’1-
1-2001’,’jodhpur’);
query ok, 1 row affected(0.06 sec)
mysql>insert into student

values(12346,’riya’,shanti nagar’,’2-
2-2002’,’jaipur’);

values(12347,’raman’,’shastri
nagar’,’3-3-2003’,’udaipur’);

values(12348,’seema’,’vidhya
nagar’,’4-4-2004’,’alwar’);

values(12349,’shayam’,’chaura rasta’,’5-
5-2000’,’puna’);
mysql>select * from student;
sId sName sAddress sDOB sCity
12345 pranav Jhotwara 1-1- Jodhpur
2001
12346 Riya Chandpol 2-2- Jaipur
2002
12347 Raman Mansarover 3-3- Udaipur
2003
12348 Seema Eidgah 4-4- Alwar
2004
12349 Shayam Chaura 5-5- Puna
rasta 2000
5 rows in set(0.10 sec)
Query 4. Change the city name of the

student whose name is raman
mysql>update student
set sCity=madhopur
where sName like ‘raman’;
12347 Raman mansarover 3-3-2003 madhopur

Query 5. Delete the record of the riya
mysql>delete from student
where sName like ‘riya’;
Query ok, 1 row affected (0.02 sec)
12345 Pranav Jhotwara 1-1- Jodhpur
2001
12347 Raman Mansarover 3-3- Madhopur
2003
12348 Seema Eidgha 4-4- Alwar
2004
12349 Shayam Chaura 5-5- Puna
rasta 2000
Query 6. Arrange all records in

decending order.
mysql>select * from student
order by sName desc;
12349 Shayam Chaura 5-5-2000 Puna
rasta
12348 Seema Eidgha 4-4-2004 Alwar

12347 Raman mansarover 3-3-2003 madhop
ur
12345 Paranav jhotwara 1-1-2001 jodhpu
r
Query 7. Display name of student whose

second letter of name is A
mysql>select sName from student
where sName like ‘_r%’
sName
Pranav
Query 8. Display name of student whose

name ends with an
mysql>select sName from student
where sName like ‘%an’
sName
Raman
Query 9. Count number of record in the

table student
mysql>select count(*)from student
Count(*)
5
Employee table
mysql>create table employee
(
empName varchar(20),
empAddress varchar(20),
empDesignation varchar(20),
empSalary int);
Query ok, 0 row affected in (0.12 sec)
mysql>describe employee;
Field Type Nul Key Defaul Extr
l t a
empName Varchar(2 Yes Null
0)
empAddress Varchar(2 Yes Null
0)
empDesignati Varchar(2 Yes Null
on 0)
empSalary int Yes Null
mysql>insert into employee

values(Narayan, ‘van vihar’,
‘manager’, ‘6500’);
values(Pankaj, ‘central park’,
‘clerk’, ‘3000’);
values(Manish, ‘shanti nagar’ ,
‘HR’, ‘4000’);
values(Dinesh, ‘pital factory’,
‘gen. manager’, ‘5500’);
mysql>select * from employee;
empName empAddress empDesignation empSalary
Narayan Van vihar Manager 6500
Pankaj Central Clerk 3000
park
Manish Shanti HR 4000
nagar
Dinesh Pital Gen. manager 55oo
factory
4 row in set (0.12 sec)
Query 2. Display name of employee whose
salary is less than 5000
mysql>select empName as ‘
from employee
where empSalary<5ooo;
empName
Pankaj
Manish
Query 3. Display name of employee whose
salary is maximum
mysql>select empName,max(empSalary)as
‘maximum salary’ from employee
Maximum
salary
Narayan
Query 4. Display average salary of

employee.
mysql>select avg(empSalary)
‘average salary’
from employee
average
salary
4,750

XML Project

Uploaded by

Copyright:

Available Formats

XML Project

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

XML Project

Uploaded by

Copyright:

Available Formats

XML

XML language is developed by WORLD WIDE WEB

RULES OF XML DECLARATION

mysql>insert into student

mysql>insert into student

mysql>insert into student

mysql>insert into student

Query 4. Change the city name of the

sId sName sAddress sDOB sCity

12347 Raman mansarover 3-3-2003 madhopur

Query 6. Arrange all records in

12348 Seema Eidgha 4-4-2004 Alwar

Query 7. Display name of student whose

Query 8. Display name of student whose

Query 9. Count number of record in the

mysql>insert into employee

Query 4. Display average salary of

You might also like