Gossamer Forum
Home : General : Databases and SQL :

Did anyone know ...

Quote Reply
Did anyone know ...
a Comand Line Editor for MySQL Databases running on Linux ?
Like the Midnight Commander for Files ?

Best Regards
Christian
Quote Reply
Re: [Schani] Did anyone know ... In reply to
>>
a Comand Line Editor for MySQL Databases running on Linux ?
<<

Mmm how about mysqladmin and mysql itself Sly

bash$ mysql -uUSERNAME -p DATABASE
Password:
mysql>

Last edited by:

Paul: Jan 2, 2003, 7:32 AM
Quote Reply
Re: [Paul] Did anyone know ... In reply to
Thats right, but i cant belive it that there is no mySQL Client for the Comand Line. I know there is PHPmyAdmin aso. But its not what im searching for.

ChristianUnsure
Quote Reply
Re: [Schani] Did anyone know ... In reply to
Hmm... the mysql program is a mysql client. It may not be as simple as myPHPadmin but it allows you to type SQL statements and see the results.

Code:
bash-2.05a$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.49

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use links211;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select count(*) from lsql_Links;
+----------+
| count(*) |
+----------+
| 2 |
+----------+
1 row in set (0.02 sec)

mysql>