• 紫霞:至尊宝你终于来了”
    至尊宝:“姑娘,我,的确认识一个朋友叫至尊宝,他还有些话托一个叫紫霞仙子的人说,是不是你啊”
    紫霞:“至尊宝”
    至尊宝:“stop!我问是不是你!是不是是不是是不是说啊说啊说啊”
    紫霞:“是啊”
    至尊宝:“对了!他说,他已经回到从前的地方,还希望仙子你能够,早日找到一位如意郎君哪”
    紫霞:“你别跟我开玩笑啊,至尊宝”
    至尊宝:“我再说一次,我的名字叫做,齐 天 大 圣,不要再叫错了”

  • 课间作业1

    1//*[@text='基金' and @instance='9']
    2//*[contains(@resource-id,"indicator")]//*[@text='基金']

  • 安装的时候一直卡在这里

  • 查询全部信息

    SELECT * FROM employees

    查询100行员工信息

    SELECT * FROM employees LIMIT 100

    查询last_name姓Facello的信息

    SELECT * FROM employees where last_name="Facello"

    查询不是姓Facello并且员工号小于10020的员工,

    SELECT * FROM employees WHERE last_name <>"Facello" AND emp_no <10020

    查询雇佣时间大于2000年1月1日的员工名字,使用别名显示字段名为员工姓名

    SELECT last_name as ,first_name as  FROM employees WHERE hire_date >= '2000-01-01'

    查询女生并且姓是Pettey的信息

    SELECT * FROM   employees   WHERE gender=   "F" AND last_name="Pettey"

    查询所有姓Facello的或是叫mary的女生并且出生在1960年以后的 员工信息

    SELECT * FROM   employees WHERE (last_name="Facello" OR last_name="mary") and gender="F" and birth_date>="1960-01-01" ORDER BY birth_date DESC

    查询所有姓Facello的男生或是姓Hutton的女生

    SELECT * FROM   employees WHERE (last_name="Facello"and gender="M" ) OR (last_name="Hutton" AND gender="F" ) 

    员工都是哪些姓,按姓排序正序排,显示员工姓名

    SELECT last_name as ,first_name as  FROM employees ORDER BY last_name

    显示2000年后来的员工按时间排序并按姓排序,显示员工名和雇佣时间

    SELECT first_name,hire_date FROM employees WHERE hire_date>='2000-01-01' ORDER BY hire_date desc,first_name asc

    显示(不)姓Facello和姓Hutton的员工,使用in (not in)

    SELECT * FROM employees WHERE last_name in  ("Facello","Hutton")
    SELECT * FROM employees WHERE last_name not in ("Facello","Hutton")

    显示是否有没有雇佣时间的员工

    SELECT * FROM employees WHERE   hire_date is null 

    显示工作20年以上的员工

    SELECT *,TIMESTAMPDIFF(year,hire_date,NOW()) as 工龄 FROM employees where TIMESTAMPDIFF(YEAR,hire_date,now())>20 ORDER BY TIMESTAMPDIFF(year,hire_date,NOW()) desc

    显示以b下列开头的名字

    SELECT first_name,last_name FROM employees WHERE first_name LIKE "b%"

    显示以fy结尾的名字

    SELECT first_name,last_name FROM employees WHERE first_name LIKE "%fy"

    显示包含we名字

    SELECT first_name,last_name FROM employees WHERE first_name LIKE "%we%"

    显示包含五个字符的名字

    SELECT  first_name,last_name FROM employees WHERE first_name REGEXP  '^.....$'
  • 课后作业:
    curl -s https://testerhome.com/api/v3/topics.json | sed 's#{"id":#@{"id":#g' | awk 'BEGIN{RS="@"}{print $0}'

  • Author only