微客导航 » 文章资讯 » 如何在MySQL中创建制表符分隔的Select语句？

如何在MySQL中创建制表符分隔的Select语句？

2024-05-13 19:40:01 329

要创建制表符分隔的select语句，可以使用CONCAT()MySQL中的function。以下是语法：

select concat(yourColumnName1,"\t",yourColumnName2) AS anyAliasName from yourTableName;

让我们首先创建一个表：

mysql> create table DemoTable
(
   Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
   FirstName varchar(20),
   LastName varchar(20)
);

以下是使用insert命令在表中插入记录的查询：

mysql> insert into DemoTable(FirstName,LastName) values('John','Smith');
mysql> insert into DemoTable(FirstName,LastName) values('Carol','Taylor');
mysql> insert into DemoTable(FirstName,LastName) values('John','Doe');
mysql> insert into DemoTable(FirstName,LastName) values('David','Miller');

以下是使用select命令显示表中记录的查询：

mysql> select *from DemoTable;

这将产生以下输出

+----+-----------+----------+
| Id | FirstName | LastName |
+----+-----------+----------+
|  1 | John      | Smith    |
|  2 | Carol     | Taylor   |
|  3 | John      | Doe      |
|  4 | David     | Miller   |
+----+-----------+----------+
4 rows in set (0.00 sec)

以下是创建制表符分隔的select语句的查询：

mysql> select concat(FirstName,"\t",LastName) AS Tab_Delimited_Demo from DemoTable;

这将产生以下输出：

+--------------------+
| Tab_Delimited_Demo |
+--------------------+
| John Smith         |
| Carol Taylor       |
| John Doe           |    
| David Miller       |
+--------------------+
4 rows in set (0.00 sec)

返回顶部
3162201930
czq8825@qq.com

如何在MySQL中创建制表符分隔的Select语句？

热门推荐

随机推荐