Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > MySQL 创建计算字段 CONCAT

MySQL 创建计算字段 CONCAT

WBOY
Release： 2016-06-07 17:11:59
Original
970 people have browsed it

今天再复读Mysql手册的时候，看到一个平时忽略的函数拼接字段。其实就是简单的用mysql函数处理下字符串。计算字段这个平时还比较

今天再复读Mysql手册的时候，看到一个平时忽略的函数拼接字段。其实就是简单的用mysql函数处理下字符串。计算字段这个平时还比较常用，，但是拼接字段一直忽略，这里做个标记。

字段(filed) 基本上与列(column)的意思相同，经常互换使用，不过数据库列一般成为列，而术语字段通常在计算字段的连接上。

表结构:

  • ) ENGINE=InnoDB AUTO_INCREMENT=956 DEFAULT CHARSET=utf8' 

    • 表里面有一定的数据

    现在我想从数据库里面取出字段 书名 作者 然后 用 书名（作者） 作为一个字段排版 那么我可以从数据库里面分别取出来用语言拼接 ，但是这里可以直接用mysql的函数拼接 

  • 返回的数据   '狼道(刘永生)'

    这样的。这些在mysql里面处理还是比较快的。

    算数计算我这里就不罗嗦了。

    linux

    • Related labels：
    MySQL数据库教程 MySQL 创建计算字段 CONCAT
    source：php.cn
    Previous article：Oracle的substr函数的用法 Next article：PostgreSQL 9.1.3 发布
    Statement of this Website
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
    Latest Articles by Author
    Latest Issues
    Regular expression filter for MERN stack search boxes and checkboxes I'm trying to understand how the MERN stack works together by learning by doing, and I'm f...
    From 2024-04-06 14:53:12
    0
    1
    425
    Possibility to store ASP Classic code as string in MYSQL database Is it possible to store asp classic code into a MySQL database and have it execute the cod...
    From 2024-04-06 13:38:43
    0
    1
    358
    Problems with the connection between the face recognition terminal iVMS-4200 and the base The face recognition terminal iVMS-4200 displays an error when connecting to the mysql dat...
    From 2024-04-06 12:20:33
    0
    1
    347
    **Error type: Unable to iterate 'NoneType' object** I want to use ssh tunnel to access Mysql database. Unfortunately, the architecture of this...
    From 2024-04-06 10:26:38
    0
    1
    378
    How to populate an HTML table from a design-generated database table Very new to Ruby on Rails and design. I'm currently trying to fill out a table on an HTML ...
    From 2024-04-05 09:13:39
    0
    1
    2491
    Related Topics
    More>
    Popular Recommendations
    Popular Tutorials
    More>
    Related Tutorials
    Popular Recommendations
    Latest courses
    Latest Downloads
    More>
    Web Effects
    Website Source Code
    Website Materials
    Front End Template