时间：2021-07-01 10:21:17 帮助过：2人阅读
mysql> select concat(‘Hadoop:‘,‘Hive:‘,‘Spark#‘,‘HBase;‘,TBL_TYPE,‘{}‘,SD_ID) from TBLS;
| Hadoop:Hive:Spark#HBase;MANAGED_TABLE{}6 |
| Hadoop:Hive:Spark#HBase;MANAGED_TABLE{}7 |
| Hadoop:Hive:Spark#HBase;MANAGED_TABLE{}12 |
mysql> select concat_ws(‘:‘,‘Hadoop‘,‘Hive‘,‘Spark‘,‘HBase‘,TBL_TYPE,SD_ID) from TBLS;
| Hadoop:Hive:Spark:HBase:MANAGED_TABLE:6 |
| Hadoop:Hive:Spark:HBase:MANAGED_TABLE:7 |
| Hadoop:Hive:Spark:HBase:MANAGED_TABLE:12 |
MySQL字符串连接
标签：