Getting the row number depends on the DB you're using; Oracle supports this (via ROWNUM) but MySQL for example does not.

Your statement is invalid; if you want to update a row you should be doing:...

Why revive a 2 year old thread?

create database medical_records;


Hope this helps.

Not any old book will do; please use "A Relational Model of Data for Large Shared Data Banks" by Dr Edgar F Codd.

In this case yes, normalisation is correct. Your statement though is not entirely true; especially when datawarehousing and complex searches come into play.

You have a problem because you are using a spreadsheet application for something that it was not designed to do. You should really be using a database.

UNIQUE is a constraint applied to tables that ensures that all values in the given columns are unique. If you try to insert a existing value the you will get an error (along the lines of 'insert...

I think you should use an 'status_id' column and have a table of statuses.

Also, I think you should have a subjects table and a benchmarks table (you have 1-10 but what if in 2 months they want...

I'm no slony expert but I think the latest versions of pgAdmin3 have slony stuff included. Did a quick google and came up with this (http://linuxfinances.info/info/slonyintro.html); you may have...

I use a whiteboard 95%.

In my office though most of the linux users use umbrello (http://uml.sourceforge.net/index.php) or dia (http://www.gnome.org/projects/dia/).

I've not used it but I've...

cars and stuff

hope this helps

I don't know the ins and outs of your hosting setup but I'd assume that it includes PHP/MySQL as it is very popular and free.

Here (http://www.freewebmasterhelp.com/tutorials/phpmysql/1) is a...

msdn (http://www.msdn.com). But I don't thinkyou have much hope

ALTER TABLE vw_my_view OWNER TO pty;

what format is the file in? csv?

tgreer is right. I recommend the book "PHP and MySQL Web Development", although I have an older copy. I'm sure there will be something at PC World, or definitely on amazon similar. There is a PHP...

xampp (http://www.apachefriends.org/en/xampp.html) is what you're after. It is a one click installer for mysql, php, apache and some other bits and pieces.

Once you've got that up and running it...

hi, if I were you I'd do a little research (http://en.wikipedia.org/wiki/Php) into PHP (http://www.php.net)/MySQL (http://www.mysql.com); hosting is cheap and there are lots of companies to choose...

glad to see a postgresql user

i think what you're after is:


bc_dev=# select current_date;
date
------------
2006-09-10
(1 row)

This (http://www.databaseanswers.org/data%5Fmodels/) should help

sqlite (http://www.sqlite.org/)?

this (http://db.grussell.org/ch4.html) should be of some use

I believe this (slony.info) is what you're looking for.

If you're using pgadmin then this (http://www.pgadmin.org/docs/1.4/slony-install.html) may also be of interest to you

you just described ms access

how could things mess up with timestamps?

i dont actually use the timestamp for versioning more for auditing; its the version number that keeps track of the revision of the document

hi - i know this is a bit late and you've probably sorted out this issue

my instinct would be to have a documents table and a revisions table

documents: id, title, summary.

revisions: id,...

your orders stuff needs looking at.

you assume that one person will order a quantity of one book on one order.

a better way to do it would be to have multiple order lines belonging to one...