Re: data entry GUI

2006-02-01 Thread Imran Chaudhry
On 2/1/06, THUFIR HAWAT [EMAIL PROTECTED] wrote:
 Just as there's MySQL Query Browser for queries and table design, is
 there a similar GUI front end for data entry?  I'm not building
 anything complex, just a simple database to muck with.  Is it easier
 to do data entry on a spreadsheet, then import the spreadsheet?  Seems
 a bit silly, but it seems to be either that or

I can't recommend a GUI data entry tool but the way I would do it is
to use a spreadsheet and save out as Tab-delimited format. Depending
on the data I might also rustle up a Perl program to create the data
automatically.

I would then use LOAD DATA INFILE statement or mysqlimport to get the
data into my tables. These methods are extremely quick for inserts and
will disable key updating etc.

Regards,
Imran

--
http://www.ImranChaudhry.info
MySQL Database Management  Design Services

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: data entry GUI

2006-02-01 Thread Ryan Stille
You can also install MyODBC and then hook an Excel spreadsheet into your
database.  Editing the spreadsheet will update data in your database.
This isn't a good solution if you are going to be creating new tables
often.  But for manipulating data in a known set of tables it's great.

-Ryan

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: data entry GUI

2006-02-01 Thread mysql

I have just caught the end of this topic, so  hope I'm not 
repeating something already mentioned.

What I do is enter my data into a plain text file, like 
this;

The questions are a bit dumb, just for testing purposes of 
course!


/* file: general-quizdata.sql */

/* data to populate general knowledge quiz tables */

use web_app_tester;

insert into question set
   question_text = 'What is the Capital of England?';

select @questionID := last_insert_id();

insert into answer set
   answer_text = 'London',
   status = 'right',
   questionID = @questionID;

insert into answer set
   answer_text = 'Paris',
   questionID = @questionID;

insert into answer set
   answer_text = 'Edinburgh',
   questionID = @questionID;


insert into question set
   question_text = 'How many yards are there in a mile?';

select @questionID := last_insert_id();

insert into answer set
   answer_text = '5000',
   questionID = @questionID;

insert into answer set
   answer_text = '1760',
   status = 'right',
   questionID = @questionID;

insert into answer set
   answer_text = '2500',
   questionID = @questionID;


insert into question set
   question_text = 'What are the 3 primary colors?';

select @questionID := last_insert_id();

insert into answer set
   answer_text = 'Red, Grey, Black',
   questionID = @questionID;

insert into answer set
   answer_text = 'Yellow, White, Blue',
   questionID = @questionID;

insert into answer set
   answer_text = 'Green, Blue, Red',
   status = 'right',
   questionID = @questionID;


insert into question set
   question_text = 'RAM is an acronym for?';

select @questionID := last_insert_id();

insert into answer set
   answer_text = 'Random Access Memory',
   status = 'right',
   questionID = @questionID;

insert into answer set
   answer_text = 'Read Access Memory',
   questionID = @questionID;

insert into answer set
   answer_text = 'Read And Memorise',
   questionID = @questionID;

/* data truncated here for brevity */

/* end of data */

and then load it into mysql from the mysql command 
prompt with:

mysql \. general-quizdata.sql

This may seem like the long-winded version of LOAD DATA, but 
it does make the syntax easier to understand, plus you can 
put any other mysql commands in the file. Also you have the 
data and commands available in a file, in case you have to 
reload the table from scratch again.

HTH

Keith

In theory, theory and practice are the same;
In practice they are not. 

On Wed, 1 Feb 2006, Ryan Stille wrote:

 To: mysql@lists.mysql.com
 From: Ryan Stille [EMAIL PROTECTED]
 Subject: RE: data entry GUI
 
 You can also install MyODBC and then hook an Excel spreadsheet into your
 database.  Editing the spreadsheet will update data in your database.
 This isn't a good solution if you are going to be creating new tables
 often.  But for manipulating data in a known set of tables it's great.
 
 -Ryan

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]