[MonetDB-users] How do I access new database?
It's been a while since I used SQL. I created a database using CREATE SCHEMA CAT1; I thought I used to use USE CAT1; to get into a database, but MonetDB did not like it. I confirmed creation of the schema with SELECT * FROM SCHEMAS; What am I doing wrong? Zoltan Tomory zoltan.tomory@mobot.org
Zoltan Tomory wrote:
It’s been a while since I used SQL. SQL is not identical to e.g. MySQL interpretation.
I created a database using CREATE SCHEMA CAT1;
I thought I used to use USE CAT1; to get into a database, but MonetDB did not like it.
No, you simply connect to a server dedicated to handling a specific database. See the examples in http://monetdb.cwi.nl/projects/monetdb/SQL/QuickTour/index.html and http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/MAPI-Client.html#MA...
I confirmed creation of the schema with SELECT * FROM SCHEMAS;
What am I doing wrong?
Zoltan Tomory
zoltan.tomory@mobot.org mailto:zoltan.tomory@mobot.org
------------------------------------------------------------------------
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/
------------------------------------------------------------------------
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Martin Kersten -
Zoltan Tomory