分布式NewSQL数据库TiDB
4539s 428.3505s total number of events 10000000 10000000 10000000 10000000 10000000 延时latency min(ms) 1.10 2.23 39.18 0.95 1.18 延时latency avg(ms) 8.20 18.09 172.39 3.55 21.93 延时latency max(ms) 3103.19 11240 码力 | 120 页 | 7.42 MB | 5 月前3TiDB v6.5 Documentation
affected (0.00 sec) In this example, you can find the query result in /tmp/tmp_file1 as follows: 1 a 1.10 2 b 2.20 3 c 3.30 Example 2: mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file2' FIELDS TERMINATED (0.00 sec) In this example, you can find the query result in /tmp/tmp_file2 as follows: "1","a","1.10" "2","b","2.20" "3","c","3.30" Example 3: mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file3' sec) 3666 In this example, you can find the query result in /tmp/tmp_file3 as follows: '1','a','1.10'<<< '2','b','2.20'<<< '3','c','3.30'<<< 14.11.2.81.4 MySQL compatibility • The syntax SELECT ..0 码力 | 5282 页 | 99.69 MB | 1 年前3TiDB v7.1 Documentation
affected (0.00 sec) In this example, you can find the query result in /tmp/tmp_file1 as follows: 1 a 1.10 2 b 2.20 3 c 3.30 Example 2: mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file2' FIELDS TERMINATED (0.00 sec) In this example, you can find the query result in /tmp/tmp_file2 as follows: "1","a","1.10" "2","b","2.20" "3","c","3.30" Example 3: mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file3' sec) 3852 In this example, you can find the query result in /tmp/tmp_file3 as follows: '1','a','1.10'<<< '2','b','2.20'<<< '3','c','3.30'<<< 14.11.2.85.4 MySQL compatibility • The syntax SELECT ..0 码力 | 5716 页 | 104.74 MB | 1 年前3TiDB v7.6 Documentation
affected (0.00 sec) In this example, you can find the query result in /tmp/tmp_file1 as follows: 1 a 1.10 2 b 2.20 3 c 3.30 Example 2: 4035 mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file2' FIELDS (0.00 sec) In this example, you can find the query result in /tmp/tmp_file2 as follows: "1","a","1.10" "2","b","2.20" "3","c","3.30" Example 3: mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file3' (0.00 sec) In this example, you can find the query result in /tmp/tmp_file3 as follows: '1','a','1.10'<<< '2','b','2.20'<<< '3','c','3.30'<<< 14.13.2.92.4 MySQL compatibility • The syntax SELECT ..0 码力 | 6123 页 | 107.24 MB | 1 年前3TiDB v7.5 Documentation
affected (0.00 sec) In this example, you can find the query result in /tmp/tmp_file1 as follows: 1 a 1.10 2 b 2.20 3 c 3.30 Example 2: 3997 mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file2' FIELDS (0.00 sec) In this example, you can find the query result in /tmp/tmp_file2 as follows: "1","a","1.10" "2","b","2.20" "3","c","3.30" Example 3: mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file3' (0.00 sec) In this example, you can find the query result in /tmp/tmp_file3 as follows: '1','a','1.10'<<< '2','b','2.20'<<< '3','c','3.30'<<< 14.13.2.92.4 MySQL compatibility • The syntax SELECT ..0 码力 | 6020 页 | 106.82 MB | 1 年前3TiDB v7.1 中文手册
'/tmp/tmp_file1'; Query OK, 3 rows affected (0.00 sec) 在此示例中,你可以在 /tmp/tmp_file1 中看到以下查询结果: 1 a 1.10 2 b 2.20 3 c 3.30 示例 2: mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file2' FIELDS TERMINATED ENCLOSED BY '"'; Query OK, 3 rows affected (0.00 sec) 在此示例中,你可以在 /tmp/tmp_file2 中看到以下查询结果: "1","a","1.10" "2","b","2.20" "3","c","3.30" 示例 3: mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file3' -> BY '<<<\n'; Query OK, 3 rows affected (0.00 sec) 在此示例中,你可以在 /tmp/tmp_file3 中看到以下查询结果: '1','a','1.10'<<< '2','b','2.20'<<< '3','c','3.30'<<< 3032 14.11.2.85.4 MySQL 兼容性 • 不支持 SELECT ... INTO @variable0 码力 | 4369 页 | 98.92 MB | 1 年前3TiDB v8.1 Documentation
affected (0.00 sec) In this example, you can find the query result in /tmp/tmp_file1 as follows: 1 a 1.10 2 b 2.20 3 c 3.30 Example 2: mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file2' FIELDS TERMINATED (0.00 sec) In this example, you can find the query result in /tmp/tmp_file2 as follows: "1","a","1.10" "2","b","2.20" "3","c","3.30" Example 3: mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file3' sec) 4118 In this example, you can find the query result in /tmp/tmp_file3 as follows: '1','a','1.10'<<< '2','b','2.20'<<< '3','c','3.30'<<< 14.13.2.93.4 MySQL compatibility • The syntax SELECT ..0 码力 | 6321 页 | 107.46 MB | 1 年前3TiDB v6.5 中文手册
'/tmp/tmp_file1'; Query OK, 3 rows affected (0.00 sec) 在此示例中,你可以在 /tmp/tmp_file1 中看到以下查询结果: 1 a 1.10 2 b 2.20 3 c 3.30 示例 2: mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file2' FIELDS TERMINATED ENCLOSED BY '"'; Query OK, 3 rows affected (0.00 sec) 在此示例中,你可以在 /tmp/tmp_file2 中看到以下查询结果: "1","a","1.10" "2","b","2.20" "3","c","3.30" 示例 3: mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file3' -> BY '<<<\n'; Query OK, 3 rows affected (0.00 sec) 在此示例中,你可以在 /tmp/tmp_file3 中看到以下查询结果: '1','a','1.10'<<< '2','b','2.20'<<< '3','c','3.30'<<< 14.11.2.81.4 MySQL 兼容性 • 不支持 SELECT ... INTO @variable0 码力 | 4049 页 | 94.00 MB | 1 年前3TiDB v8.0 Documentation
(0.00 sec) In this example, you can find the query result in /tmp/tmp_file1 as follows: 4151 1 a 1.10 2 b 2.20 3 c 3.30 Example 2: mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file2' FIELDS TERMINATED (0.00 sec) In this example, you can find the query result in /tmp/tmp_file2 as follows: "1","a","1.10" "2","b","2.20" "3","c","3.30" Example 3: mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file3' (0.00 sec) In this example, you can find the query result in /tmp/tmp_file3 as follows: '1','a','1.10'<<< '2','b','2.20'<<< '3','c','3.30'<<< 14.13.2.93.4 MySQL compatibility • The syntax SELECT ..0 码力 | 6327 页 | 107.55 MB | 1 年前3TiDB v8.5 Documentation
affected (0.00 sec) In this example, you can find the query result in /tmp/tmp_file1 as follows: 1 a 1.10 2 b 2.20 3 c 3.30 Example 2: 4275 mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file2' FIELDS (0.00 sec) In this example, you can find the query result in /tmp/tmp_file2 as follows: "1","a","1.10" "2","b","2.20" "3","c","3.30" Example 3: mysql> SELECT * FROM t INTO OUTFILE '/tmp/tmp_file3' (0.00 sec) In this example, you can find the query result in /tmp/tmp_file3 as follows: '1','a','1.10'<<< '2','b','2.20'<<< '3','c','3.30'<<< 14.12.2.83.4 MySQL compatibility • The syntax SELECT ..0 码力 | 6730 页 | 111.36 MB | 9 月前3
共 21 条
- 1
- 2
- 3