题目内容

以下哪一条命令可以用于创建数据库表?

A. INSERT
B. CREATE
C. UPDATE
DROP

查看答案
更多问题

使用如下命令后,如何往表中插入一条userid=1,username=“angel”, password=“angel”的数据信息?CREATE TABLE users(userid int(11) NOT NULL AUTO_INCREMENT, username varchar(20) NOT NULL DEFAULT "", password varchar(20) NOT NULL DEFAULT "", PRIMARY KEY(userid))TYPE=MyISAM AUTO_INCREMENT=3;

A. INSERT INTO user VALUES(2, "lblis", "yourpass");
B. INSERT INTO user VALUES(1, "angel", "mypass");
C. INSERT INTO users VALUES(1, "angel", "mypass");
D. select * from user;

实验中,URL中提交:http://本机IP/access.php?username=angel&password=mypassWeb页面会提示“登录成功”。此时PHP的脚本中具体的SQL查询语句:

A. SELECT * FROM user WHERE username='$username' AND password='$password'
B. SELECT * FROM user WHERE username='$angel' AND password='$mypass'
C. SELECT * FROM user WHERE username='angel' AND password='mypass'
D. 以上都错

实验中,在URL地址栏中提交哪一项会注入不成功

A. http://本机IP/access.php?username=angel'%23
B. http://本机IP/access.php?username=angel'%2F%2A
C. http://本机IP/access.php?username=angel' or‘1=1
D. http://本机IP/access.php?username=angel' or 1=1

在注入实现导出文件中,可在etc目录下成功导出包含用户名和密码文件temp.txt的注入语句是?

A. http://本机IP/access.php?username=angel&password=' or '1=1' INTO OUTFILE '/etc/temp.txt
B. http://本机IP/access.php?username=&password=' or userid='1'INTO OUTFILE '/etc/temp.txt
C. http://本机IP/access.php?username=&password=' or '1=1' INTO OUTFILE '/etc/temp.txt
D. 以上都可以。

答案查题题库