练习mysql的基础语法

查询整张表

SELECT * FROM it_info;

like 字句使用

SELECT id,salary,jobName
FROM it_info
WHERE jobName LIKE '%Java%';

GROP BY字句使用

SELECT jobName,AVG(salary),MAX(salary),MIN(salary)
FROM it_info
GROUP BY jobName;

DELETE字句使用

DELETE FROM it_info WHERE jobName LIKE '%java%';

**UPDATE 字句使用

UPDATE it_info SET salary = '5k' WHERE id =49;

插入练习 这里就不插入全部数据了

INSERT INTO it_info(id,jobName) VALUES('3983','hahah');

基本的查询语句如上