[MonetDB-users] Insert query into second database
seleen666 at hotmail.com
Mon Oct 17 16:22:06 CEST 2011
I have two databases "mydb" and "test".
I want to get a sub-set of values from 'mydb' into 'test'.
"insert into test.result
select sum(chargfeeprepaid) from mydb.data where callingpartyno = 200
select sum(chargefeeprepaid) from mydb.sms where callingpartyno = 300;"
This works fine in MySQL...but in Monetdb i get the error: INSERT INTO: no
such scheme 'test'.
Where did i go wrong and what is the correct syntax to do this in monetdb?
View this message in context: http://old.nabble.com/Insert-query-into-second-database-tp32667556p32667556.html
Sent from the monetdb-users mailing list archive at Nabble.com.
More information about the users-list