Answer / shankey*

A database is similar to a data file in that it is a
storage place for data. Like a data file, a database does
not present information directly to a user; the user runs
an application that accesses data from the database and
presents it to the user in an understandable format.

Database systems are more powerful than data files in that
data is more highly organized. In a well-designed database,
there are no duplicate pieces of data that the user or
application must update at the same time. Related pieces of
data are grouped together in a single structure or record,
and relationships can be defined between these structures
and records.

When working with data files, an application must be coded
to work with the specific structure of each data file. In
contrast, a database contains a catalog that applications
use to determine how data is organized. Generic database
applications can use the catalog to present users with data
from different databases dynamically, without being tied to
a specific data format.

A database typically has two main parts: first, the files
holding the physical database and second, the database
management system (DBMS) software that applications use to
access data. The DBMS is responsible for enforcing the
database structure, including:

Maintaining relationships between data in the database.


Ensuring that data is stored correctly, and that the rules
defining data relationships are not violated.


Recovering all data to a point of known consistency in case
of system failures.

Answer / kasirajan

database is used to store data's and retrieve it whenever needed...this is a simple answer...

List data types in mysql? Explain

0 Answers  

---

What is mysql good for?

0 Answers  

---

How large can a mysql database become?

0 Answers  

---

What is a crosstab query?

0 Answers  

---

What is mysql sleep process?

0 Answers  

---

How to make a copy values from one column to another in mysql?

0 Answers  

---

mysql> select * from store; +------+-------+-------+ | id | month | sales | +------+-------+-------+ | 1 | 1 | 100 | | 1 | 2 | 100 | | 1 | 3 | 200 | | 1 | 4 | 300 | | 1 | 5 | NULL | | 1 | 6 | 200 | | 1 | 7 | 800 | | 1 | 8 | 100 | | 1 | 9 | 240 | | 1 | 10 | 140 | | 1 | 11 | 400 | | 1 | 12 | 300 | | 2 | 1 | 300 | | 2 | 2 | 300 | | 2 | 3 | 300 | | 2 | 4 | 200 | | 2 | 5 | 200 | | 2 | 6 | 200 | | 2 | 7 | 100 | | 2 | 8 | 100 | | 2 | 9 | 300 | | 2 | 10 | 100 | | 2 | 11 | 150 | | 2 | 12 | 150 | +------+-------+-------+ this is my table. i need to display output like this. +------+----------+----------+----------+----------+ | id | quarter1 | quarter2 | quarter3 | quarter4 | +------+----------+----------+----------+----------+ | 1 | 400 | 500 | 1140 | 840 | | 2 | 900 | 600 | 500 | 400 | +------+----------+----------+----------+----------+ what single query i have to write for this. i tried this query and it displays like the below mysql> select id,sum(sales) as quarter1,(select sum(sales) from store where mont h>3 and month<7 ) as quarter2,(select sum(sales) from store where month>6 and mo nth<10)as quarter3 from store where month>0 and month<4 group by id; +------+----------+----------+----------+ | id | quarter1 | quarter2 | quarter3 | +------+----------+----------+----------+ | 1 | 400 | 1100 | 1640 | | 2 | 900 | 1100 | 1640 | +------+----------+----------+----------+ 2 rows in set (0.00 sec) tel me how to rectify it.

2 Answers  

---

What storage engines are used in MySQL?

0 Answers  

---

why we are join a tow table

1 Answers  

---

date funciton

2 Answers  

---

How to delete the repeated records from a table?

0 Answers  

---

Can you tell the difference between $message and $$message?

0 Answers  

---