SQL Analysis Report

select id, name, salary, rank() over (order by salary desc) as salary_rank from users

users

select * from users where age > ?

users

select user()

create table users ( id int auto_increment primary key, name varchar(?), age int, city varchar(?), salary decimal(?,?) )

users

set global general_log=?

select * from users where id = ?

users

select city, count(*) as user_count from users group by city

users

select city, count(*) as user_count from users group by ；

users

select * from users where salary > (select avg(salary) from users)

users

select city, avg(age) as avg_age from users group by city

users

select count(*) as total_users from users

users

select * from users order by salary desc limit ?

users

show tables

select * from users where salary = (select max(salary) from users)

users

insert into users (name, age, city, salary) values(?+)

users

create database test

select @@version_comment limit ?

show databases

select * from users where salary > ?

users

select city, avg(salary) as avg_salary from users group by city

users

users

select * from users order by salary limit ?

users

select city, sum(salary) as total_salary from users group by city

users

admin@127.0.0.1 on using tls

select * from users u1 where salary = (select max(salary) from users u2 where u1.city = u2.city)

users

select id, name, city, salary, rank() over (partition by city order by salary desc) as city_salary_rank from users

users

select id, name, salary, salary - lag(salary) over (order by salary desc) as salary_diff from users

users

test

select database()

select avg(salary) as avg_salary from users

users

show variables like ?

select * from users where city = ? union select * from users where salary > ?

users