changing column name in mysql from sum(xyz) to xyz

Question

In MySQL, how do I change the column name of a table from "sum(xyz)", to say "xyz"? I have tried the following solutions for just changing the column name:

Change Column Name in MySQL

Rename column SQL Server 2008

However, it always throws up an error saying that the syntax is not right. I feel that it is because of the sum() function, because it doesn't allow me to use SELECT on that column too (when done separately). Is there any way past this? A solution to access the values in that column without changing the column header is also appreciated!

I am using WAMPSERVER to run MySQL version 5.1.53.

Thanks

Halko Karr-Sajtarevic · Answer 1 · 2018-07-11T08:47:39.607

1

Try this:

ALTER TABLE mytable CHANGE COLUMN `sum(xyz)` `xyz` <yourdatatype>;

edited Jul 11 '18 at 08:47

answered Jul 11 '18 at 08:31

Halko Karr-Sajtarevic

2,248
1
16
14

It says unknown column name 'xyz' in 'field list'. The header of my table is already "sum(xyz)" – Adhithya Padmanabhan Jul 11 '18 at 08:34
then please post your query – Halko Karr-Sajtarevic Jul 11 '18 at 08:43

score 1 · Accepted Answer · answered Jul 11 '18 at 08:36

1

So, your column name is "sum(xyz)" and you can't do a select because of the "sum()" function.

Try

SELECT ` sum(xyz)` as xyz from mytable;

answered Jul 11 '18 at 08:36

Krishnakumar

725
1
6
11

score 0 · Answer 3 · answered Jul 11 '18 at 08:36

0

Use AS to make virtual field

Your code will be same as SELECT SUM(yourField) as xyz FROM table

answered Jul 11 '18 at 08:36

Riajul Islam

1,425
15
19

changing column name in mysql from sum(xyz) to xyz

3 Answers3