Hi, I'm new for here and new for mysql too.

so want to get query for crosstab some fields as columns.

As a example

let assume I has simple Student Table like follows

+----------+---------+------------+
--stu_id--||-subject-||-stu_marks-|
+----------+---------+------------+
--1-----|----Word----|----50----|
--2-----|----Excel----|----75----|
--1-----|----Excel----|----80----|
--2-----|---Access---|----68----|
--2-----|----Word----|----33----|


so I want query to alter above table as following

+----------+---------+------------+----------+
|--stu_id---|--Word--|----Excel----|--Access--|
+----------+---------+------------+----------+
|-----1----|----50---|-----80-----|-----------|
|-----2----|----33 --|-----75-----|----68-----|
+----------+---------+------------+----------+

If some one can help me to get exact query its great help

Thanks

Thanksssss friend. its really help for my other task.

see image for result