Share
Showing posts with label AS. Show all posts
Showing posts with label AS. Show all posts

  • Creating a custom column use the keyword CONCAT -
    SELECT CONCAT(city,',',state) FROM customers
  • Give name to the new custom column -
    SELECT CONCAT(city,',',state) AS new_info FROM customers