Alias hostname for localhost

When the browser sees http://localwebapp/ it first tries to determine the IP address of localwebapp. If this succeeds, the browser establishes a TCP connection with that host, using a specific port (which is 80 for HTTP, unless some other port is mentioned in the URL). Resolving localwebapp to an IP address does not take port …

Read more

MySQL alias for SELECT * columns

You can’t use * with an alias. Aliases can be used for individual columns. You’ll have to alias each column instead.. So unfortunately, if you have a lot of columns, you’ll need to go: SELECT u.col1 AS u_col1 , u.col2 AS u_col2 , u.col3 AS u_col3 — etc , u2.col1 AS u2_col1 , u2.col2 AS …

Read more