...

View Full Version : help with query



liam_dalton
02-24-2009, 10:01 AM
Hello, I found this on Google: http://www.codingforums.com/archive/index.php/t-96084.html

and was wondering, what are those c. , p. things? Are they shorthand for something?

oesxyl
02-24-2009, 10:54 AM
Hello, I found this on Google: http://www.codingforums.com/archive/index.php/t-96084.html

and was wondering, what are those c. , p. things? Are they shorthand for something?
alias. You can give a name to a table for example:


select * from mytable as myt

you can use myt instead of mytable and when you adress a field you can use myt.myfield instead of mytable.myfield.

http://dev.mysql.com/doc/refman/4.1/en/identifiers.html

best regards

liam_dalton
02-24-2009, 03:53 PM
Thanks very much for your help!

oesxyl
02-24-2009, 04:03 PM
Thanks very much for your help!
you are welcome, :), and also welcome to the forum, :)

best regards

liam_dalton
02-25-2009, 07:01 AM
Hello, thanks for the warm welcome. I hope to learn lots here! :thumbsup:



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum