super_noob — 2013-12-05T22:36:57-05:00 — #1
Okay I have this codes below,
$this->db->select('c.lessonid as clessonid, l.*, c.completionid');
By the way the codes above is a SELECT command from CodeIgniter.
But the SELECT() is a MySQL command.
My question is what is this command below inside SELECT mean?,
What does the asterisk and number one do/mean?
Can someone please explain it in plain english.
Thanks in advance.
vpalukuru9 — 2013-12-06T00:16:04-05:00 — #2
The select is used to fetch the columns of a table. Here l indicates the alias of table or table name and the * means all columns from that table. Here is the complete syntaxt:
r937 — 2013-12-06T13:14:36-05:00 — #3
it is the lower-case letter L followed by dot asterisk -- the asterisk means all columns, and the lower-case letter L is the table alias of one of the tables in the SELECT
john_betong — 2013-12-06T17:54:37-05:00 — #4