MySQL Bugs: #1163: Really cool idea! MyBash

Bug #1163	Really cool idea! MyBash
Submitted:	29 Aug 2003 5:37	Modified:	1 Sep 2003 6:28
Reporter:	Are you mortal Then prepare to die.	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	in my mind	OS:	Linux (linux)
Assigned to:		CPU Architecture:	Any

Description:
Hello, I always wanted mysql to behave a bit like bash?,

I.E.

(bash like syntax)	(mysql equiv)

mysql> cd database;	(use database)
myslq> ls;		(show tables)
mysql> cd ..;		(? - no database seleced)
mysql> ls;		(show databases)

Given this principal it sould be possible to integrate mysql with
bash, so simply cd-ing into a special directory in the file system
would be like invoking mysql!

I.E. 

MySql is MOUNTED to a specific location in the directory tree!

Then...

(special mysql feature)		( bash equiv )

bash > cd /mysql                ( mysql -u -p -h etc... )

From within this directory we can now issue queries.

This would be so cool, and I think you could do it quite
easily!

Along these lines, why not make the whole file system based on mysql?
I.E. We can issue shell like mysql queries in any directory, in order
to move files about etc (like using myPerl to make system calls with
tables of files / directory structure)

Cheers, 
Dan.

How to repeat:
let your imagination go bonkers

Suggested fix:
DO IT!!!

I just thought of some other stuff...

old-myslq> alter table old_table rename new_table
new-mysql> mv old_table new_table

etc etc... I.e. All db's = directories, all tables = files...
Then we just need a set of mappings i.e.

cat table == select * from table;
more table == select * from table; with a bit extra programming....

check

http://no.spam.ee/~tonu/modules.php?name=News&new_topic=2

looks similar to your idea - though a very different implementation