SQL testing program

elainelaw · 10-27-2009, 10:57 PM

I have a winsql program that run on windows to query the data on the databse via ODBC , can advise is there samiliar program that is running on linux ? what I want to use sql command to query the data on the database .

Thanks in advance.

chrism01 · 10-27-2009, 11:09 PM

What database do you have on Linux? If MySQL, the online docs are here http://dev.mysql.com/doc/refman/5.0/en/. There is a cmd line tool http://dev.mysql.com/doc/refman/5.0/en/programs.html and you can also access it from various langs eg Perl uses DBI.pm http://search.cpan.org/~timb/DBI-1.609/DBI.pm & DBD::mysql.pm http://search.cpan.org/~capttofu/DBD...b/DBD/mysql.pm modules.
Usually part of the std build for Perl on Linux.

elainelaw · 10-28-2009, 12:04 AM

Quote:

Originally Posted by chrism01

What database do you have on Linux? If MySQL, the online docs are here http://dev.mysql.com/doc/refman/5.0/en/. There is a cmd line tool http://dev.mysql.com/doc/refman/5.0/en/programs.html and you can also access it from various langs eg Perl uses DBI.pm http://search.cpan.org/~timb/DBI-1.609/DBI.pm & DBD::mysql.pm http://search.cpan.org/~capttofu/DBD...b/DBD/mysql.pm modules.
Usually part of the std build for Perl on Linux.

thx reply,

the winsql have GUI to type the command and for administration , can advise which of these package have the GUI also ? thx

linuxlover.chaitanya · 10-28-2009, 12:23 AM

For mysql, there is phpmyadmin, which is a web based tool for mysql administration.

elainelaw · 10-28-2009, 12:41 AM

Quote:

Originally Posted by linuxlover.chaitanya

For mysql, there is phpmyadmin, which is a web based tool for mysql administration.

thx ,

But I am use mysql , I use ms sql , is it also applicable ?

Thx in advance.

linuxlover.chaitanya · 10-28-2009, 12:42 AM

Quote:

Originally Posted by elainelaw

thx ,

But I am use mysql , I use ms sql , is it also applicable ?

Thx in advance.

What do you mean? You are not too clear. Do you want to say you do not use mysql and use ms sql instead?

linuxlover.chaitanya · 10-28-2009, 12:49 AM

Found This which you can install on Linux and execute sql commands from Linux.