trying to figure out unique/distinct situation...

2008-12-14 Thread bruce
hey... got a quick situation where i'm trying to figure out how to do a unique/distinct so i get "two" (2) rows for the 'faculty_id'... so.. how can i get just two unique/distinct rows based on the faculty_id thanks mysql> select distinct f1_status.faculty_id, c1.cname, course1.cname, f1_

MySQL programming from *NIX to Windows

2008-12-14 Thread Miguel Cardenas
Hi list I am porting a *NIX MySQL application from Linux to Windows, it uses the C API (header files and libraries) that comes with the distribution package. My program is already working on Windows and just have to add the last part that is the MySQL support but have two doubts: The Windows zip/

RE : MediumBlob / phpMyAdmin / hex dumps Questions

2008-12-14 Thread Jacques Brignon
I wonder if you are doing the import with phpMySQL. It does not seem possible to import a large database with phpMySQL (or perhaps any php based utility?) on a local PC running windows without hitting various timeouts. I am dealing with large import by doing them directly using mysql at the comma