i can see sql discussions are active so i'd like to
slip a quick query, off-topic. im currently migrating
php scripts from mysql to oracle, and just stepped on
few problems:
* how do i make an auto_increment field in oracle? im
familiar with mysql, but it turned out the
auto_increment keyword of mysql doesnt work in oracle.
* in oracle, how do i set a limit which rows to return
from a select, like from the fifth row to the tenth
only (in ranges of 5 rows)? in mysql, i do:
select * from t where id='some_criteria' limit 4,10;
thanks!
christie
thanks.
--- Systems Administrator <[EMAIL PROTECTED]>
wrote:
> how do you do a multiple query in mysql?
>
> mysql_query ("SELECT * FROM databasename ......
> ..... WHERE AND OR?
>
> I have this database via web but I don't know how to
> get more than 2
> entries the example on devshed only has firstname
> and last name. what if
> i would like to add more like address or sex or
> email addy.? please help
> thanks.
>
>
> _
> Philippine Linux Users Group. Web site and archives
> at http://plug.linux.org.ph
> To leave: send "unsubscribe" in the body to
[EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
http://im.yahoo.com/
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
