Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> use test;
- Database changed
- mysql> select * from t1;
- +----+------+
- | id | val |
- +----+------+
- | 1 | 100 |
- | 2 | 200 |
- +----+------+
- 2 rows in set (0.00 sec)
- mysql> select * from t2;
- +----+-------+
- | id | val |
- +----+-------+
- | -1 | -1000 |
- | 1 | 1000 |
- | 3 | 3000 |
- +----+-------+
- 3 rows in set (0.00 sec)
- mysql> create or replace view iid as select id from t1 union select id from t2;select iid.id,t1.val,t2.val from iid left join t1 on iid.id=t1.id left join t2 on iid.id=t2.id;
- Query OK, 0 rows affected (0.07 sec)
- +----+------+-------+
- | id | val | val |
- +----+------+-------+
- | 1 | 100 | 1000 |
- | 2 | 200 | NULL |
- | -1 | NULL | -1000 |
- | 3 | NULL | 3000 |
- +----+------+-------+
- 4 rows in set (0.00 sec)
- >> sqlCmd = ['create or replace view iid as select id from t1 union select id from t2;',...
- 'select iid.id,t1.val,t2.val from iid',...
- ' left join t1 on iid.id=t1.id',...
- ' left join t2 on iid.id=t2.id'];
- conn = database('test','root','198471',...
- 'com.mysql.jdbc.Driver','jdbc:mysql://127.0.0.1:3306/test');
- >> curs = exec(conn,sqlCmd);
- >> curs.Message
- ans =
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select iid.id,t1.val,t2.val from iid left join t1 on iid.id=t1.id left join t2 o' at line 1
- >> curs = exec(conn,'select * from t1');
- >> curs = fetch(curs);
- >> curs.Data
- ans =
- 1 100
- 2 200
- >> sqlCmd
- sqlCmd = 'create or replace view iid as select id from t1 union select id from t2;select iid.id,t1.val,t2.val from iid left join t1 on iid.id=t1.id left join t2 on iid.id=t2.id;';
- curs = exec(conn,sqlCmd);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement