mysql missing select,mysql-无法使用select *获取所有列

I have following 2 tables t1, t2

CREATE TABLE t1 (

id INT PRIMARY KEY

);

CREATE TABLE t2 (

id INT PRIMARY KEY

);

INSERT INTO t1 VALUES (1),(2),(3);

INSERT INTO t2 VALUES (2),(3),(4);

I am running

select * from t1 left join t2 using(id);

Result:

+----+

| id |

+----+

| 1 |

| 2 |

| 3 |

+----+

On running script:

select t1.id, t2.id from t1 left join t2 using(id);

Result:

+----+------+

| id | id |

+----+------+

| 1 | NULL |

| 2 | 2 |

| 3 | 3 |

+----+------+

select * is supposed to return all the columns, so, why I am not getting 2 rows when I am using select *?

Note: I am using Mysql

解决方案

Natural joins and joins with USING, including outer join variants, are processed according to the SQL:2003 standard:

Redundant columns of a NATURAL join do not appear. Consider this set of statements:

CREATE TABLE t1 (i INT, j INT);

CREATE TABLE t2 (k INT, j INT);

INSERT INTO t1 VALUES(1, 1);

INSERT INTO t2 VALUES(1, 1);

SELECT * FROM t1 JOIN t2 USING (j);

column j is named in the USING clause and should appear only once in the output, not twice.