u011644858的博客

1.连接SQLmysql -uroot -p2.创建数据库create database python3 charset=utf8;3.显示数据库 show databases;4.切换到当前数据库use python3;

https://leetcode.com/problems/second-highest-salary/description/Write a SQL query to get the second highest salary from the Employee table. +—-+——–+ | Id | Salary | +—-+——–+ | 1 | 100 | | 2

31、查询所有教师和同学的name、sex和birthday.select students.sname,students.ssex,students.sbirthday,teachers.TNAME,teachers.TSEX,teachers.TBIRTHDAY from students inner join teachersSELECT Sname,Ssex,Sbirthday