如何在MySQL中创建制表符分隔的Select语句？
要创建制表符分隔的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)