Answer / satya

MyIsam is my default storage engine , where as InnoDB is
faster storage Engine and offers row level locking ,

Answer / madhuri

1) MYISAM is faster then the InnoDB but in case of perforing
the count operation it takes more time then the InnoDB.
2)MYISAM does not support the foreign key constraint and
transaction but InnoDB support it.
3)Upto Mysql 5.0 MyIsam is the default engine and from
Mysql 5.1 Innodb is the default engine.
4)MyIsam supports table level lock and where as Innodb
supports row level locking.

Thanks.,
Madhuri.

How do I grant privileges to a user in mysql phpmyadmin?

0 Answers  

---

What's the difference between mysql and sql server?

0 Answers  

---

What is localhost in mysql?

0 Answers  

---

What is dblink?

0 Answers  

---

How many services is running in sql server?

3 Answers   ACC, V2 Solutions,

---

How we can get distinct columns values in mysql?

0 Answers  

---

How to show table structure mysql?

0 Answers  

---

Is mysql free software?

0 Answers  

---

How do you control the max size of a HEAP table?

1 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  

---

table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

0 Answers  

---

What are the differences between binary and varbinary?

0 Answers  

---