能够选取一个数据库功能所对应的函数有 A: mysqli_connect() B: mysqli_select_db() C: mysqli _error() D: mysqli_query()
能够选取一个数据库功能所对应的函数有 A: mysqli_connect() B: mysqli_select_db() C: mysqli _error() D: mysqli_query()
假设已经通过MySQLi扩展建立与数了据库的连接,连接对象是$mysqli。现在请写出代码:执行查询语句"SELECT * FROM student",然后输出查询结果的行数。 A: $result = $mysqli->query("SELECT * FROM student"); echo $mysqli->num_rows; B: $result = $mysqli->query("SELECT * FROM student"); echo $mysqli->$num_rows; C: $result = $mysqli->query("SELECT * FROM student"); echo $result->num_rows; D: $result = $mysqli->query("SELECT * FROM student"); echo $result->$num_rows;
假设已经通过MySQLi扩展建立与数了据库的连接,连接对象是$mysqli。现在请写出代码:执行查询语句"SELECT * FROM student",然后输出查询结果的行数。 A: $result = $mysqli->query("SELECT * FROM student"); echo $mysqli->num_rows; B: $result = $mysqli->query("SELECT * FROM student"); echo $mysqli->$num_rows; C: $result = $mysqli->query("SELECT * FROM student"); echo $result->num_rows; D: $result = $mysqli->query("SELECT * FROM student"); echo $result->$num_rows;
Python DB API 2.0 的事务提供了方法 包含( ) A: select B: rollback C: cursor D: execute
Python DB API 2.0 的事务提供了方法 包含( ) A: select B: rollback C: cursor D: execute
在学生选课数据库中,将所有选了课程‘DB’且分数在60~70分之间的学生的成绩增加百分之十,SQL语句为( ) A: UPDATE SC SET Grade=Grade*1.1 WHERE Cno=’DB’ AND Grade BETWEEN 60 AND 70; B: UPDATE SC SET Grade+=Grade*0.1 WHERE Cno=(Select Cno From Course WHERE Cname=’DB’) AND Grade >= 60 AND Grade <=70; C: UPDATE SC SET Grade=Grade*1.1 WHERE Cno=(Select Cno From Course WHERE Cname=’DB’) AND Grade <= 60 AND Grade >=70; D: UPDATE SC SET Grade=Grade*1.1 WHERE Cno IN (Select Cno From Course WHERE Cname=’DB’) AND Grade BETWEEN 60 AND 70;
在学生选课数据库中,将所有选了课程‘DB’且分数在60~70分之间的学生的成绩增加百分之十,SQL语句为( ) A: UPDATE SC SET Grade=Grade*1.1 WHERE Cno=’DB’ AND Grade BETWEEN 60 AND 70; B: UPDATE SC SET Grade+=Grade*0.1 WHERE Cno=(Select Cno From Course WHERE Cname=’DB’) AND Grade >= 60 AND Grade <=70; C: UPDATE SC SET Grade=Grade*1.1 WHERE Cno=(Select Cno From Course WHERE Cname=’DB’) AND Grade <= 60 AND Grade >=70; D: UPDATE SC SET Grade=Grade*1.1 WHERE Cno IN (Select Cno From Course WHERE Cname=’DB’) AND Grade BETWEEN 60 AND 70;
3个表即学生表S、课程表C和学生选课表SC,它们的结构如下: S(S#,SN,SEX,AGE,DEPT)C(C#,CN)SC(S#,C#,GRADE)其中:S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程号,CN为课程名,GRADE为成绩。检索选修课程名称为“DB”的男生中的最高成绩,正确的SELECT语句是____。 A: SELECT MAX(GRADE) FROM SC WHERE CN='DB’ AND SEX='男' B: SELECT MAX(GRADE) FROM SC,C,SWHERE CN='DB' AND SEX='男' C: SELECT MAX(GRADE) FROM SC,S WHERE SC D: =C E: AND CN='DB' AND SEX='男' F: SELECT MAX(GRADE) FROM SC,C,SWHERE SC G: =C H: AND SS I: =S.S J: AND CN='DB' AND SEX='男'
3个表即学生表S、课程表C和学生选课表SC,它们的结构如下: S(S#,SN,SEX,AGE,DEPT)C(C#,CN)SC(S#,C#,GRADE)其中:S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程号,CN为课程名,GRADE为成绩。检索选修课程名称为“DB”的男生中的最高成绩,正确的SELECT语句是____。 A: SELECT MAX(GRADE) FROM SC WHERE CN='DB’ AND SEX='男' B: SELECT MAX(GRADE) FROM SC,C,SWHERE CN='DB' AND SEX='男' C: SELECT MAX(GRADE) FROM SC,S WHERE SC D: =C E: AND CN='DB' AND SEX='男' F: SELECT MAX(GRADE) FROM SC,C,SWHERE SC G: =C H: AND SS I: =S.S J: AND CN='DB' AND SEX='男'
选择mysql数据库的函数是______ A: mysqli_connect(); B: mysqli_select_db(); C: mysqli_query(); D: mysqli_num_rows()
选择mysql数据库的函数是______ A: mysqli_connect(); B: mysqli_select_db(); C: mysqli_query(); D: mysqli_num_rows()
查看是否开启mysqli扩展,需要查看_____配置文件。
查看是否开启mysqli扩展,需要查看_____配置文件。
在下列php.ini的配置项中,哪一项可以开启MySQLi扩展() A: extension=mysql B: extension=mysqli C: extension=pdo_mysql D: extension=oracle
在下列php.ini的配置项中,哪一项可以开启MySQLi扩展() A: extension=mysql B: extension=mysqli C: extension=pdo_mysql D: extension=oracle
下面( )函数从结果集中取得一行记录,返回的只是数字索引数组。 A: mysqli_query B: mysqli_fetch_array C: mysqli fetch row D: mysqli fetch assoc
下面( )函数从结果集中取得一行记录,返回的只是数字索引数组。 A: mysqli_query B: mysqli_fetch_array C: mysqli fetch row D: mysqli fetch assoc
连接mysql数据库服务器的函数是什么? A: mysqli_query() B: mysqli_connect() C: mysqli_error() D: mysqli_select_db()
连接mysql数据库服务器的函数是什么? A: mysqli_query() B: mysqli_connect() C: mysqli_error() D: mysqli_select_db()