Answer Posted / shweth
we can use ALIAS function for this
select tree AS plant
from table;
or simply we can skip writing AS but shoudnt write a comma
between the old and new column names.
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
How to check if value already exists in mysql database in php?
How to decrement dates by 1 in mysql?
What does the file with the extension: frm, myd, and myi contain?
What is mysql protocol?
In which language mysql has been written?
How do I enable mysqli extension?
What are slow queries?
How do I create a stored procedure in mysql?
What is database in php mysql?
How do I create a new database in mysql?
How do I copy a table in mysql?
What is a data directory?
What are the advantages and disadvantages of using mysql?
What is the query to display top 20 rows?
How many concurrent queries can mysql handle?
