SQL statement format

$ SQL & quot; SELECTindexs. * consume & #039; $ newsNode & #039; ORDERBYindexs. pubtimeD... $ SQL ="
SELECT indexs. * FROM sdb_content_article_indexs indexs
Inner join sdb_content_article_nodes nodes
ON indexs. node_id = nodes. node_id
WHERE nodes. node_name = '$ newsNode'
Order by indexs. pubtime DESC;

"; What does index. * In the second row and indexs after the table name?

Reply content:

$ SQL ="
SELECT indexs. * FROM sdb_content_article_indexs indexs
Inner join sdb_content_article_nodes nodes
ON indexs. node_id = nodes. node_id
WHERE nodes. node_name = '$ newsNode'
Order by indexs. pubtime DESC;

"; What does index. * In the second row and indexs after the table name?

The second lineindex.*Returns the value of all fields in the index table;
Indexs:sdb_content_article_indexsAlias Name:indexs.sqlStatement length.

Indexs. * is used to query all fields in the table, and the indexs is the alias.

Table alias,

Alias: aliases are used for multi-table queries. You should learn the SQL syntax. the basics are very important.