1. 选择在tea表中选择teaage等于19岁，叫汪雪的

    select*from tea where teaage='19'&&stuname='张雪'

  2. 在stu找出大于20岁的女同学的姓名、学号

    select stuname,stuid from stu where teaage='19'&&stusex='女'；

  3. 选择tea表中teaname有姓李

    select*from tea where teaname like '李%';

  4. 在tea表中teaage按降序方法来排序

    select*from tea order byteaage desc;

  5. 在tea中给teaidA0006的teasex改为女

    update tea set teasex=where teaid ='A0006';

  6. 删除一行id=1

    delete from 表明 where id=1;

  7. 给root授权

    grant all privileges on *.*(备注指所有库，具体可以是mysql)to 'root' @ %(所有ip具体192.168.1.117) identified by '123456'(密码)。

  8. rpm -q查询rpm 包是否安装






<!DOCTYPE html>

<html>

<head lang="en">

    <meta charset="UTF-8">

    <title></title>

</head>

<body>

<h1>热点推荐</h1>

<a href="http://news.sina.com.cn/c/nd/2016-01-18/doc-ifxnqriz9782665.shtml"  target="_self"> &nbsp;&nbsp;&nbsp;&nbsp;***访问中东 <img src="http://n.sinaimg.cn/news/transform/20151125/-duM-fxkwvap1715252.jpg"></a>


</body>

</html>





<dl>

    <dt><img src="p_w_picpaths/photo_02.jpg" alt"商品1"  tile="服装1"/>

        <dd>一口价：<span>49</span> </dd>

    </dt>

    <dt></dt>

</dl>





<!DOCTYPE html>

<html>

<head lang="en">

    <meta charset="UTF-8">

    <title></title>

</head>

<body>

<h4>网页搜索</h4>

<iframe width="90%"

        frameborder="1" scrolling="yes" height="400px"

        src="http://www.baidu.com" name="topFrame">


</iframe>

<p><a href="http:?/www.baid.com" target="topFrame">百度</a>&nbsp;

    <a href="http://www.sohu.com" target="topFrame">搜狐</a>&nbsp;


</p>

</body>

</html>






建立库create database sms