Hello I am new to MYSQL and I need to know how I can call so many records from my MYSQL data base…
For Access I do this…
("SELECT Top 5 * From CategoryFile ORDER BY FileDate DESC")
and when I connect my MYSQL up to it I get this error
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[MySQL][ODBC 3.51 Driver][mysqld-3.23.53-max-nt]You have an error in your SQL syntax near '5 * CategoryFile.
Can some one help me out so I call only 5 records form the MYSQL data base?
I am running this on a windows server.
Thanks
Rodney