Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When you have a table called sheep and you would like to call it c what would be the correct way to do this in phpMyAdmin when writing the query

share|improve this question

migrated from stackoverflow.com Mar 25 '13 at 13:41

This question came from our site for professional and enthusiast programmers.

    
SELECT sheep_atribute FROM sheep AS c; ? – Vucko Mar 25 '13 at 8:02
up vote 1 down vote accepted

Go to your phpMyAdmin database where the table is stored and go to the "SQL" tab.
Then proceed with this command:

RENAME TABLE table_name TO new_table_name

Or when you don't need to rename the table permanently you can use the AS statement

SELECT  c.*
FROM    sheep AS c
share|improve this answer

phpMyadmin is just an interface to access your database.

you can use mysql ALIASING to call it by different name or words for example

SELECT c.* FROM sheep c;

here c refers to table sheep so whenever you want to refer to sheep tables column you use the alias c.

share|improve this answer

It is called ALIAS. The basic syntax is:

SELECT  c.*
FROM    Sheep AS c

And AS is optional.

share|improve this answer

You can give alias name like below query

Select * from sheep c
share|improve this answer
SELECT c.* FROM sheep c 

This is The Answer

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .