Database Design

Questions about SQL

Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jan 2008

Posts: 54

Reputation: Xessa is an unknown quantity at this point

Solved Threads: 0

Xessa

Offline

Junior Poster in Training

Questions about SQL

Jun 5th, 2009

I want to get the row number of a specific row in the table.

Also is this legal?

Help with Code Tags

(Toggle Plain Text)

INSERT INTO (SELECT * FROM myTable WHERE mynumber=2) VALUES ........

•

Join Date: Oct 2005

Posts: 521

Reputation: pty is on a distinguished road

Solved Threads: 37

pty

Offline

Posting Pro

Re: Questions about SQL

Jun 5th, 2009

•

Originally Posted by Xessa

I want to get the row number of a specific row in the table.

Also is this legal?
Help with Code Tags

(Toggle Plain Text)
INSERT INTO (SELECT * FROM myTable WHERE mynumber=2) VALUES ........
INSERT INTO (SELECT * FROM myTable WHERE mynumber=2) VALUES ........

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:

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
UPDATE myTable SET foo = 'bar' WHERE mynumber = 2;
update myTable set foo = 'bar' where mynumber = 2;