Tags:Database Questions | 95 views
I have a query SELECT radcheck.id, radcheck.UserName, radcheck.epost, radcheck.fylke, MAX( radacct.AcctStopTime ) AS AcctStopTime FROM radcheck LEFT JOIN radacct ON radcheck.UserName LIKE radacct.UserName WHERE AcctStopTime LIKE ‘%2009-03-19%’ GROUP BY radcheck.id I’m looking for a way to use wilcards, > <, NOT LIKE etc on only the highest date value AcctStopTime in the radacct table. The [...]
Tags:Database Questions | 91 views
Hi, I have mysql database dump xxx.sql How can i convert xxx.sql to xxx.csv? Thanks
Tags:Database Questions | 54 views
I have a registration page that needs one final thing and I’m a little stumped… In one table I have email, pass, gender, dob and the other I have company… In the registration page, I want to check that the company exists before I submit the form… Since I’m using tools for this and NOT [...]
Tags:Database Questions | 39 views
I’m looking forwards to attend such course: http://unex.uci.edu/certificates/it/…db/courses.asp.. look at the dates and time. Its quite intensive, my question: will i have a chance to write notes, because obviously i can remember all what i’m going to learn in one class, there must be my reference to review. Otherwise, it could be a waste of [...]