mysql查询替换选择全部

Question

$sql = "select a.time a.company a.deptime, a.destime, a.flight, a.year, a.month, a.day, ".$ticket_to_heaven." as ".$this->condition['type'].", ".$seat." as ".$this->condition['type']."_s, a.company, a.time from ".$this->TBLNAME." a ";

I would like to change it into $sql ="select * from ...."

But I am the 'a' sneaks in with error output. What a messy 'a'! could somebody please be of any help ? Thank you

[UPDATE]

I have changed it into something like this:

$sql = "select a.*, ".$ticket_to_heaven." as ".$this->condition['type'].", ".$seat." as ".$this->condition['type']."_s, a.company, a.time from ".$this->TBLNAME." a ";

It still looks a little odd to me.

Answer 1

use

select a.* from table a

or (without alias)

select * from table