MySQL

<% if 0 then %> <% end if %> <% fp_sQry="SELECT * FROM RoundRating WHERE (Topic1 LIKE '%MySQL%' AND Class = 709)" fp_sDefault="" fp_sNoRecords="Be the first person to rate this page. Click on the minute evaluation option below. " fp_sDataConn="healthsciencedb" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=1 fp_fTableFormat=False fp_fMenuFormat=False fp_sMenuChoice="CountOfLastOfID" fp_sMenuValue="CountOfLastOfID" fp_sColTypes="&Class=3&CountOfLastOfID=3&AvgRating=5&Topic1=202&" fp_iDisplayCols=3 fp_fCustomQuery=False BOTID=0 fp_iRegion=BOTID %>

<%=FP_FieldVal(fp_rs,"CountOfLastOfID")%> people have rated this page an average of <%=FP_FieldVal(fp_rs,"AvgRating")%> out of five stars. See their suggestions and questions.

Objectives
Presentations
Recently Asked Questions
Suggested improvements
More
Minute evaluation

Objectives

To learn about alternative databases

Presentations

There are several presentations for this lecture:

See instructions for how to download MySQL database
See slide for lecture on MySQL

Narrated slides and videos require Flash.

Recently Asked Questions

Ask a question and we will answer it within the next 48 hours. If you have no questions, please review the answer to the questions asked by others:

<% if 0 then %> <% end if %> <% fp_sQry="SELECT * FROM FAQ WHERE (Topic1 LIKE '%MySQL%' AND Answer IS NOT NULL AND IgnoreQ <> 1 AND Class = 709) ORDER BY Timestamp1 DESC" fp_sDefault="" fp_sNoRecords="No records returned." fp_sDataConn="healthsciencedb" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=50 fp_fTableFormat=False fp_fMenuFormat=False fp_sMenuChoice="Remains_Confusing1" fp_sMenuValue="Remains_Confusing1" fp_sColTypes="&Week=3&ID=3&QuestionID=3&IgnoreQ=3&Topic1=202&Email1=202&Remains_Confusing1=203&Answer=203&DateAnswer=135&Timestamp1=135&CollegeCode=202&Class=3&" fp_iDisplayCols=2 fp_fCustomQuery=False BOTID=3 fp_iRegion=BOTID %>

Question: <%=FP_FieldVal(fp_rs,"Remains_Confusing1")%> Answer: <%=FP_FieldVal(fp_rs,"Answer")%>

Suggested Improvements

<% if 0 then %> <% end if %> <% fp_sQry="SELECT * FROM MinuteEvaluation WHERE (How_to_Improve1 IS NOT NULL AND Topic1 LIKE '%MySQL%' AND Class = 709)" fp_sDefault="" fp_sNoRecords="No suggestions have been made to date. Be the first to help us improve. " fp_sDataConn="healthsciencedb" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=10 fp_fTableFormat=False fp_fMenuFormat=False fp_sMenuChoice="How_to_Improve1" fp_sMenuValue="How_to_Improve1" fp_sColTypes="&ID=3&Topic1=202&Email1=202&How_to_Improve1=203&Rating1=5&Remote_computer_name1=202&User_name1=202&Browser_type1=202&Timestamp1=135&Class=3&CollegeCode=202&" fp_iDisplayCols=1 fp_fCustomQuery=False BOTID=2 fp_iRegion=BOTID %>

Comment: <%=FP_FieldVal(fp_rs,"How_to_Improve1")%>

See use of MySQL to maintain an online database for differential gene expression.
Creating web pages using MySQL