{"id":191,"date":"2021-08-10T14:00:04","date_gmt":"2021-08-10T06:00:04","guid":{"rendered":"https:\/\/9iwd.top\/?p=191"},"modified":"2021-08-10T14:01:27","modified_gmt":"2021-08-10T06:01:27","slug":"mysql-%e5%88%9d%e8%af%86%e8%ae%a1%e7%ae%97","status":"publish","type":"post","link":"http:\/\/9iwd.top\/?p=191","title":{"rendered":"No4 mysql \u521d\u8bc6\u8ba1\u7b97\u8fd0\u7528"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>\/\/\u8ba1\u7b97\u5458\u5de5\u5e74\u85aa\uff1fsal * 12\n\/\/\u73b0\u5728\u5148\u770b\u770b\u539f\u59cb\u6570\u636e\nmysql>  select ename,sal from emp;\r\n+--------+---------+\r\n| ename  | sal     |\r\n+--------+---------+\r\n| SMITH  |  800.00 |\r\n| ALLEN  | 1600.00 |\r\n| WARD   | 1250.00 |\r\n| JONES  | 2975.00 |\r\n| MARTIN | 1250.00 |\r\n| BLAKE  | 2850.00 |\r\n| CLARK  | 2450.00 |\r\n| SCOTT  | 3000.00 |\r\n| KING   | 5000.00 |\r\n| TURNER | 1500.00 |\r\n| ADAMS  | 1100.00 |\r\n| JAMES  |  950.00 |\r\n| FORD   | 3000.00 |\r\n| MILLER | 1300.00 |\r\n+--------+---------+\n\n \/\/ \u7ed3\u8bba\uff1a\u5b57\u6bb5\u53ef\u4ee5\u4f7f\u7528\u6570\u5b66\u8868\u8fbe\u5f0f\uff01\nmysql> select ename,sal*12 from emp;\r\n+--------+----------+\r\n| ename  | sal*12   |\r\n+--------+----------+\r\n| SMITH  |  9600.00 |\r\n| ALLEN  | 19200.00 |\r\n| WARD   | 15000.00 |\r\n| JONES  | 35700.00 |\r\n| MARTIN | 15000.00 |\r\n| BLAKE  | 34200.00 |\r\n| CLARK  | 29400.00 |\r\n| SCOTT  | 36000.00 |\r\n| KING   | 60000.00 |\r\n| TURNER | 18000.00 |\r\n| ADAMS  | 13200.00 |\r\n| JAMES  | 11400.00 |\r\n| FORD   | 36000.00 |\r\n| MILLER | 15600.00 |\r\n+--------+----------+<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/\u8d77\u522b\u540d\nmysql> select ename,sal*12 as yearsal from emp;\r\n+--------+----------+\r\n| ename  | yearsal  |\r\n+--------+----------+\r\n| SMITH  |  9600.00 |\r\n| ALLEN  | 19200.00 |\r\n| WARD   | 15000.00 |\r\n| JONES  | 35700.00 |\r\n| MARTIN | 15000.00 |\r\n| BLAKE  | 34200.00 |\r\n| CLARK  | 29400.00 |\r\n| SCOTT  | 36000.00 |\r\n| KING   | 60000.00 |\r\n| TURNER | 18000.00 |\r\n| ADAMS  | 13200.00 |\r\n| JAMES  | 11400.00 |\r\n| FORD   | 36000.00 |\r\n| MILLER | 15600.00 |\r\n+--------+----------+<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/\u522b\u540d\u662f\u4e2d\u6587\uff0c\u7528\u5355\u5f15\u53f7\u62ec\u8d77\u6765\u3002\nmysql> select ename,sal*12 as '\u5e74\u85aa' from emp;\r\n+--------+----------+\r\n| ename  | \u5e74\u85aa     |\r\n+--------+----------+\r\n| SMITH  |  9600.00 |\r\n| ALLEN  | 19200.00 |\r\n| WARD   | 15000.00 |\r\n| JONES  | 35700.00 |\r\n| MARTIN | 15000.00 |\r\n| BLAKE  | 34200.00 |\r\n| CLARK  | 29400.00 |\r\n| SCOTT  | 36000.00 |\r\n| KING   | 60000.00 |\r\n| TURNER | 18000.00 |\r\n| ADAMS  | 13200.00 |\r\n| JAMES  | 11400.00 |\r\n| FORD   | 36000.00 |\r\n| MILLER | 15600.00 |\r\n+--------+----------+<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"_links":{"self":[{"href":"http:\/\/9iwd.top\/index.php?rest_route=\/wp\/v2\/posts\/191"}],"collection":[{"href":"http:\/\/9iwd.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/9iwd.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/9iwd.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/9iwd.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=191"}],"version-history":[{"count":2,"href":"http:\/\/9iwd.top\/index.php?rest_route=\/wp\/v2\/posts\/191\/revisions"}],"predecessor-version":[{"id":196,"href":"http:\/\/9iwd.top\/index.php?rest_route=\/wp\/v2\/posts\/191\/revisions\/196"}],"wp:attachment":[{"href":"http:\/\/9iwd.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/9iwd.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=191"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/9iwd.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}