LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 12-04-2009, 11:04 AM   #1
whittycat
Member
 
Registered: Nov 2004
Location: Wellington Somerset UK
Distribution: Debian lenny, also DSL-N
Posts: 32

Rep: Reputation: 15
Mysql and GUI for data input


I have several years experience with Oracle and SQLPlus and I am now starting to use Mysql in Debian Lenny. I created a database, then created a table and practised a few queries and it all seems fine but I can't find anything equivalent to Oracle's SQLForms. This let you display the table contents in a window and make changes, insert new records and so on. There is Mysql GUI tools but as far as I can see the Query Browser only does select. Why can't it do insert as well? I may have overlooked something but if I am right could you please tell me what GUI you can recommend that does data input, etc? There are quite a few freeware suites that look promising but I don't know which one to go for. Should I learn Ruby do you think?
 
Old 12-04-2009, 12:17 PM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 19,319

Rep: Reputation: 4470Reputation: 4470Reputation: 4470Reputation: 4470Reputation: 4470Reputation: 4470Reputation: 4470Reputation: 4470Reputation: 4470Reputation: 4470Reputation: 4470
Quote:
Originally Posted by whittycat View Post
I have several years experience with Oracle and SQLPlus and I am now starting to use Mysql in Debian Lenny. I created a database, then created a table and practised a few queries and it all seems fine but I can't find anything equivalent to Oracle's SQLForms. This let you display the table contents in a window and make changes, insert new records and so on. There is Mysql GUI tools but as far as I can see the Query Browser only does select. Why can't it do insert as well? I may have overlooked something but if I am right could you please tell me what GUI you can recommend that does data input, etc? There are quite a few freeware suites that look promising but I don't know which one to go for. Should I learn Ruby do you think?
Well, learning Ruby (or Perl, C, etc.), is never a bad idea...increasing your knowledge never hurts.

That said, you might want to check out MySQL Workbench, which may do what you're looking for. You might also want to check out phpMyAdmin, which is a web-based tool. I haven't used that in years, though..MySQL Adminstrator does a good job, and is a bit easier to run, in my opinion..
 
Old 12-04-2009, 12:58 PM   #3
mlev
LQ Newbie
 
Registered: Dec 2009
Posts: 10

Rep: Reputation: 1
phpMyAdmin will let you insert records as well as query.
 
Old 12-04-2009, 03:44 PM   #4
Elv13
Member
 
Registered: Apr 2006
Location: Montreal,Quebec
Distribution: Gentoo
Posts: 825

Rep: Reputation: 128Reputation: 128
MySQL admin allow table editing and data insertion. PHPmyAdmin does too, even if its lower end and target causual users.
 
Old 12-09-2009, 11:41 AM   #5
whittycat
Member
 
Registered: Nov 2004
Location: Wellington Somerset UK
Distribution: Debian lenny, also DSL-N
Posts: 32

Original Poster
Rep: Reputation: 15
Thanks for all this. MySQLAdmin (Navicat) looks as if it will do everything I want. phpMyAdmin will also; it is a little cheaper but may be more trouble to set up. I liked the interactive demo. MySQL Workbench looks nice too. So I have an embarrassment of choice. There are even more admin tools out there, reviewed in http://tinyurl.com/cdf6bt
(which includes Workbench, phpMyQAdmin and Navicat Lite). I'll get on to it right away. .
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Perl: Want to compare CGI input with data from a MySQL table resetreset Programming 1 11-20-2008 07:58 AM
Processing data from a 'foreign' database with mysql, or tools to pre-process data. linker3000 Linux - Software 1 08-14-2007 09:36 PM
ran out of input data xushi Slackware 11 03-02-2006 07:36 PM
Bash: Data Input Verification Help! Vozx Programming 4 12-04-2005 08:23 PM
ran out of input data? Sn1PeR Red Hat 2 09-16-2003 05:06 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 03:25 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration