<br />
<b>Warning</b>:  "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/qtranslate-x/qtranslate_frontend.php</b> on line <b>497</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
<br />
<b>Warning</b>:  preg_replace(): Compilation failed: invalid range in character class at offset 4 in <b>/home/users/2/flatworld/web/memoecho.com/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php</b> on line <b>340</b><br />
{"id":1615,"date":"2018-04-04T07:11:35","date_gmt":"2018-04-04T07:11:35","guid":{"rendered":"http:\/\/tech.memoecho.com\/?p=1615"},"modified":"2018-04-04T07:11:35","modified_gmt":"2018-04-04T07:11:35","slug":"%e4%b8%ad%e6%96%87-shell%e8%84%9a%e6%9c%ac%e8%bf%9e%e6%8e%a5%e3%80%81%e8%af%bb%e5%86%99%e3%80%81%e6%93%8d%e4%bd%9cmysql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%ae%9e%e4%be%8b","status":"publish","type":"post","link":"http:\/\/tech.memoecho.com\/zh\/shell\/%e4%b8%ad%e6%96%87-shell%e8%84%9a%e6%9c%ac%e8%bf%9e%e6%8e%a5%e3%80%81%e8%af%bb%e5%86%99%e3%80%81%e6%93%8d%e4%bd%9cmysql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%ae%9e%e4%be%8b\/","title":{"rendered":"shell\u811a\u672c\u8fde\u63a5\u3001\u8bfb\u5199\u3001\u64cd\u4f5cmysql\u6570\u636e\u5e93\u5b9e\u4f8b"},"content":{"rendered":"<!-- WP QUADS Content Ad Plugin v. 2.0.19 -->\n<div class=\"quads-location quads-ad2\" id=\"quads-ad2\" style=\"float:none;margin:0px;\">\n\n <!-- WP QUADS - Quick AdSense Reloaded v.2.0.19 Content AdSense async --> \n\n\n<script type=\"text\/javascript\" >\nvar quads_screen_width = document.body.clientWidth;\nif ( quads_screen_width >= 1140 ) {document.write('<ins class=\"adsbygoogle\" style=\"display:inline-block;width:336px;height:280px;\" data-ad-client=\"pub-8568501110011894\" data-ad-slot=\"4911828489\" ><\/ins>');\r\n            (adsbygoogle = window.adsbygoogle || []).push({});\r\n            }if ( quads_screen_width >= 1024  && quads_screen_width < 1140 ) {document.write('<ins class=\"adsbygoogle\" style=\"display:inline-block;width:336px;height:280px;\" data-ad-client=\"pub-8568501110011894\" data-ad-slot=\"4911828489\" ><\/ins>');\r\n            (adsbygoogle = window.adsbygoogle || []).push({});\r\n            }if ( quads_screen_width >= 768  && quads_screen_width < 1024 ) {document.write('<ins class=\"adsbygoogle\" style=\"display:inline-block;width:336px;height:280px;\" data-ad-client=\"pub-8568501110011894\" data-ad-slot=\"4911828489\" ><\/ins>');\r\n            (adsbygoogle = window.adsbygoogle || []).push({});\r\n            }if ( quads_screen_width < 768 ) {document.write('<ins class=\"adsbygoogle\" style=\"display:inline-block;width:336px;height:280px;\" data-ad-client=\"pub-8568501110011894\" data-ad-slot=\"4911828489\" ><\/ins>');\r\n            (adsbygoogle = window.adsbygoogle || []).push({});\r\n            }\n<\/script>\n\n <!-- end WP QUADS --> \n\n\n<\/div>\n<p>\u672c\u6587\u4ecb\u7ecd\u4e86\u5982\u4f55\u5728shell\u4e2d\u8bfb\u5199mysql\u6570\u636e\u5e93\u3002\u4e3b\u8981\u4ecb\u7ecd\u4e86\u5982\u4f55\u5728shell \u4e2d\u8fde\u63a5mysql\u6570\u636e\u5e93\uff0c\u5982\u4f55\u5728shell\u4e2d\u521b\u5efa\u6570\u636e\u5e93\uff0c\u521b\u5efa\u8868\uff0c\u63d2\u5165csv\u6587\u4ef6\uff0c\u8bfb\u53d6mysql\u6570\u636e\u5e93\uff0c\u5bfc\u51famysql\u6570\u636e\u5e93\u4e3axml\u6216html\u6587\u4ef6\uff0c \u5e76\u5206\u6790\u4e86\u6838\u5fc3\u8bed\u53e5\u3002\u672c\u6587\u4ecb\u7ecd\u7684\u65b9\u6cd5\u9002\u7528\u4e8ePostgreSQL \uff0c\u76f8\u5bf9mysql\u800c\u8a00\uff0cshell \u4e2d\u8bfb\u5199PostgreSQL\u4f1a\u66f4\u7b80\u5355\u4e9b\u3002<\/p>\n<p><strong>1. \u8fde\u63a5mysql \u6570\u636e\u5e93<\/strong><\/p>\n<p>shell\u4e2d\u8fde\u63a5\u6570\u636e\u5e93\u7684\u65b9\u6cd5\u5f88\u7b80\u5355\uff0c\u53ea\u9700\u8981\u6307\u5b9a\u7528\u6237\u540d\uff0c\u5bc6\u7801\uff0c\u8fde\u63a5\u7684\u6570\u636e\u5e93\u540d\u79f0\uff0c\u7136\u540e\u901a\u8fc7\u91cd\u5b9a\u5411\uff0c\u8f93\u5165mysql\u7684\u8bed\u53e5\uff0c\u5982\u4e0b\u6240\u793a\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut84830\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code84830\" class=\"codebody\">mysql -u USERNAME -p PASSWORD DATABASENAME &lt;&lt;EOF 2&gt;\/dev\/null<br \/>\nshow databases;<br \/>\nEOF<\/div>\n<p>\u4f46\u8fd9\u5e76\u4e0d\u662f\u4e00\u4e2a\u597d\u529e\u6cd5\uff0c\u4efb\u4f55\u4f7f\u7528\u8be5\u811a\u672c\u7684\u7528\u6237\u90fd\u80fd\u770b\u5230\u8be5\u6570\u636e\u5e93\u7528\u6237\u7684\u8d26\u53f7\u548c\u5bc6\u7801\uff0c\u8981\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\uff0c\u53ef\u4ee5\u7528mysql \u6570\u636e\u5e93\u7684\u4e00\u4e2a\u7279\u6b8a\u914d\u7f6e\u6587\u4ef6\u3002mysql \u6570\u636e\u5e93\u4f7f\u7528$HOME\/.my.cnf \u6587\u4ef6\u6765\u8bfb\u53d6\u7279\u6b8a\u7684\u542f\u52a8\u547d\u4ee4\u548c\u8bbe\u7f6e\u3002\u5176\u4e2d\u4e00\u9879\u8bbe\u7f6e\u662f\u7531\u8be5\u7528\u6237\u8d26\u6237\u53d1\u8d77\u7684mysql \u4f1a\u8bdd\u7684\u9ed8\u8ba4\u5bc6\u7801\u3002\u8981\u5728\u8fd9\u4e2a\u6587\u4ef6\u4e2d\u8bbe\u7f6e\u9ed8\u8ba4\u5bc6\u7801\uff0c\u53ef\u4ee5\u52a0\u5165\u4e0b\u9762\u7684\u5185\u5bb9\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut3102\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code3102\" class=\"codebody\">\n[client]<br \/>\npassword = 123456<br \/>\n\u7136\u540e\uff0c\u522b\u5fd8\u4e86\u4fee\u6539\u6743\u9650\uff1a<br \/>\nchmod 400\u00a0 .my.cnf<br \/>\n\u8fd9\u6837\u5c31\u53ef\u4ee5\u901a\u8fc7\u811a\u672c\u8bbf\u95eemysql\u6570\u636e\u5e93\u4e86\uff0c\u5982\u4e0b\u6240\u793a\uff1a<br \/>\n#!\/bin\/bash<br \/>\nMYSQL=`which mysql`<br \/>\n$MYSQL test -u root &lt;&lt; EOF<br \/>\nshow databases;<br \/>\nshow tables;<br \/>\nselect * from employees where salary &gt; 4000;<br \/>\nEOF<\/div>\n<p><strong>2. \u521b\u5efa\u6570\u636e\u5e93<\/strong><\/p>\n<p>\u901a\u8fc7\u4e0a\u9762\u7684\u65b9\u6cd5\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u518d\u901a\u8fc7\u91cd\u5b9a\u5411\u8f93\u5165mysql\u8bed\u53e5\uff0cshell\u4e2d\u8bfb\u5199mysql\u57fa\u672c\u5c31\u4ecb\u7ecd\u5b8c\u4e86\u3002\u53ea\u8981\u628asql\u8bed\u53e5\u5199\u5bf9\u4e86\uff0c\u901a\u8fc7\u91cd\u5b9a\u5411\u6267\u884c\u5373\u53ef\uff0c\u4e0b\u9762\u6765\u770b\u4e00\u4e2a\u5b9e\u4f8b\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut81076\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code81076\" class=\"codebody\">\n#!\/bin\/bash<br \/>\n##############################<br \/>\n# @file create_db_mysql.sh<br \/>\n# @brief create database and tables in mysql<br \/>\n# @author Mingxing LAI<br \/>\n# @version 0.1<br \/>\n# @date 2013-01-20<br \/>\n##############################<br \/>\nUSER=&#8221;root&#8221;<br \/>\nDATABASE=&#8221;students&#8221;<br \/>\nTABLE=&#8221;students&#8221;<br \/>\n######################<br \/>\n#crate database<br \/>\nmysql -u $USER &lt;&lt; EOF 2&gt;\/dev\/null<br \/>\nCREATE DATABASE $DATABASE<br \/>\nEOF<br \/>\n[ $? -eq 0 ] &amp;&amp; echo &#8220;created DB&#8221; || echo DB already exists<br \/>\n######################<br \/>\n#create table<br \/>\nmysql -u $USER $DATABASE &lt;&lt; EOF 2&gt;\/dev\/null<br \/>\nCREATE TABLE $TABLE(<br \/>\nid int,<br \/>\nname varchar(100),<br \/>\nmark int,<br \/>\ndept varchar(4)<br \/>\n);<br \/>\nEOF<br \/>\n[ $? -eq 0 ] &amp;&amp; echo &#8220;Created table students&#8221; || echo &#8220;Table students already exist&#8221;<br \/>\n######################<br \/>\n#delete data<br \/>\nmysql -u $USER $DATABASE &lt;&lt; EOF 2&gt;\/dev\/null<br \/>\nDELETE FROM $TABLE;<br \/>\nEOF<\/div>\n<p>\u8fd9\u4e2a\u811a\u672c\u6bd4\u8f83\u7b80\u5355\uff0c\u5c31\u662f\u51e0\u6761SQL\u8bed\u53e5\uff0c\u6ca1\u4ec0\u4e48\u597d\u89e3\u91ca\u7684\uff0c\u4e0b\u9762\u6765\u770b\u4e00\u4e0b\uff0c\u5982\u4f55\u8bfb\u5165csv \u6587\u4ef6\uff0c\u7136\u540e\u63d2\u5165\u5230mysql\u6570\u636e\u5e93\u4e2d\u3002<\/p>\n<p><strong>3. \u63d2\u5165csv \u6587\u4ef6<\/strong><\/p>\n<p>\u4e0a\u9762\u521b\u5efa\u4e86\u4e00\u4e2a\u5b66\u751f\u8868\uff0c\u8868\u4e2d\u6709\u5b66\u751f\u7684\u5b66\u53f7\uff0c\u59d3\u540d\uff0c\u6210\u7ee9\uff0c\u7cfb\u522b\uff0c\u5047\u8bbe\u6709\u4e00\u4e2acsv\u6587\u4ef6\uff0c\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut20597\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code20597\" class=\"codebody\">$cat data<br \/>\n1,Navin M,98,CS<br \/>\n2,Kavya N,70,CS<br \/>\n3,Nawaz O,80,CS<br \/>\n4,Hari S,80,EC<br \/>\n5,Alex M,50,EC<br \/>\n6,Neenu J,70,EC<br \/>\n7,Bob A,30,EC<br \/>\n8,Anu M,90,AE<br \/>\n9,Sruthi,89,AE<br \/>\n10,Andrew,89,AE<\/div>\n<p>\u4e3a\u4e86\u5c06csv \u6587\u4ef6\u63d2\u5165\u5230\u6570\u636e\u5e93\uff0c\u6211\u4eec\u9700\u8981\u9010\u884c\u8bfb\u5165\uff0c\u7136\u540e\u7ed9\u5b57\u7b26\u4e32\u52a0\u4e0a\u53cc\u5f15\u53f7\uff0c\u6700\u540e\u751f\u6210\u8bed\u53e5\u5982\u4e0b\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut2034\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code2034\" class=\"codebody\">\ninsert into students VALUES(1, &#8220;Navin M&#8221;, 98, &#8220;CS&#8221;);<\/div>\n<p>\u8981\u89e3\u6790csv \u6587\u4ef6\uff0c\u6700\u597d\u7684\u5de5\u5177\u83ab\u8fc7\u4e8eawk\u4e86\uff0c\u5c06\u57df\u7684\u5206\u9694\u7b26\u6307\u5b9a\u4e3a\u9017\u53f7-F,\uff0cawk\u5c31\u81ea\u52a8\u5c06\u5404\u4e2a\u57df\u62c6\u5206\u51fa\u6765\u4e86\uff0c\u7136\u540e\u5728\u9700\u8981\u53cc\u5f15\u53f7\u7684\u5730\u65b9\u6253\u5370\u8f93\u51fa\u4e00\u4e2a\u53cc\u5f15\u53f7\uff0c\u5c31\u80fd\u591f\u8f7b\u677e\u5f97\u5230\u4e0b\u9762\u8fd9\u6837\u7684\u6570\u636e\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut84280\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code84280\" class=\"codebody\">1, &#8220;Navin M&#8221;, 98, &#8220;CS&#8221; awk \u4ee3\u7801\u5982\u4e0b\uff1a<br \/>\nquery=`echo $line | awk -F, &#8216;{ printf(&#8220;%s,\\&#8221;%s\\&#8221;,%s,\\&#8221;%s\\&#8221;&#8221;, $1, $2, $3, $4)}&#8217;`<br \/>\nstatement=`echo &#8220;INSERT INTO $TABLE VALUES($query);&#8221;`<br \/>\necho $statement<\/div>\n<p>\u5f53\u7136\u4e86\uff0c\u4f60\u4e5f\u53ef\u4ee5\u7528\u5176\u4ed6\u529e\u6cd5\uff0c\u4e0d\u8fc7\uff0c\u51e0\u4e4e\u6ca1\u6709\u6bd4awk\u66f4\u7b80\u5355\u7684\u4e86\uff0c\u7b2c2\u79cd\u65b9\u6cd5\u5982\u4e0b\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut10984\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code10984\" class=\"codebody\">\noldIFS=$IFS<br \/>\nIFS=,<br \/>\nvalues=($line)values[1]=&#8221;\\&#8221;`echo ${values[1]} | tr &#8216; &#8216; &#8216;#&#8217; `\\&#8221;&#8221;<br \/>\nvalues[3]=&#8221;\\&#8221;`echo ${values[3]}`\\&#8221;&#8221;<\/p>\n<p>query=`echo ${values[@]} | tr &#8216; #&#8217; &#8216;, &#8216;`<br \/>\nIFS=$oldIFS<\/p>\n<p>statement=`echo &#8220;INSERT INTO $TABLE VALUES($query);&#8221;`<br \/>\necho &#8220;$statement&#8221;<\/p>\n<\/div>\n<p>\u9996\u5148\u901a\u8fc7\u6307\u5b9a\u57df\u5206\u9694\u7b26\uff0c\u5c06csv\u6587\u4ef6\u89e3\u6790\u6210\u4e00\u4e2a\u6570\u7ec4\uff0c\u7136\u540e\u5c06\u7a7a\u683c\u66ff\u6362\u6210\u4e00\u4e2a\u7279\u6b8a\u7684\u7b26\u53f7&#8221;#&#8221;\uff08\u56e0\u4e3a\u540e\u9762\u7684\u66ff\u6362\u4e2d\uff0c\u4f1a\u4e00\u6b21\u6027\u8f93\u51fa\u6570\u7ec4\uff0c\u800c\u6570\u7ec4\u662f\u7528\u7a7a\u683c\u5206\u9694\u5404\u5b57\u6bb5,\u6211\u4eec\u8981\u5c06\u5206\u9694\u6570\u7ec4\u7684\u7a7a\u683c\u66ff\u6362\u6210\u9017\u53f7\uff0c\u6240\u4ee5\u8fd9\u91cc\u5c06\u6570\u636e\u4e2d\u7684\u7a7a\u683c\u66ff\u6362\u6210&#8221;#&#8221;\uff09 \uff0c\u7ed9\u5b57\u7b26\u4e32\u52a0\u4e0a\u53cc\u5f15\u53f7\uff0c\u6700\u540e\u518d\u628a\u7a7a\u683c\u66ff\u6362\u6210\u9017\u53f7\uff0c\u628a&#8221;#&#8221;\u66ff\u6362\u4e3a\u7a7a\u683c\u3002\u8fd9\u79cd\u65b9\u6cd5\u771f\u662f\u8ba9\u4eba\u6293\u72c2\uff0c\u6211\u7b2c\u4e00\u6b21\u5c31\u6ca1\u6709\u770b\u660e\u767d\uff0c\u5c24\u5176\u662f\u4e3a\u4ec0\u4e48\u8981\u5c06\u7a7a\u683c\u66ff\u6362\u6210&#8221;#&#8221;\u3002<\/p>\n<!-- WP QUADS Content Ad Plugin v. 2.0.19 -->\n<div class=\"quads-location quads-ad2\" id=\"quads-ad2\" style=\"float:none;margin:0px;\">\n\n <!-- WP QUADS - Quick AdSense Reloaded v.2.0.19 Content AdSense async --> \n\n\n<script type=\"text\/javascript\" >\nvar quads_screen_width = document.body.clientWidth;\nif ( quads_screen_width >= 1140 ) {document.write('<ins class=\"adsbygoogle\" style=\"display:inline-block;width:336px;height:280px;\" data-ad-client=\"pub-8568501110011894\" data-ad-slot=\"4911828489\" ><\/ins>');\r\n            (adsbygoogle = window.adsbygoogle || []).push({});\r\n            }if ( quads_screen_width >= 1024  && quads_screen_width < 1140 ) {document.write('<ins class=\"adsbygoogle\" style=\"display:inline-block;width:336px;height:280px;\" data-ad-client=\"pub-8568501110011894\" data-ad-slot=\"4911828489\" ><\/ins>');\r\n            (adsbygoogle = window.adsbygoogle || []).push({});\r\n            }if ( quads_screen_width >= 768  && quads_screen_width < 1024 ) {document.write('<ins class=\"adsbygoogle\" style=\"display:inline-block;width:336px;height:280px;\" data-ad-client=\"pub-8568501110011894\" data-ad-slot=\"4911828489\" ><\/ins>');\r\n            (adsbygoogle = window.adsbygoogle || []).push({});\r\n            }if ( quads_screen_width < 768 ) {document.write('<ins class=\"adsbygoogle\" style=\"display:inline-block;width:336px;height:280px;\" data-ad-client=\"pub-8568501110011894\" data-ad-slot=\"4911828489\" ><\/ins>');\r\n            (adsbygoogle = window.adsbygoogle || []).push({});\r\n            }\n<\/script>\n\n <!-- end WP QUADS --> \n\n\n<\/div>\n\n<p>\u5b8c\u6574\u7684\u63d2\u5165\u6570\u636e\u7684\u7a0b\u5e8f\u5982\u4e0b\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut30874\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code30874\" class=\"codebody\">\n#!\/bin\/bash<br \/>\n#<br \/>\n# @file write_to_db_mysql.sh<br \/>\n# @brief wirte data to database in mysql<br \/>\n# @author Mingxing LAI<br \/>\n# @version 0.1<br \/>\n# @date 2013-01-20<br \/>\n#USER=&#8221;root&#8221;<br \/>\nDATABASE=&#8221;students&#8221;<br \/>\nTABLE=&#8221;students&#8221;<br \/>\nif [ $# -ne 1 ]; then<br \/>\necho $0 DATAFILE<br \/>\necho<br \/>\nexit 2<br \/>\nfi<br \/>\ndata=$1<br \/>\nwhile\u00a0 read line;<br \/>\ndo<br \/>\n#\u00a0\u00a0 query=`echo $line | awk -F, &#8216;{ printf(&#8220;%s,\\&#8221;%s\\&#8221;,%s,\\&#8221;%s\\&#8221;&#8221;, $1, $2, $3, $4)}&#8217;`<br \/>\noldIFS=$IFS<br \/>\nIFS=,<br \/>\nvalues=($line)<br \/>\nvalues[1]=&#8221;\\&#8221;`echo ${values[1]} | tr &#8216; &#8216; &#8216;#&#8217; `\\&#8221;&#8221;<br \/>\nvalues[3]=&#8221;\\&#8221;`echo ${values[3]}`\\&#8221;&#8221;<br \/>\nquery=`echo ${values[@]} | tr &#8216; #&#8217; &#8216;, &#8216;`<br \/>\nIFS=$oldIFS<br \/>\nstatement=`echo &#8220;INSERT INTO $TABLE VALUES($query);&#8221;`<br \/>\n#\u00a0\u00a0 echo $statement<\/p>\n<p>mysql -u $USER $DATABASE &lt;&lt; EOF<br \/>\nINSERT INTO $TABLE VALUES($query);<br \/>\nEOF<br \/>\ndone &lt; $data<br \/>\nif [[ $? -eq 0 ]]; then<br \/>\necho &#8220;Wrote data into DB&#8221;<br \/>\nfi<\/p>\n<\/div>\n<p><strong>4. \u8bfb\u53d6\u6570\u636e<\/strong><\/p>\n<p>\u77e5\u9053\u600e\u4e48\u5728shell \u4e2d\u8fde\u63a5mysql \uff0c\u4e5f\u77e5\u9053\u4e86\u600e\u4e48\u5728shell\u4e2d\u6279\u91cf\u6267\u884csql \u8bed\u53e5\uff0c\u8bfb\u53d6\u6570\u636e\uff0c\u5c31\u6ca1\u6709\u4efb\u4f55\u96be\u5ea6\u4e86\u3002<\/p>\n<div class=\"codetitle\"><a id=\"copybut97762\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code97762\" class=\"codebody\">#!\/bin\/bash<br \/>\n#<br \/>\n# @file read_db_mysql.sh<br \/>\n# @brief read data from mysql<br \/>\n# @author Mingxing LAI<br \/>\n# @version 0.1<br \/>\n# @date 2013-01-20<br \/>\n#USER=&#8221;root&#8221;<br \/>\nDATABASE=&#8221;students&#8221;<br \/>\nTABLE=&#8221;students&#8221;<\/p>\n<p>#\u7528tail \u53bb\u6389\u8868\u5934<br \/>\ndepts=`mysql -u $USER $DATABASE &lt;&lt;EOF | tail -n +2<br \/>\nSELECT DISTINCT dept FROM $TABLE;<br \/>\nEOF`<\/p>\n<p>for d in $depts; do<br \/>\necho Department: $d<br \/>\nresult=&#8221;`mysql -u $USER $DATABASE &lt;&lt; EOF<br \/>\nset @i:=0;<br \/>\nSELECT @i:=@i+1 as rank, name, mark FROM students WHERE dept=&#8221;$d&#8221; ORDER BY mark DESC;<br \/>\nEOF`&#8221;<\/p>\n<p>echo &#8220;$result&#8221;<br \/>\necho<br \/>\ndone<\/p>\n<\/div>\n<p>\u6211\u4eec\u8fd8\u53ef\u4ee5\u5728mysql\u8bed\u53e5\u4e2d\uff0c\u4f7f\u7528\u9009\u9879\u6765\u63a7\u5236\u6570\u636e\u7684\u8f93\u51fa\u683c\u5f0f<\/p>\n<p>-H \u8f93\u51fa\u4e3ahtml<br \/>\n-X \u8f93\u51fa\u4e3axml<\/p>\n<p>\u5982\u4e0b\u6240\u793a\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut97098\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code97098\" class=\"codebody\">\n#!\/bin\/bash<br \/>\nUSER=&#8221;root&#8221;<br \/>\nDATABASE=&#8221;students&#8221;<br \/>\nTABLE=&#8221;students&#8221;mysql -u $USER $DATABASE -H &lt;&lt; EOF<br \/>\nselect * from $TABLE<br \/>\nEOF<\/p>\n<\/div>\n<p>html \u683c\u5f0f\u7684\u53ef\u8bfb\u6027\u6bd4\u8f83\u5dee\uff0c\u8f93\u51fa\u6548\u679c\u5982\u4e0b\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut72531\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code72531\" class=\"codebody\">&lt;TABLE BORDER=1&gt;&lt;TR&gt;&lt;TH&gt;id&lt;\/TH&gt;&lt;TH&gt;name&lt;\/TH&gt;&lt;TH&gt;mark&lt;\/TH&gt;&lt;TH&gt;dept&lt;\/TH&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;1&lt;\/TD&gt;&lt;TD&gt;Navin M&lt;\/TD&gt;&lt;TD&gt;98&lt;\/TD&gt;&lt;TD&gt;CS&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;2&lt;\/TD&gt;&lt;TD&gt; Kavya N&lt;\/TD&gt;&lt;TD&gt;70&lt;\/TD&gt;&lt;TD&gt;CS&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;3&lt;\/TD&gt;&lt;TD&gt; Nawaz O&lt;\/TD&gt;&lt;TD&gt;80&lt;\/TD&gt;&lt;TD&gt;CS&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;4&lt;\/TD&gt;&lt;TD&gt;Hari S&lt;\/TD&gt;&lt;TD&gt;80&lt;\/TD&gt;&lt;TD&gt;EC&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;5&lt;\/TD&gt;&lt;TD&gt;Alex M&lt;\/TD&gt;&lt;TD&gt;50&lt;\/TD&gt;&lt;TD&gt;EC&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;6&lt;\/TD&gt;&lt;TD&gt;Neenu J&lt;\/TD&gt;&lt;TD&gt;70&lt;\/TD&gt;&lt;TD&gt;EC&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;7&lt;\/TD&gt;&lt;TD&gt;Bob A&lt;\/TD&gt;&lt;TD&gt;30&lt;\/TD&gt;&lt;TD&gt;EC&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;8&lt;\/TD&gt;&lt;TD&gt;Anu M&lt;\/TD&gt;&lt;TD&gt;90&lt;\/TD&gt;&lt;TD&gt;AE&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;9&lt;\/TD&gt;&lt;TD&gt;Sruthi&lt;\/TD&gt;&lt;TD&gt;89&lt;\/TD&gt;&lt;TD&gt;AE&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;10&lt;\/TD&gt;&lt;TD&gt;Andrew&lt;\/TD&gt;&lt;TD&gt;89&lt;\/TD&gt;&lt;TD&gt;AE&lt;\/TD&gt;&lt;\/TR&gt;&lt;\/TABLE&gt;<\/div>\n<p>\u53ef\u8bfb\u6027\u5dee\u4e5f\u53ef\u4ee5\u7406\u89e3\uff0c\u56e0\u4e3a\u4eba\u5bb6\u89c9\u5f97\uff0c\u4f60\u6ca1\u5fc5\u8981\u4fee\u6539\u4e48\uff0c\u76f4\u63a5\u4ee5html\u5f62\u5f0f\u5c55\u793a\u6570\u636e\u5c31\u53ef\u4ee5\u4e86\u3002<\/p>\n<div class=\"codetitle\"><a id=\"copybut46232\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code46232\" class=\"codebody\">id\u00a0\u00a0\u00a0 name\u00a0\u00a0\u00a0 mark\u00a0\u00a0\u00a0 dept<br \/>\n1\u00a0\u00a0\u00a0 Navin M\u00a0\u00a0\u00a0 98\u00a0\u00a0\u00a0 CS<br \/>\n2\u00a0\u00a0\u00a0 Kavya N\u00a0\u00a0\u00a0 70\u00a0\u00a0\u00a0 CS<br \/>\n3\u00a0\u00a0\u00a0 Nawaz O\u00a0\u00a0\u00a0 80\u00a0\u00a0\u00a0 CS<br \/>\n4\u00a0\u00a0\u00a0 Hari S\u00a0\u00a0\u00a0 80\u00a0\u00a0\u00a0 EC<br \/>\n5\u00a0\u00a0\u00a0 Alex M\u00a0\u00a0\u00a0 50\u00a0\u00a0\u00a0 EC<br \/>\n6\u00a0\u00a0\u00a0 Neenu J\u00a0\u00a0\u00a0 70\u00a0\u00a0\u00a0 EC<br \/>\n7\u00a0\u00a0\u00a0 Bob A\u00a0\u00a0\u00a0 30\u00a0\u00a0\u00a0 EC<br \/>\n8\u00a0\u00a0\u00a0 Anu M\u00a0\u00a0\u00a0 90\u00a0\u00a0\u00a0 AE<br \/>\n9\u00a0\u00a0\u00a0 Sruthi\u00a0\u00a0\u00a0 89\u00a0\u00a0\u00a0 AE<br \/>\n10\u00a0\u00a0\u00a0 Andrew\u00a0\u00a0\u00a0 89\u00a0\u00a0\u00a0 AE<\/div>\n<p>xml\u5f62\u5f0f\u7684\u6570\u636e\u663e\u793a\u5c31\u6bd4\u8f83\u6b63\u5e38\u4e86\uff0c\u76f4\u63a5\u5c06\u4e0a\u9762\u7684-H \u6362\u6210-X,\u8f93\u51fa\u5982\u4e0b\uff1a\n<!-- WP QUADS Content Ad Plugin v. 2.0.19 -->\n<div class=\"quads-location quads-ad2\" id=\"quads-ad2\" style=\"float:none;margin:0px;\">\n\n <!-- WP QUADS - Quick AdSense Reloaded v.2.0.19 Content AdSense async --> \n\n\n<script type=\"text\/javascript\" >\nvar quads_screen_width = document.body.clientWidth;\nif ( quads_screen_width >= 1140 ) {document.write('<ins class=\"adsbygoogle\" style=\"display:inline-block;width:336px;height:280px;\" data-ad-client=\"pub-8568501110011894\" data-ad-slot=\"4911828489\" ><\/ins>');\r\n            (adsbygoogle = window.adsbygoogle || []).push({});\r\n            }if ( quads_screen_width >= 1024  && quads_screen_width < 1140 ) {document.write('<ins class=\"adsbygoogle\" style=\"display:inline-block;width:336px;height:280px;\" data-ad-client=\"pub-8568501110011894\" data-ad-slot=\"4911828489\" ><\/ins>');\r\n            (adsbygoogle = window.adsbygoogle || []).push({});\r\n            }if ( quads_screen_width >= 768  && quads_screen_width < 1024 ) {document.write('<ins class=\"adsbygoogle\" style=\"display:inline-block;width:336px;height:280px;\" data-ad-client=\"pub-8568501110011894\" data-ad-slot=\"4911828489\" ><\/ins>');\r\n            (adsbygoogle = window.adsbygoogle || []).push({});\r\n            }if ( quads_screen_width < 768 ) {document.write('<ins class=\"adsbygoogle\" style=\"display:inline-block;width:336px;height:280px;\" data-ad-client=\"pub-8568501110011894\" data-ad-slot=\"4911828489\" ><\/ins>');\r\n            (adsbygoogle = window.adsbygoogle || []).push({});\r\n            }\n<\/script>\n\n <!-- end WP QUADS --> \n\n\n<\/div>\n<\/p>\n<div class=\"codetitle\"><a id=\"copybut98571\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code98571\" class=\"codebody\">&lt;?xml version=&#8221;1.0&#8243;?&gt;<br \/>\n&lt;resultset statement=&#8221;select * from students&#8221; xmlns:xsi=&#8221;http:\/\/www.w3.org\/2001\/XMLSchema-instance&#8221;&gt;<br \/>\n&lt;row&gt;<br \/>\n&lt;field name=&#8221;id&#8221;&gt;1&lt;\/field&gt;<br \/>\n&lt;field name=&#8221;name&#8221;&gt;Navin M&lt;\/field&gt;<br \/>\n&lt;field name=&#8221;mark&#8221;&gt;98&lt;\/field&gt;<br \/>\n&lt;field name=&#8221;dept&#8221;&gt;CS&lt;\/field&gt;<br \/>\n&lt;\/row&gt;<br \/>\n&lt;row&gt;<br \/>\n&lt;field name=&#8221;id&#8221;&gt;2&lt;\/field&gt;<br \/>\n&lt;field name=&#8221;name&#8221;&gt; Kavya N&lt;\/field&gt;<br \/>\n&lt;field name=&#8221;mark&#8221;&gt;70&lt;\/field&gt;<br \/>\n&lt;field name=&#8221;dept&#8221;&gt;CS&lt;\/field&gt;<br \/>\n&lt;\/row&gt;<br \/>\n&lt;\/resultset&gt;<\/div>\n<p>\u5b8c\u3002","protected":false},"excerpt":{"rendered":"<p>\u672c\u6587\u4ecb\u7ecd\u4e86\u5982\u4f55\u5728shell\u4e2d\u8bfb\u5199mysql\u6570\u636e\u5e93\u3002\u4e3b\u8981\u4ecb\u7ecd\u4e86\u5982\u4f55\u5728shell \u4e2d\u8fde\u63a5mysql\u6570\u636e\u5e93\uff0c\u5982\u4f55\u5728shell\u4e2d\u521b\u5efa\u6570\u636e\u5e93\uff0c\u521b\u5efa\u8868\uff0c\u63d2\u5165csv [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[8],"tags":[],"pwapp_after_post_content":"","pwapp_before_post_content":"","androapp_header":"","pwapp_author":{"ID":1,"name":"enadmin","slug":"enadmin"},"pwapp_terms":{"category":[{"term_id":8,"name":"shell","slug":"shell","term_group":0,"term_taxonomy_id":8,"taxonomy":"category","description":"","parent":0,"count":12,"filter":"raw","cat_ID":8,"category_count":12,"category_description":"","cat_name":"shell","category_nicename":"shell","category_parent":0,"ID":8}]},"pwapp_feed_image_dimension_type":"preview","pwapp_post_image":null,"share_image":null,"featured_image_showhide":"show","pwapp_excerpt":"<p>\u672c\u6587\u4ecb\u7ecd\u4e86\u5982\u4f55\u5728shell\u4e2d\u8bfb\u5199mysql\u6570\u636e\u5e93\u3002\u4e3b\u8981\u4ecb\u7ecd\u4e86\u5982\u4f55\u5728shell \u4e2d\u8fde\u63a5mysql\u6570\u636e\u5e93\uff0c\u5982\u4f55\u5728shell\u4e2d\u521b\u5efa\u6570\u636e\u5e93\uff0c\u521b\u5efa\u8868\uff0c\u63d2\u5165csv [&hellip;]<\/p>\n","pwapp_title":"shell\u811a\u672c\u8fde\u63a5\u3001\u8bfb\u5199\u3001\u64cd\u4f5cmysql\u6570\u636e\u5e93\u5b9e\u4f8b","androapp_image_list":[],"pwapp_post_content":"<style type=\"text\/css\">androapp img{\r\n    max-width: 100%;\r\n    height: auto;\r\n}\r\niframe{\r\n    max-width: 100%;    \r\n}\r\nfigure {\r\n    max-width: 100%;\r\n    height: auto;\r\n}\r\nimg{\r\n    max-width: 100% !important;\r\n    height: auto;\r\n}\r\ndiv {\r\n    max-width: 100% !important;\r\n}\r\nspan {\r\n    max-width:100%;\r\n    overflow: auto;\r\n}\r\naudio {\r\n    display:block;\r\n    visibility:visible !important;\r\n}\r\nvideo{\r\n    width:100%;\r\n    height:auto;\r\n}\r\n<\/style><div class='androapp'><p>\u672c\u6587\u4ecb\u7ecd\u4e86\u5982\u4f55\u5728shell\u4e2d\u8bfb\u5199mysql\u6570\u636e\u5e93\u3002\u4e3b\u8981\u4ecb\u7ecd\u4e86\u5982\u4f55\u5728shell \u4e2d\u8fde\u63a5mysql\u6570\u636e\u5e93\uff0c\u5982\u4f55\u5728shell\u4e2d\u521b\u5efa\u6570\u636e\u5e93\uff0c\u521b\u5efa\u8868\uff0c\u63d2\u5165csv\u6587\u4ef6\uff0c\u8bfb\u53d6mysql\u6570\u636e\u5e93\uff0c\u5bfc\u51famysql\u6570\u636e\u5e93\u4e3axml\u6216html\u6587\u4ef6\uff0c \u5e76\u5206\u6790\u4e86\u6838\u5fc3\u8bed\u53e5\u3002\u672c\u6587\u4ecb\u7ecd\u7684\u65b9\u6cd5\u9002\u7528\u4e8ePostgreSQL \uff0c\u76f8\u5bf9mysql\u800c\u8a00\uff0cshell \u4e2d\u8bfb\u5199PostgreSQL\u4f1a\u66f4\u7b80\u5355\u4e9b\u3002<\/p>\n<p><strong>1. \u8fde\u63a5mysql \u6570\u636e\u5e93<\/strong><\/p>\n<p>shell\u4e2d\u8fde\u63a5\u6570\u636e\u5e93\u7684\u65b9\u6cd5\u5f88\u7b80\u5355\uff0c\u53ea\u9700\u8981\u6307\u5b9a\u7528\u6237\u540d\uff0c\u5bc6\u7801\uff0c\u8fde\u63a5\u7684\u6570\u636e\u5e93\u540d\u79f0\uff0c\u7136\u540e\u901a\u8fc7\u91cd\u5b9a\u5411\uff0c\u8f93\u5165mysql\u7684\u8bed\u53e5\uff0c\u5982\u4e0b\u6240\u793a\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut84830\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code84830\" class=\"codebody\">mysql -u USERNAME -p PASSWORD DATABASENAME &lt;&lt;EOF 2&gt;\/dev\/null<br \/>\nshow databases;<br \/>\nEOF<\/div>\n<p>\u4f46\u8fd9\u5e76\u4e0d\u662f\u4e00\u4e2a\u597d\u529e\u6cd5\uff0c\u4efb\u4f55\u4f7f\u7528\u8be5\u811a\u672c\u7684\u7528\u6237\u90fd\u80fd\u770b\u5230\u8be5\u6570\u636e\u5e93\u7528\u6237\u7684\u8d26\u53f7\u548c\u5bc6\u7801\uff0c\u8981\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\uff0c\u53ef\u4ee5\u7528mysql \u6570\u636e\u5e93\u7684\u4e00\u4e2a\u7279\u6b8a\u914d\u7f6e\u6587\u4ef6\u3002mysql \u6570\u636e\u5e93\u4f7f\u7528$HOME\/.my.cnf \u6587\u4ef6\u6765\u8bfb\u53d6\u7279\u6b8a\u7684\u542f\u52a8\u547d\u4ee4\u548c\u8bbe\u7f6e\u3002\u5176\u4e2d\u4e00\u9879\u8bbe\u7f6e\u662f\u7531\u8be5\u7528\u6237\u8d26\u6237\u53d1\u8d77\u7684mysql \u4f1a\u8bdd\u7684\u9ed8\u8ba4\u5bc6\u7801\u3002\u8981\u5728\u8fd9\u4e2a\u6587\u4ef6\u4e2d\u8bbe\u7f6e\u9ed8\u8ba4\u5bc6\u7801\uff0c\u53ef\u4ee5\u52a0\u5165\u4e0b\u9762\u7684\u5185\u5bb9\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut3102\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code3102\" class=\"codebody\">\n[client]<br \/>\npassword = 123456<br \/>\n\u7136\u540e\uff0c\u522b\u5fd8\u4e86\u4fee\u6539\u6743\u9650\uff1a<br \/>\nchmod 400\u00a0 .my.cnf<br \/>\n\u8fd9\u6837\u5c31\u53ef\u4ee5\u901a\u8fc7\u811a\u672c\u8bbf\u95eemysql\u6570\u636e\u5e93\u4e86\uff0c\u5982\u4e0b\u6240\u793a\uff1a<br \/>\n#!\/bin\/bash<br \/>\nMYSQL=`which mysql`<br \/>\n$MYSQL test -u root &lt;&lt; EOF<br \/>\nshow databases;<br \/>\nshow tables;<br \/>\nselect * from employees where salary &gt; 4000;<br \/>\nEOF<\/div>\n<p><strong>2. \u521b\u5efa\u6570\u636e\u5e93<\/strong><\/p>\n<p>\u901a\u8fc7\u4e0a\u9762\u7684\u65b9\u6cd5\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u518d\u901a\u8fc7\u91cd\u5b9a\u5411\u8f93\u5165mysql\u8bed\u53e5\uff0cshell\u4e2d\u8bfb\u5199mysql\u57fa\u672c\u5c31\u4ecb\u7ecd\u5b8c\u4e86\u3002\u53ea\u8981\u628asql\u8bed\u53e5\u5199\u5bf9\u4e86\uff0c\u901a\u8fc7\u91cd\u5b9a\u5411\u6267\u884c\u5373\u53ef\uff0c\u4e0b\u9762\u6765\u770b\u4e00\u4e2a\u5b9e\u4f8b\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut81076\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code81076\" class=\"codebody\">\n#!\/bin\/bash<br \/>\n##############################<br \/>\n# @file create_db_mysql.sh<br \/>\n# @brief create database and tables in mysql<br \/>\n# @author Mingxing LAI<br \/>\n# @version 0.1<br \/>\n# @date 2013-01-20<br \/>\n##############################<br \/>\nUSER=&#8221;root&#8221;<br \/>\nDATABASE=&#8221;students&#8221;<br \/>\nTABLE=&#8221;students&#8221;<br \/>\n######################<br \/>\n#crate database<br \/>\nmysql -u $USER &lt;&lt; EOF 2&gt;\/dev\/null<br \/>\nCREATE DATABASE $DATABASE<br \/>\nEOF<br \/>\n[ $? -eq 0 ] &amp;&amp; echo &#8220;created DB&#8221; || echo DB already exists<br \/>\n######################<br \/>\n#create table<br \/>\nmysql -u $USER $DATABASE &lt;&lt; EOF 2&gt;\/dev\/null<br \/>\nCREATE TABLE $TABLE(<br \/>\nid int,<br \/>\nname varchar(100),<br \/>\nmark int,<br \/>\ndept varchar(4)<br \/>\n);<br \/>\nEOF<br \/>\n[ $? -eq 0 ] &amp;&amp; echo &#8220;Created table students&#8221; || echo &#8220;Table students already exist&#8221;<br \/>\n######################<br \/>\n#delete data<br \/>\nmysql -u $USER $DATABASE &lt;&lt; EOF 2&gt;\/dev\/null<br \/>\nDELETE FROM $TABLE;<br \/>\nEOF<\/div>\n<p>\u8fd9\u4e2a\u811a\u672c\u6bd4\u8f83\u7b80\u5355\uff0c\u5c31\u662f\u51e0\u6761SQL\u8bed\u53e5\uff0c\u6ca1\u4ec0\u4e48\u597d\u89e3\u91ca\u7684\uff0c\u4e0b\u9762\u6765\u770b\u4e00\u4e0b\uff0c\u5982\u4f55\u8bfb\u5165csv \u6587\u4ef6\uff0c\u7136\u540e\u63d2\u5165\u5230mysql\u6570\u636e\u5e93\u4e2d\u3002<\/p>\n<p><strong>3. \u63d2\u5165csv \u6587\u4ef6<\/strong><\/p>\n<p>\u4e0a\u9762\u521b\u5efa\u4e86\u4e00\u4e2a\u5b66\u751f\u8868\uff0c\u8868\u4e2d\u6709\u5b66\u751f\u7684\u5b66\u53f7\uff0c\u59d3\u540d\uff0c\u6210\u7ee9\uff0c\u7cfb\u522b\uff0c\u5047\u8bbe\u6709\u4e00\u4e2acsv\u6587\u4ef6\uff0c\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut20597\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code20597\" class=\"codebody\">$cat data<br \/>\n1,Navin M,98,CS<br \/>\n2,Kavya N,70,CS<br \/>\n3,Nawaz O,80,CS<br \/>\n4,Hari S,80,EC<br \/>\n5,Alex M,50,EC<br \/>\n6,Neenu J,70,EC<br \/>\n7,Bob A,30,EC<br \/>\n8,Anu M,90,AE<br \/>\n9,Sruthi,89,AE<br \/>\n10,Andrew,89,AE<\/div>\n<p>\u4e3a\u4e86\u5c06csv \u6587\u4ef6\u63d2\u5165\u5230\u6570\u636e\u5e93\uff0c\u6211\u4eec\u9700\u8981\u9010\u884c\u8bfb\u5165\uff0c\u7136\u540e\u7ed9\u5b57\u7b26\u4e32\u52a0\u4e0a\u53cc\u5f15\u53f7\uff0c\u6700\u540e\u751f\u6210\u8bed\u53e5\u5982\u4e0b\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut2034\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code2034\" class=\"codebody\">\ninsert into students VALUES(1, &#8220;Navin M&#8221;, 98, &#8220;CS&#8221;);<\/div>\n<p>\u8981\u89e3\u6790csv \u6587\u4ef6\uff0c\u6700\u597d\u7684\u5de5\u5177\u83ab\u8fc7\u4e8eawk\u4e86\uff0c\u5c06\u57df\u7684\u5206\u9694\u7b26\u6307\u5b9a\u4e3a\u9017\u53f7-F,\uff0cawk\u5c31\u81ea\u52a8\u5c06\u5404\u4e2a\u57df\u62c6\u5206\u51fa\u6765\u4e86\uff0c\u7136\u540e\u5728\u9700\u8981\u53cc\u5f15\u53f7\u7684\u5730\u65b9\u6253\u5370\u8f93\u51fa\u4e00\u4e2a\u53cc\u5f15\u53f7\uff0c\u5c31\u80fd\u591f\u8f7b\u677e\u5f97\u5230\u4e0b\u9762\u8fd9\u6837\u7684\u6570\u636e\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut84280\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code84280\" class=\"codebody\">1, &#8220;Navin M&#8221;, 98, &#8220;CS&#8221; awk \u4ee3\u7801\u5982\u4e0b\uff1a<br \/>\nquery=`echo $line | awk -F, &#8216;{ printf(&#8220;%s,\\&#8221;%s\\&#8221;,%s,\\&#8221;%s\\&#8221;&#8221;, $1, $2, $3, $4)}&#8217;`<br \/>\nstatement=`echo &#8220;INSERT INTO $TABLE VALUES($query);&#8221;`<br \/>\necho $statement<\/div>\n<p>\u5f53\u7136\u4e86\uff0c\u4f60\u4e5f\u53ef\u4ee5\u7528\u5176\u4ed6\u529e\u6cd5\uff0c\u4e0d\u8fc7\uff0c\u51e0\u4e4e\u6ca1\u6709\u6bd4awk\u66f4\u7b80\u5355\u7684\u4e86\uff0c\u7b2c2\u79cd\u65b9\u6cd5\u5982\u4e0b\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut10984\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code10984\" class=\"codebody\">\noldIFS=$IFS<br \/>\nIFS=,<br \/>\nvalues=($line)values[1]=&#8221;\\&#8221;`echo ${values[1]} | tr &#8216; &#8216; &#8216;#&#8217; `\\&#8221;&#8221;<br \/>\nvalues[3]=&#8221;\\&#8221;`echo ${values[3]}`\\&#8221;&#8221;<\/p>\n<p>query=`echo ${values[@]} | tr &#8216; #&#8217; &#8216;, &#8216;`<br \/>\nIFS=$oldIFS<\/p>\n<p>statement=`echo &#8220;INSERT INTO $TABLE VALUES($query);&#8221;`<br \/>\necho &#8220;$statement&#8221;<\/p>\n<\/div>\n<p>\u9996\u5148\u901a\u8fc7\u6307\u5b9a\u57df\u5206\u9694\u7b26\uff0c\u5c06csv\u6587\u4ef6\u89e3\u6790\u6210\u4e00\u4e2a\u6570\u7ec4\uff0c\u7136\u540e\u5c06\u7a7a\u683c\u66ff\u6362\u6210\u4e00\u4e2a\u7279\u6b8a\u7684\u7b26\u53f7&#8221;#&#8221;\uff08\u56e0\u4e3a\u540e\u9762\u7684\u66ff\u6362\u4e2d\uff0c\u4f1a\u4e00\u6b21\u6027\u8f93\u51fa\u6570\u7ec4\uff0c\u800c\u6570\u7ec4\u662f\u7528\u7a7a\u683c\u5206\u9694\u5404\u5b57\u6bb5,\u6211\u4eec\u8981\u5c06\u5206\u9694\u6570\u7ec4\u7684\u7a7a\u683c\u66ff\u6362\u6210\u9017\u53f7\uff0c\u6240\u4ee5\u8fd9\u91cc\u5c06\u6570\u636e\u4e2d\u7684\u7a7a\u683c\u66ff\u6362\u6210&#8221;#&#8221;\uff09 \uff0c\u7ed9\u5b57\u7b26\u4e32\u52a0\u4e0a\u53cc\u5f15\u53f7\uff0c\u6700\u540e\u518d\u628a\u7a7a\u683c\u66ff\u6362\u6210\u9017\u53f7\uff0c\u628a&#8221;#&#8221;\u66ff\u6362\u4e3a\u7a7a\u683c\u3002\u8fd9\u79cd\u65b9\u6cd5\u771f\u662f\u8ba9\u4eba\u6293\u72c2\uff0c\u6211\u7b2c\u4e00\u6b21\u5c31\u6ca1\u6709\u770b\u660e\u767d\uff0c\u5c24\u5176\u662f\u4e3a\u4ec0\u4e48\u8981\u5c06\u7a7a\u683c\u66ff\u6362\u6210&#8221;#&#8221;\u3002<\/p>\n<p>\u5b8c\u6574\u7684\u63d2\u5165\u6570\u636e\u7684\u7a0b\u5e8f\u5982\u4e0b\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut30874\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code30874\" class=\"codebody\">\n#!\/bin\/bash<br \/>\n#<br \/>\n# @file write_to_db_mysql.sh<br \/>\n# @brief wirte data to database in mysql<br \/>\n# @author Mingxing LAI<br \/>\n# @version 0.1<br \/>\n# @date 2013-01-20<br \/>\n#USER=&#8221;root&#8221;<br \/>\nDATABASE=&#8221;students&#8221;<br \/>\nTABLE=&#8221;students&#8221;<br \/>\nif [ $# -ne 1 ]; then<br \/>\necho $0 DATAFILE<br \/>\necho<br \/>\nexit 2<br \/>\nfi<br \/>\ndata=$1<br \/>\nwhile\u00a0 read line;<br \/>\ndo<br \/>\n#\u00a0\u00a0 query=`echo $line | awk -F, &#8216;{ printf(&#8220;%s,\\&#8221;%s\\&#8221;,%s,\\&#8221;%s\\&#8221;&#8221;, $1, $2, $3, $4)}&#8217;`<br \/>\noldIFS=$IFS<br \/>\nIFS=,<br \/>\nvalues=($line)<br \/>\nvalues[1]=&#8221;\\&#8221;`echo ${values[1]} | tr &#8216; &#8216; &#8216;#&#8217; `\\&#8221;&#8221;<br \/>\nvalues[3]=&#8221;\\&#8221;`echo ${values[3]}`\\&#8221;&#8221;<br \/>\nquery=`echo ${values[@]} | tr &#8216; #&#8217; &#8216;, &#8216;`<br \/>\nIFS=$oldIFS<br \/>\nstatement=`echo &#8220;INSERT INTO $TABLE VALUES($query);&#8221;`<br \/>\n#\u00a0\u00a0 echo $statement<\/p>\n<p>mysql -u $USER $DATABASE &lt;&lt; EOF<br \/>\nINSERT INTO $TABLE VALUES($query);<br \/>\nEOF<br \/>\ndone &lt; $data<br \/>\nif [[ $? -eq 0 ]]; then<br \/>\necho &#8220;Wrote data into DB&#8221;<br \/>\nfi<\/p>\n<\/div>\n<p><strong>4. \u8bfb\u53d6\u6570\u636e<\/strong><\/p>\n<p>\u77e5\u9053\u600e\u4e48\u5728shell \u4e2d\u8fde\u63a5mysql \uff0c\u4e5f\u77e5\u9053\u4e86\u600e\u4e48\u5728shell\u4e2d\u6279\u91cf\u6267\u884csql \u8bed\u53e5\uff0c\u8bfb\u53d6\u6570\u636e\uff0c\u5c31\u6ca1\u6709\u4efb\u4f55\u96be\u5ea6\u4e86\u3002<\/p>\n<div class=\"codetitle\"><a id=\"copybut97762\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code97762\" class=\"codebody\">#!\/bin\/bash<br \/>\n#<br \/>\n# @file read_db_mysql.sh<br \/>\n# @brief read data from mysql<br \/>\n# @author Mingxing LAI<br \/>\n# @version 0.1<br \/>\n# @date 2013-01-20<br \/>\n#USER=&#8221;root&#8221;<br \/>\nDATABASE=&#8221;students&#8221;<br \/>\nTABLE=&#8221;students&#8221;<\/p>\n<p>#\u7528tail \u53bb\u6389\u8868\u5934<br \/>\ndepts=`mysql -u $USER $DATABASE &lt;&lt;EOF | tail -n +2<br \/>\nSELECT DISTINCT dept FROM $TABLE;<br \/>\nEOF`<\/p>\n<p>for d in $depts; do<br \/>\necho Department: $d<br \/>\nresult=&#8221;`mysql -u $USER $DATABASE &lt;&lt; EOF<br \/>\nset @i:=0;<br \/>\nSELECT @i:=@i+1 as rank, name, mark FROM students WHERE dept=&#8221;$d&#8221; ORDER BY mark DESC;<br \/>\nEOF`&#8221;<\/p>\n<p>echo &#8220;$result&#8221;<br \/>\necho<br \/>\ndone<\/p>\n<\/div>\n<p>\u6211\u4eec\u8fd8\u53ef\u4ee5\u5728mysql\u8bed\u53e5\u4e2d\uff0c\u4f7f\u7528\u9009\u9879\u6765\u63a7\u5236\u6570\u636e\u7684\u8f93\u51fa\u683c\u5f0f<\/p>\n<p>-H \u8f93\u51fa\u4e3ahtml<br \/>\n-X \u8f93\u51fa\u4e3axml<\/p>\n<p>\u5982\u4e0b\u6240\u793a\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut97098\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code97098\" class=\"codebody\">\n#!\/bin\/bash<br \/>\nUSER=&#8221;root&#8221;<br \/>\nDATABASE=&#8221;students&#8221;<br \/>\nTABLE=&#8221;students&#8221;mysql -u $USER $DATABASE -H &lt;&lt; EOF<br \/>\nselect * from $TABLE<br \/>\nEOF<\/p>\n<\/div>\n<p>html \u683c\u5f0f\u7684\u53ef\u8bfb\u6027\u6bd4\u8f83\u5dee\uff0c\u8f93\u51fa\u6548\u679c\u5982\u4e0b\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut72531\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code72531\" class=\"codebody\">&lt;TABLE BORDER=1&gt;&lt;TR&gt;&lt;TH&gt;id&lt;\/TH&gt;&lt;TH&gt;name&lt;\/TH&gt;&lt;TH&gt;mark&lt;\/TH&gt;&lt;TH&gt;dept&lt;\/TH&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;1&lt;\/TD&gt;&lt;TD&gt;Navin M&lt;\/TD&gt;&lt;TD&gt;98&lt;\/TD&gt;&lt;TD&gt;CS&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;2&lt;\/TD&gt;&lt;TD&gt; Kavya N&lt;\/TD&gt;&lt;TD&gt;70&lt;\/TD&gt;&lt;TD&gt;CS&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;3&lt;\/TD&gt;&lt;TD&gt; Nawaz O&lt;\/TD&gt;&lt;TD&gt;80&lt;\/TD&gt;&lt;TD&gt;CS&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;4&lt;\/TD&gt;&lt;TD&gt;Hari S&lt;\/TD&gt;&lt;TD&gt;80&lt;\/TD&gt;&lt;TD&gt;EC&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;5&lt;\/TD&gt;&lt;TD&gt;Alex M&lt;\/TD&gt;&lt;TD&gt;50&lt;\/TD&gt;&lt;TD&gt;EC&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;6&lt;\/TD&gt;&lt;TD&gt;Neenu J&lt;\/TD&gt;&lt;TD&gt;70&lt;\/TD&gt;&lt;TD&gt;EC&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;7&lt;\/TD&gt;&lt;TD&gt;Bob A&lt;\/TD&gt;&lt;TD&gt;30&lt;\/TD&gt;&lt;TD&gt;EC&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;8&lt;\/TD&gt;&lt;TD&gt;Anu M&lt;\/TD&gt;&lt;TD&gt;90&lt;\/TD&gt;&lt;TD&gt;AE&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;9&lt;\/TD&gt;&lt;TD&gt;Sruthi&lt;\/TD&gt;&lt;TD&gt;89&lt;\/TD&gt;&lt;TD&gt;AE&lt;\/TD&gt;&lt;\/TR&gt;&lt;TR&gt;&lt;TD&gt;10&lt;\/TD&gt;&lt;TD&gt;Andrew&lt;\/TD&gt;&lt;TD&gt;89&lt;\/TD&gt;&lt;TD&gt;AE&lt;\/TD&gt;&lt;\/TR&gt;&lt;\/TABLE&gt;<\/div>\n<p>\u53ef\u8bfb\u6027\u5dee\u4e5f\u53ef\u4ee5\u7406\u89e3\uff0c\u56e0\u4e3a\u4eba\u5bb6\u89c9\u5f97\uff0c\u4f60\u6ca1\u5fc5\u8981\u4fee\u6539\u4e48\uff0c\u76f4\u63a5\u4ee5html\u5f62\u5f0f\u5c55\u793a\u6570\u636e\u5c31\u53ef\u4ee5\u4e86\u3002<\/p>\n<div class=\"codetitle\"><a id=\"copybut46232\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code46232\" class=\"codebody\">id\u00a0\u00a0\u00a0 name\u00a0\u00a0\u00a0 mark\u00a0\u00a0\u00a0 dept<br \/>\n1\u00a0\u00a0\u00a0 Navin M\u00a0\u00a0\u00a0 98\u00a0\u00a0\u00a0 CS<br \/>\n2\u00a0\u00a0\u00a0 Kavya N\u00a0\u00a0\u00a0 70\u00a0\u00a0\u00a0 CS<br \/>\n3\u00a0\u00a0\u00a0 Nawaz O\u00a0\u00a0\u00a0 80\u00a0\u00a0\u00a0 CS<br \/>\n4\u00a0\u00a0\u00a0 Hari S\u00a0\u00a0\u00a0 80\u00a0\u00a0\u00a0 EC<br \/>\n5\u00a0\u00a0\u00a0 Alex M\u00a0\u00a0\u00a0 50\u00a0\u00a0\u00a0 EC<br \/>\n6\u00a0\u00a0\u00a0 Neenu J\u00a0\u00a0\u00a0 70\u00a0\u00a0\u00a0 EC<br \/>\n7\u00a0\u00a0\u00a0 Bob A\u00a0\u00a0\u00a0 30\u00a0\u00a0\u00a0 EC<br \/>\n8\u00a0\u00a0\u00a0 Anu M\u00a0\u00a0\u00a0 90\u00a0\u00a0\u00a0 AE<br \/>\n9\u00a0\u00a0\u00a0 Sruthi\u00a0\u00a0\u00a0 89\u00a0\u00a0\u00a0 AE<br \/>\n10\u00a0\u00a0\u00a0 Andrew\u00a0\u00a0\u00a0 89\u00a0\u00a0\u00a0 AE<\/div>\n<p>xml\u5f62\u5f0f\u7684\u6570\u636e\u663e\u793a\u5c31\u6bd4\u8f83\u6b63\u5e38\u4e86\uff0c\u76f4\u63a5\u5c06\u4e0a\u9762\u7684-H \u6362\u6210-X,\u8f93\u51fa\u5982\u4e0b\uff1a<\/p>\n<div class=\"codetitle\"><a id=\"copybut98571\" class=\"copybut\"><\/a><u>\u590d\u5236\u4ee3\u7801<\/u> \u4ee3\u7801\u5982\u4e0b:<\/div>\n<div id=\"code98571\" class=\"codebody\">&lt;?xml version=&#8221;1.0&#8243;?&gt;<br \/>\n&lt;resultset statement=&#8221;select * from students&#8221; xmlns:xsi=&#8221;http:\/\/www.w3.org\/2001\/XMLSchema-instance&#8221;&gt;<br \/>\n&lt;row&gt;<br \/>\n&lt;field name=&#8221;id&#8221;&gt;1&lt;\/field&gt;<br \/>\n&lt;field name=&#8221;name&#8221;&gt;Navin M&lt;\/field&gt;<br \/>\n&lt;field name=&#8221;mark&#8221;&gt;98&lt;\/field&gt;<br \/>\n&lt;field name=&#8221;dept&#8221;&gt;CS&lt;\/field&gt;<br \/>\n&lt;\/row&gt;<br \/>\n&lt;row&gt;<br \/>\n&lt;field name=&#8221;id&#8221;&gt;2&lt;\/field&gt;<br \/>\n&lt;field name=&#8221;name&#8221;&gt; Kavya N&lt;\/field&gt;<br \/>\n&lt;field name=&#8221;mark&#8221;&gt;70&lt;\/field&gt;<br \/>\n&lt;field name=&#8221;dept&#8221;&gt;CS&lt;\/field&gt;<br \/>\n&lt;\/row&gt;<br \/>\n&lt;\/resultset&gt;<\/div>\n<p>\u5b8c\u3002<\/p><\/div>","pwapp_post_content_type":"postprocessed","pwapp_preview_type":"excerpt","androapp_failover_post_content_type":"","share_text":"\u672c\u6587\u4ecb\u7ecd\u4e86\u5982\u4f55\u5728shell\u4e2d\u8bfb\u5199mysql\u6570\u636e\u5e93\u3002\u4e3b\u8981\u4ecb\u7ecd\u4e86\u5982\u4f55\u5728shell \u4e2d\u8fde\u63a5mysql\u6570\u636e\u5e93\uff0c\u5982\u4f55\u5728shell\u4e2d\u521b\u5efa\u6570\u636e\u5e93\uff0c\u521b\u5efa\u8868\uff0c\u63d2\u5165csv [&hellip;]\n\nvia http:\/\/tech.memoecho.com\/zh\/shell\/%e4%b8%ad%e6%96%87-shell%e8%84%9a%e6%9c%ac%e8%bf%9e%e6%8e%a5%e3%80%81%e8%af%bb%e5%86%99%e3%80%81%e6%93%8d%e4%bd%9cmysql%e6%95%b0%e6%8d%ae%e5%ba%93%e5%ae%9e%e4%be%8b\/","supercache":"androappsupercache","_links":{"self":[{"href":"http:\/\/tech.memoecho.com\/zh\/wp-json\/wp\/v2\/posts\/1615"}],"collection":[{"href":"http:\/\/tech.memoecho.com\/zh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/tech.memoecho.com\/zh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/tech.memoecho.com\/zh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/tech.memoecho.com\/zh\/wp-json\/wp\/v2\/comments?post=1615"}],"version-history":[{"count":1,"href":"http:\/\/tech.memoecho.com\/zh\/wp-json\/wp\/v2\/posts\/1615\/revisions"}],"predecessor-version":[{"id":1616,"href":"http:\/\/tech.memoecho.com\/zh\/wp-json\/wp\/v2\/posts\/1615\/revisions\/1616"}],"wp:attachment":[{"href":"http:\/\/tech.memoecho.com\/zh\/wp-json\/wp\/v2\/media?parent=1615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tech.memoecho.com\/zh\/wp-json\/wp\/v2\/categories?post=1615"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tech.memoecho.com\/zh\/wp-json\/wp\/v2\/tags?post=1615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}