Create a computing field CONCAT in MySQL

Source: Internet
Author: User
When I read the Mysql manual again today, I see a function concatenation field that is ignored at ordinary times. In fact, it is simple to use mysql functions to process strings. Calculated fields are usually compared.

When I read the Mysql manual again today, I see a function concatenation field that is ignored at ordinary times. In fact, it is simple to use mysql functions to process strings. Calculated fields are usually compared.

When I read the Mysql manual again today, I see a function concatenation field that is ignored at ordinary times. In fact, it is simple to use mysql functions to process strings. Calculated fields are usually used, but the concatenated fields are ignored.

A field (filed) basically has the same meaning as a column and is often used interchangeably. However, a database column is generally a column, and a term field is usually connected to a calculated field.

Table Structure:

  • ) ENGINE = InnoDB AUTO_INCREMENT = 956DEFAULTCHARSET = utf8'
  • The table contains certain data.

    Now I want to extract the author of the field name from the database and then use the name (author) as a Field Layout. Then I can extract the name from the database and splice it with languages, however, mysql functions can be directly spliced here.

  • Returned data 'Wolf (Liu yongsheng )'

    This is the case. The processing in mysql is still relatively fast.

    I won't bother here with arithmetic calculation.

    Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.