Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

?? m.manufacturers_id, p.products_id, pd.products_name etc.


tati

Recommended Posts

hi,

wondering what the one and two letter combinations in expressions like this mean?

 

m.manufacturers_id, p.products_id, pd.products_name,

 

I guess it is SQL but as i know only the very basics of SQL i'd be very thankful for enlightenment!

 

thanks,

tati

Link to comment
Share on other sites

They are aliases for tables used in the query. If you look further back in the query, you will see something like TABLE_MANUFACTURERS . " m ... This tells it that m.variable name is shorthand for the column from the table manufacturers.

 

Hth,

Matt

Link to comment
Share on other sites

ah - so if i'm using my own tables and not using them too often i could just as well put in the full tablename like learningvalues.learningv_id etc?

 

or is it advisable to keep the alias syntax for 'selfmade' stuff as well?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...