Re: Create Database - Load Data

>
> shell>  mclient
> Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased)
> Database: MonetDB v11.4.0, 'mTests_benchmarks_wisconsin'
> Type \q to quit, \? for a list of available commands
> auto commit mode: on
> sql>\?
> \?      - show this message
> \<file  - read input from file
> \>file  - save response in file, or stdout if no file is given
> \|cmd   - pipe result to process, or stop when no command is given
> \h      - show the readline history
> \t      - toggle timer
> \D table- dumps the table, or the complete database if none given.
> \d[Stvsfn]+ [obj] - list database objects, or describe if obj given
> \A      - enable auto commit
> \a      - disable auto commit
> \e      - echo the query in sql formatting mode
> \f      - format using a built-in renderer {csv,tab,raw,sql,xml}
> \w#     - set maximal page width (-1=unlimited, 0=terminal width,>0=limit to num)
> \r#     - set maximum rows per page (-1=raw)
> \L file - save client/server interaction
> \X      - trace mclient code
> \q      - terminate session
>
>
> On 6/2/11 8:18 AM, Lowterm wrote:
>>
>> Hi Martin,
>>
>> thanks for your reply but it can't help me. I could not find any example and
>> solution for my problem. I would like to import SQL-Tabels with contents to
>> MonetDB and not from MonetDB to a File to import in SQL. My SQL-File should
>> be invoked from MonetDB and the Tables with contents should be created
>> automatically in my database within MonetDB. Is that possible? I need a
>> example please.
>>
>> Thanks
>
>
> ------------------------------------------------------------------------------
> Simplify data backup and recovery for your virtual environment with vRanger.
> Installation's a snap, and flexible recovery options mean your data is safe,
> secure and there when you need it. Data protection magic?
> Nope - It's vRanger. Get your free trial download today.
> http://p.sf.net/sfu/quest-sfdev2dev
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@...
> https://lists.sourceforge.net/lists/listinfo/monetdb-users