Forum: Database Design Jun 5th, 2009 |
| Replies: 1 Views: 466 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:... |
Forum: Database Design Sep 15th, 2008 |
| Replies: 7 Views: 2,449 Why revive a 2 year old thread? |
Forum: Database Design Apr 18th, 2007 |
| Replies: 2 Views: 9,342 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... |
Forum: Database Design Jul 12th, 2006 |
| Replies: 7 Views: 2,449 sqlite (http://www.sqlite.org/)? |