[MonetDB-users] Insert query into second database

Seleen seleen666 at hotmail.com
Mon Oct 17 16:22:06 CEST 2011


Hello, 
I have two databases  "mydb" and "test".

I want to get a sub-set of values from 'mydb' into 'test'.

My code:

"insert into test.result 
select sum(chargfeeprepaid) from mydb.data where callingpartyno = 200
union 
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?

Greetings Seleen

-- 
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 mailing list