No subject

C:\WINDOWS>mysql -u [USERNAME] -p  (put in your Koha database username
where the brackets are)
Enter password at the prompt.

mysql>show databases;  (make sure to include the semicolon at the end)

Look for koha or koha229

mysql>use koha229; (or the name of your koha database)
mysql>show tables;

Look for the table that you are working on.  They have good names so
it shouldn't be hard.  You can see what is contained in a table with
the "describe" command, for example:

mysql>describe items;

to see the column names and properties for the items table.  If you
want to check that something is in that table, look at a column or
two, for example:

mysql>select barcode from items;

or

mysql>select itemnumber, itemcallnumber from items;

If you just have a few items in a table, you can look at the whole thing with

mysql>select * from items;

but that gets hairy real fast for biblio tables.  One warning with
looking at biblio records in mysql:  Koha stores MARC and non-MARC
versions of the same data for efficiency.  This is not a problem when
you just want to look at some data, but when you start trying to track
a field it gets harder.

Hope this helps!

--Betsy

On Mon, Aug 18, 2008 at 11:50 PM, nirmala82 <nirmala.wilson at gmail.com> wrote:
>
> Hi frenz,
> how to check the the database for the items included in front end.pls,can
> anyone help me to do,bcoz i need to do some updation in front end and shld
> be updated in database againt to chek its updation s good or not
> --
> View this message in context: http://www.nabble.com/how-to-check-the-the-database-for-the-items-included-in-front-end.pls-tp19045200p19045200.html
> Sent from the Koha - Win32 mailing list archive at Nabble.com.
>
> _______________________________________________
> Koha-win32 mailing list
> Koha-win32 at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-win32
>