20180926-MySQL-Practice

连接远程服务器

~ mysql --host=10.204.20.107 --user=guest --password

练习

mysql> use demo;
mysql> show databases;
mysql> show tables;
mysql> SELECT * FROM `group`;
mysql> SELECT * FROM student where name = LiuYanPing;
mysql> SELECT student.name FROM student WHERE student.gender = 'MALE' AND student.group_id = 2;
mysql> SELECT * FROM student ORDER BY group_id;
mysql> SELECT student.name, student.gender, student.age FROM student ORDER BY age DESC;
mysql> SELECT * FROM student ORDER BY student.age DESC, student.group_id ASC, student.name DESC;
mysql> SELECT * FROM student ORDER BY student.age DESC, student.group_id ASC, student.name DESC LIMIT 5;
mysql> SELECT student.gender, COUNT(student.gender) FROM student GROUP BY student.gender;
mysql> SELECT student.gender, COUNT(student.id) as count FROM student GROUP BY student.gender;
mysql> SELECT student.gender, COUNT(student.id) as amount FROM student GROUP BY student.gender;

查看表描述

mysql> desc table_name;

join

mysql> SELECT student.name AS studentName, group.name AS groupName FROM student JOIN `group` ON student.group_id = group.id;