Why do you have the water (run)____ all the time?
查看答案
以下哪一条命令可以用于创建数据库表?
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