Category Archives: sql

How to check for EOF in MySQL

Posted on January 4, 2011 by admin

In ASP, I can check for an End-Of-File condition by using rs.EOF     ‘ returns True or False For example, if I’m verifying if a certain UserName exists in the database, I can do a SELECT * FROM query, and check … Continue reading →

Posted in sql | Comments Off on How to check for EOF in MySQL

Mirosoft SQL Server vs. MySQL Server

Posted on January 2, 2011 by admin

Note to self: Minor difference between the TOP command in MSSQL and MySQL equivalent. — MS-SQL / SQL-Server SELECT TOP 10 * FROM ExampleTable WHERE Active = 1 ORDER BY Id DESC — MySQL SELECT * FROM ExampleTable WHERE Active = … Continue reading →

Posted in sql | Tagged , , | Comments Off on Mirosoft SQL Server vs. MySQL Server