Re: [MonetDB-users] MonetDB vs MySQL command list

On 15-05-2009 12:36:19 +0100, Tom H wrote:

Mysql command:SHOW TABLES;

shell> mclient -lsql --database=test1 sql>sql>select * from tables where system = false;

Try \d

I've not yet noted what the direct equivilents of these commands are; DESCRIBE TABLE; SHOW CREATE TABLE;

Try \d table

GRANT ALL PRIVILEGES ON DATABASENAME.* to SOMEONE@localhost IDENTIFIED BY "PASSWORD";

CREATE USER "SOMEONE" WITH PASSWORD 'PASSWORD' NAME 'Someone' SCHEMA "sys";

mysqldump --opt -u username -p database > database_backup.sql mysql -u username -p database < database_backup.sql

msqldump & mclient?

And I'm not entirely clear how a schema works, I'm guessing similar to the oracle model.

And PostgreSQL.