CREATE TABLE q1(id int(6) NOT NULL AUTO_INCREMENT,PRIMARY KEY (id),name CHAR(20));
INSERT INTO q1(name) VALUES('name1');
INSERT INTO q1(name) VALUES('name2');
INSERT INTO q1(name) VALUES('name3');
INSERT INTO q1(name) VALUES('name4');
INSERT INTO q1(name) VALUES('name5');CREATE TABLE q2(id int(6) NOT NULL,name CHAR(20));
INSERT INTO q2(id,name) VALUES(1,'name1');
INSERT INTO q2(id,name) VALUES(1,'name11');
INSERT INTO q2(id,name) VALUES(1,'name111');
INSERT INTO q2(id,name) VALUES(1,'name1111');
INSERT INTO q2(id,name) VALUES(9,'name9');
INSERT INTO q2(id,name) VALUES(4,'name4');
INSERT INTO q2(id,name) VALUES(8,'name8');方法1:
SELECT one.*,two.* FROM q1 one,q2 two WHERE one.id=two.id;
方法2:
SELECT one.*,two.* FROM q1 one INNER JOIN q2 two WHERE one.id=two.id;
INSERT INTO q1(name) VALUES('name1');
INSERT INTO q1(name) VALUES('name2');
INSERT INTO q1(name) VALUES('name3');
INSERT INTO q1(name) VALUES('name4');
INSERT INTO q1(name) VALUES('name5');CREATE TABLE q2(id int(6) NOT NULL,name CHAR(20));
INSERT INTO q2(id,name) VALUES(1,'name1');
INSERT INTO q2(id,name) VALUES(1,'name11');
INSERT INTO q2(id,name) VALUES(1,'name111');
INSERT INTO q2(id,name) VALUES(1,'name1111');
INSERT INTO q2(id,name) VALUES(9,'name9');
INSERT INTO q2(id,name) VALUES(4,'name4');
INSERT INTO q2(id,name) VALUES(8,'name8');方法1:
SELECT one.*,two.* FROM q1 one,q2 two WHERE one.id=two.id;
方法2:
SELECT one.*,two.* FROM q1 one INNER JOIN q2 two WHERE one.id=two.id;
解决方案 »
- 我使用sql语句修改了表格里的数据时忘记写条件啦,结果整个表的数据都改了,怎么挽回
- count语句高难度
- 遇到的面试题 没做出来`郁闷的很
- unixodbc 和microsoft odbc 的接口到底是不是一致的?
- 公司数据库用MYSQL,大家给点资料,帮帮我呀
- 请推荐一本MYSQL较高版本的书,适合初学者,但要有一定参考价值,谢谢!
- linux下的mysql
- mysql cluster的等待事件Waiting for ndbcluster global schema lock
- 有没有count_max之类的方法
- MYSQL 统计次数的语句怎么写,谢谢!
- Postgres9.0.4可以做群集和负载平衡吗
- 设置列约束中有NOT NULL,为什么还是可以向里面插入空值??
SELECT one.*,two.* FROM q1 one INNER JOIN q2 two on one.id=two.id;应该是一样的,SQL标准不同而已,都是内连接