{"id":329,"date":"2021-10-14T22:21:38","date_gmt":"2021-10-14T14:21:38","guid":{"rendered":"\/?p=329"},"modified":"2023-09-23T19:45:55","modified_gmt":"2023-09-23T11:45:55","slug":"%e4%bb%8emysql%e4%b8%ad%e8%af%bb%e5%8f%96%e8%82%a1%e7%a5%a8%e6%95%b0%e6%8d%ae-%e4%bb%8e%e9%9b%b6%e5%88%b0%e5%ae%9e%e7%9b%9810","status":"publish","type":"post","link":"\/?p=329","title":{"rendered":"\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u2014\u2014\u4ece\u96f6\u5230\u5b9e\u76d810"},"content":{"rendered":"<p><a class=\"wp-editor-md-post-content-link\" href=\"http:\/\/coderx.com.cn\/?p=310\">\u524d\u6587<\/a>\u4ecb\u7ecd\u4e86\u628a\u80a1\u7968\u6570\u636e\u5199\u5165MySQL\u7684\u8fc7\u7a0b\uff0c\u672c\u6587\u8bb0\u5f55\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u7684\u8fc7\u7a0b\u3002<\/p>\n<p>\u5230\u76ee\u524d\u4e3a\u6b62\uff0c\u6211\u4eec\u5728\u8bbf\u95ee\u80a1\u7968\u4ee3\u7801\u5217\u8868\u65f6\uff0c\u6bcf\u6b21\u9700\u8981\u901a\u8fc7BaoStock\u91cd\u65b0\u4e0b\u8f7d\u3002\u672c\u6587\u5c06\u628a\u4e0b\u8f7d\u7684\u80a1\u7968\u4ee3\u7801\u4fdd\u5b58\u5230MySQL\u4e2d\uff0c\u5728\u540e\u7eed\u8bbf\u95ee\u80a1\u7968\u5217\u8868\u65f6\uff0c\u5c31\u53ef\u4ee5\u901a\u8fc7MySQL\u8bfb\u53d6\u80a1\u7968\u4ee3\u7801\u6570\u636e\uff0c\u4ece\u800c\u907f\u514d\u6bcf\u6b21\u90fd\u8981\u91cd\u65b0\u4e0b\u8f7d\u4ee3\u7801\u5217\u8868\uff0c\u4e5f\u4ee5\u6b64\u6765\u6f14\u793a\u4eceMySQL\u4e2d\u8bfb\u53d6\u6570\u636e\u7684\u8fc7\u7a0b\u3002<\/p>\n<h1>\u4e3b\u8981\u4ee3\u7801\u5206\u6790<\/h1>\n<p>\u65b0\u5efa\u6e90\u6587\u4ef6\uff0c\u547d\u540d\u4e3adata_center_v8.py\uff0c\u5168\u90e8\u5185\u5bb9\u89c1\u6587\u672b\uff0cv8\u4e3b\u8981\u4fee\u6539\u4e86\u51fd\u6570get_stock_codes\uff1a<\/p>\n<pre><code class=\"language-python line-numbers\">def get_stock_codes(date=None, update=False):\n<\/code><\/pre>\n<p>\u8be5\u51fd\u6570\u7528\u4e8e\u83b7\u53d6\u6307\u5b9a\u65e5\u671f\u7684A\u80a1\u4ee3\u7801\u5217\u8868\uff0c\u5176\u4e2d\uff1a<br \/>\n&#8211; \u53c2\u6570date\u4e3a\u65e5\u671f\uff0c\u9ed8\u8ba4\u4e3aNone<br \/>\n&#8211; \u53c2\u6570update\u4e3a\u662f\u5426\u66f4\u65b0\u80a1\u7968\u5217\u8868\uff0c\u9ed8\u8ba4\u4e3aFalse<br \/>\n&#8211; \u8fd4\u56de\u503c\u4e3aA\u80a1\u4ee3\u7801\u7684\u5217\u8868<\/p>\n<p>\u4e0d\u540c\u7684\u53c2\u6570\u8bbe\u7f6e\uff0c\u4f1a\u67093\u79cd\u60c5\u51b5\uff1a<\/p>\n<ul>\n<li>\u82e5\u53c2\u6570update\u4e3aFalse\uff0c\u8868\u793a\u4ece\u6570\u636e\u5e93\u4e2d\u8bfb\u53d6\u80a1\u7968\u5217\u8868<\/li>\n<li>\u82e5\u6570\u636e\u5e93\u4e2d\u4e0d\u5b58\u5728\u80a1\u7968\u5217\u8868\u7684\u8868\uff0c\u6216\u8005update\u4e3aTrue\uff0c\u5219\u4e0b\u8f7d\u6307\u5b9a\u65e5\u671fdate\u7684\u4ea4\u6613\u80a1\u7968\u5217\u8868<\/li>\n<li>\u82e5\u53c2\u6570date\u4e3a\u7a7a\uff0c\u5219\u8fd4\u56de\u6700\u8fd11\u4e2a\u4ea4\u6613\u65e5\u7684A\u80a1\u4ee3\u7801\u5217\u8868<\/li>\n<li>\u82e5\u53c2\u6570date\u4e0d\u4e3a\u7a7a\uff0c\u4e14\u4e3a\u4ea4\u6613\u65e5\uff0c\u5219\u8fd4\u56dedate\u5f53\u65e5\u7684A\u80a1\u4ee3\u7801\u5217\u8868<\/li>\n<li>\u82e5\u53c2\u6570date\u4e0d\u4e3a\u7a7a\uff0c\u4f46\u4e0d\u4e3a\u4ea4\u6613\u65e5\uff0c\u5219\u6253\u5370\u63d0\u793a\u975e\u4ea4\u6613\u65e5\u4fe1\u606f\uff0c\u7a0b\u5e8f\u9000\u51fa<\/li>\n<\/ul>\n<p>\u7efc\u4e0a\uff0c\u5728\u9ed8\u8ba4\u53c2\u6570\u6761\u4ef6\u4e0b\uff1a<\/p>\n<ul>\n<li>\u82e5\u7a0b\u5e8f\u662f\u7b2c\u4e00\u6b21\u8fd0\u884c\uff0c\u5219\u4e0b\u8f7d\u6700\u8fd11\u4e2a\u4ea4\u6613\u7684A\u80a1\u4ee3\u7801\u5217\u8868\uff0c\u5e76\u4fdd\u5b58\u5728\u6570\u636e\u5e93\u4e2d<\/li>\n<li>\u82e5\u7a0b\u5e8f\u4e0d\u662f\u7b2c\u4e00\u6b21\u8fd0\u884c\uff0c\u5219\u4f1a\u4ece\u6570\u636e\u5e93\u4e2d\u8bfb\u53d6A\u80a1\u5217\u8868<\/li>\n<\/ul>\n<pre><code class=\"language-python line-numbers\">    engine = create_mysql_engine()\n<\/code><\/pre>\n<p>\u521b\u5efa\u6570\u636e\u5e93\u5f15\u64ce\u5bf9\u8c61\uff0c\u7528\u5224\u65ad\u8868\u662f\u5426\u5b58\u5728\u53ca\u8bfb\u5199\u8868\u6570\u636e\u3002<\/p>\n<pre><code class=\"language-python line-numbers\">    table_name = 'stock_codes'\n<\/code><\/pre>\n<p>\u6570\u636e\u5e93\u4e2d\u80a1\u7968\u4ee3\u7801\u7684\u8868\u540d\u3002<\/p>\n<pre><code class=\"language-python line-numbers\">    if table_name not in sqlalchemy.inspect(engine).get_table_names() or update:\n<\/code><\/pre>\n<p>\u6570\u636e\u5e93\u4e2d\u4e0d\u5b58\u5728\u80a1\u7968\u4ee3\u7801\u8868\uff0c\u6216\u8005\u9700\u8981\u66f4\u65b0\u80a1\u7968\u4ee3\u7801\u8868\u3002<\/p>\n<pre><code class=\"language-python line-numbers\">        # \u767b\u5f55baostock\n        bs.login()\n\n        # \u4eceBaoStock\u67e5\u8be2\u80a1\u7968\u6570\u636e\n        stock_df = bs.query_all_stock(date).get_data()\n\n        # \u5982\u679c\u83b7\u53d6\u6570\u636e\u957f\u5ea6\u4e3a0\uff0c\u8868\u793a\u65e5\u671fdate\u975e\u4ea4\u6613\u65e5\n        if 0 == len(stock_df):\n\n            # \u5982\u679c\u8bbe\u7f6e\u4e86\u53c2\u6570date\uff0c\u5219\u6253\u5370\u4fe1\u606f\u63d0\u793adate\u4e3a\u975e\u4ea4\u6613\u65e5\n            if date is not None:\n                print('\u5f53\u524d\u9009\u62e9\u65e5\u671f\u4e3a\u975e\u4ea4\u6613\u65e5\u6216\u5c1a\u65e0\u4ea4\u6613\u6570\u636e\uff0c\u8bf7\u8bbe\u7f6edate\u4e3a\u5386\u53f2\u67d0\u4ea4\u6613\u65e5\u65e5\u671f')\n                sys.exit(0)\n\n            # \u672a\u8bbe\u7f6e\u53c2\u6570date\uff0c\u5219\u5411\u5386\u53f2\u67e5\u627e\u6700\u8fd1\u7684\u4ea4\u6613\u65e5\uff0c\u5f53\u83b7\u53d6\u80a1\u7968\u6570\u636e\u957f\u5ea6\u975e0\u65f6\uff0c\u5373\u627e\u5230\u6700\u8fd1\u4ea4\u6613\u65e5\n            delta = 1\n            while 0 == len(stock_df):\n                stock_df = bs.query_all_stock(datetime.date.today() - datetime.timedelta(days=delta)).get_data()\n                delta += 1\n\n        # \u6ce8\u9500\u767b\u5f55\n        bs.logout()\n\n        # \u7b5b\u9009\u80a1\u7968\u6570\u636e\uff0c\u4e0a\u8bc1\u548c\u6df1\u8bc1\u80a1\u7968\u4ee3\u7801\u5728sh.600000\u4e0esz.39900\u4e4b\u95f4\n        stock_df = stock_df[(stock_df['code'] &gt;= 'sh.600000') &amp; (stock_df['code'] &lt; 'sz.399000')]\n<\/code><\/pre>\n<p>\u901a\u8fc7\u67e5\u8be2BaoStock\u66f4\u65b0\u80a1\u7968\u5217\u8868\u4ee3\u7801\uff0c\u4e0a\u9762\u4ee3\u7801\u4e0ev1\u5185\u5bb9\u76f8\u540c\uff0c\u53ef\u53c2\u8003<a class=\"wp-editor-md-post-content-link\" href=\"https:\/\/coderx.com.cn\/?p=57\">v1\u5206\u6790\u5185\u5bb9<\/a>\u3002<\/p>\n<pre><code class=\"language-python line-numbers\">        stock_df.to_sql(name=table_name, con=engine, if_exists='replace', index=False, index_label=False)\n<\/code><\/pre>\n<p>\u8c03\u7528DataFrame\u7684to_sql\u65b9\u6cd5\u5c06\u80a1\u7968\u4ee3\u7801\u5199\u5165\u6570\u636e\u5e93\u3002<\/p>\n<pre><code class=\"language-python line-numbers\">        return stock_df['code'].tolist()\n<\/code><\/pre>\n<p>\u8fd4\u56de\u80a1\u7968\u5217\u8868\u3002<\/p>\n<pre><code class=\"language-python line-numbers\">    else:\n<\/code><\/pre>\n<p>\u4ece\u6570\u636e\u5e93\u4e2d\u8bfb\u53d6\u80a1\u7968\u4ee3\u7801\u5217\u8868\u3002<\/p>\n<pre><code class=\"language-python line-numbers\">        sql_cmd = 'SELECT {} FROM {}'.format('code', table_name)\n<\/code><\/pre>\n<p>\u5f85\u6267\u884c\u7684sql\u8bed\u53e5\u3002<\/p>\n<pre><code class=\"language-python line-numbers\">        return pd.read_sql(sql=sql_cmd, con=engine)['code'].tolist()\n<\/code><\/pre>\n<p>\u8c03\u7528read_sql\u65b9\u6cd5\uff0c\u6267\u884csql\u547d\u4ee4\uff0c\u5e76\u8fd4\u56deDataFrame\u3002read_sql\u7684\u53c2\u6570sql\u8868\u793a\u8981\u6267\u884c\u7684sql\u547d\u4ee4\uff0c con\u8868\u793a\u521b\u5efa\u7684\u6570\u636e\u5e93\u8fde\u63a5\uff0c\u8fd4\u56de\u503c\u7684\u6570\u636e\u7c7b\u578b\u662fDataFrame\u3002\u4e0b\u56fe\u5c55\u793a\u4e86\u6211\u4eec\u901a\u8fc7MySQL workbench\u67e5\u770b\u7684\u8868stock_codes\u7684\u5185\u5bb9\u3002\u6211\u4eec\u63d0\u53d6\u5176\u4e2d\u7684code\u5217\uff0c\u8f6c\u5316\u4e3alist\u5e76\u8fd4\u56de\u3002<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/coderx.com.cn\/wordpress\/wp-content\/uploads\/2021\/10\/stock_codes.png\" alt=\"\" \/><\/p>\n<h1>\u5c0f\u7ed3<\/h1>\n<p>\u81f3\u6b64\uff0c\u6211\u4eec\u5b8c\u6210\u4e86\u80a1\u7968\u4ee3\u7801\u6570\u636e\u7684\u6570\u636e\u5e93\u5199\u5165\u548c\u8bfb\u51fa\u529f\u80fd\uff0c\u53ef\u4ee5\u901a\u8fc7\u6570\u636e\u5e93\u8bfb\u53d6\u80a1\u7968\u4ee3\u7801\uff0c\u800c\u4e0d\u5fc5\u6bcf\u6b21\u90fd\u53bbBaoStock\u91cd\u65b0\u4e0b\u8f7d\u3002<\/p>\n<p>\u901a\u8fc7pandas\u7684read_sql\u548cto_sql\u65b9\u6cd5\uff0c\u53ef\u4ee5\u65b9\u4fbf\u5730\u5b8c\u6210DataFrame\u5bf9MySQL\u7684\u8bfb\u5199\u64cd\u4f5c\u3002<\/p>\n<p>\u4e0b\u4e00\u7bc7\u6587\u7ae0\u5c06\u8bb0\u5f55\u4eceMySQL\u4e2d\u8bfb\u53d6\u65e5\u7ebf\u53ca\u56e0\u5b50\u6570\u636e\uff0c\u5e76\u5c1d\u8bd5\u5bf9\u7b56\u7565\u7684\u80dc\u7387\u8fdb\u884c\u5206\u6790\u3002<\/p>\n<hr \/>\n<p>data_center_v8.py\u7684\u5168\u90e8\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n<pre><code class=\"language-python line-numbers\">import baostock as bs\nimport datetime\nimport sys\nimport numpy as np\nimport pandas as pd\nimport multiprocessing\nimport sqlalchemy\n\n# \u53ef\u7528\u65e5\u7ebf\u6570\u91cf\u7ea6\u675f\ng_available_days_limit = 250\n\n# BaoStock\u65e5\u7ebf\u6570\u636e\u5b57\u6bb5\ng_baostock_data_fields = 'date,open,high,low,close,preclose,volume,amount,adjustflag,turn,tradestatus,pctChg,peTTM,pbMRQ, psTTM,pcfNcfTTM,isST'\n\n\ndef create_mysql_engine():\n    \"\"\"\n    \u521b\u5efa\u6570\u636e\u5e93\u5f15\u64ce\u5bf9\u8c61\n\n    :return: \u65b0\u521b\u5efa\u7684\u6570\u636e\u5e93\u5f15\u64ce\u5bf9\u8c61\n    \"\"\"\n\n    # \u5f15\u64ce\u53c2\u6570\u4fe1\u606f\n    host = 'localhost'\n    user = 'root'\n    passwd = '111111'\n    port = '3306'\n    db = 'db_quant'\n\n    # \u521b\u5efa\u6570\u636e\u5e93\u5f15\u64ce\u5bf9\u8c61\n    mysql_engine = sqlalchemy.create_engine(\n        'mysql+pymysql:\/\/{0}:{1}@{2}:{3}'.format(user, passwd, host, port),\n        poolclass=sqlalchemy.pool.NullPool\n    )\n\n    # \u5982\u679c\u4e0d\u5b58\u5728\u6570\u636e\u5e93db_quant\u5219\u521b\u5efa\n    mysql_engine.execute(\"CREATE DATABASE IF NOT EXISTS {0} \".format(db))\n\n    # \u521b\u5efa\u8fde\u63a5\u6570\u636e\u5e93db_quant\u7684\u5f15\u64ce\u5bf9\u8c61\n    db_engine = sqlalchemy.create_engine(\n        'mysql+pymysql:\/\/{0}:{1}@{2}:{3}\/{4}?charset=utf8'.format(user, passwd, host, port, db),\n        poolclass=sqlalchemy.pool.NullPool\n    )\n\n    # \u8fd4\u56de\u5f15\u64ce\u5bf9\u8c61\n    return db_engine\n\n\ndef get_stock_codes(date=None, update=False):\n    \"\"\"\n    \u83b7\u53d6\u6307\u5b9a\u65e5\u671f\u7684A\u80a1\u4ee3\u7801\u5217\u8868\n\n    \u82e5\u53c2\u6570update\u4e3aFalse\uff0c\u8868\u793a\u4ece\u6570\u636e\u5e93\u4e2d\u8bfb\u53d6\u80a1\u7968\u5217\u8868\n    \u82e5\u6570\u636e\u5e93\u4e2d\u4e0d\u5b58\u5728\u80a1\u7968\u5217\u8868\u7684\u8868\uff0c\u6216\u8005update\u4e3aTrue\uff0c\u5219\u4e0b\u8f7d\u6307\u5b9a\u65e5\u671fdate\u7684\u4ea4\u6613\u80a1\u7968\u5217\u8868\n    \u82e5\u53c2\u6570date\u4e3a\u7a7a\uff0c\u5219\u8fd4\u56de\u6700\u8fd11\u4e2a\u4ea4\u6613\u65e5\u7684A\u80a1\u4ee3\u7801\u5217\u8868\n    \u82e5\u53c2\u6570date\u4e0d\u4e3a\u7a7a\uff0c\u4e14\u4e3a\u4ea4\u6613\u65e5\uff0c\u5219\u8fd4\u56dedate\u5f53\u65e5\u7684A\u80a1\u4ee3\u7801\u5217\u8868\n    \u82e5\u53c2\u6570date\u4e0d\u4e3a\u7a7a\uff0c\u4f46\u4e0d\u4e3a\u4ea4\u6613\u65e5\uff0c\u5219\u6253\u5370\u63d0\u793a\u975e\u4ea4\u6613\u65e5\u4fe1\u606f\uff0c\u7a0b\u5e8f\u9000\u51fa\n\n    :param date: \u65e5\u671f\uff0c\u9ed8\u8ba4\u4e3aNone\n    :param update: \u662f\u5426\u66f4\u65b0\u80a1\u7968\u5217\u8868\uff0c\u9ed8\u8ba4\u4e3aFalse\n    :return: A\u80a1\u4ee3\u7801\u7684\u5217\u8868\n    \"\"\"\n\n    # \u521b\u5efa\u6570\u636e\u5e93\u5f15\u64ce\u5bf9\u8c61\n    engine = create_mysql_engine()\n\n    # \u6570\u636e\u5e93\u4e2d\u80a1\u7968\u4ee3\u7801\u7684\u8868\u540d\n    table_name = 'stock_codes'\n\n    # \u6570\u636e\u5e93\u4e2d\u4e0d\u5b58\u5728\u80a1\u7968\u4ee3\u7801\u8868\uff0c\u6216\u8005\u9700\u8981\u66f4\u65b0\u80a1\u7968\u4ee3\u7801\u8868\n    if table_name not in sqlalchemy.inspect(engine).get_table_names() or update:\n\n        # \u767b\u5f55baostock\n        bs.login()\n\n        # \u4eceBaoStock\u67e5\u8be2\u80a1\u7968\u6570\u636e\n        stock_df = bs.query_all_stock(date).get_data()\n\n        # \u5982\u679c\u83b7\u53d6\u6570\u636e\u957f\u5ea6\u4e3a0\uff0c\u8868\u793a\u65e5\u671fdate\u975e\u4ea4\u6613\u65e5\n        if 0 == len(stock_df):\n\n            # \u5982\u679c\u8bbe\u7f6e\u4e86\u53c2\u6570date\uff0c\u5219\u6253\u5370\u4fe1\u606f\u63d0\u793adate\u4e3a\u975e\u4ea4\u6613\u65e5\n            if date is not None:\n                print('\u5f53\u524d\u9009\u62e9\u65e5\u671f\u4e3a\u975e\u4ea4\u6613\u65e5\u6216\u5c1a\u65e0\u4ea4\u6613\u6570\u636e\uff0c\u8bf7\u8bbe\u7f6edate\u4e3a\u5386\u53f2\u67d0\u4ea4\u6613\u65e5\u65e5\u671f')\n                sys.exit(0)\n\n            # \u672a\u8bbe\u7f6e\u53c2\u6570date\uff0c\u5219\u5411\u5386\u53f2\u67e5\u627e\u6700\u8fd1\u7684\u4ea4\u6613\u65e5\uff0c\u5f53\u83b7\u53d6\u80a1\u7968\u6570\u636e\u957f\u5ea6\u975e0\u65f6\uff0c\u5373\u627e\u5230\u6700\u8fd1\u4ea4\u6613\u65e5\n            delta = 1\n            while 0 == len(stock_df):\n                stock_df = bs.query_all_stock(datetime.date.today() - datetime.timedelta(days=delta)).get_data()\n                delta += 1\n\n        # \u6ce8\u9500\u767b\u5f55\n        bs.logout()\n\n        # \u7b5b\u9009\u80a1\u7968\u6570\u636e\uff0c\u4e0a\u8bc1\u548c\u6df1\u8bc1\u80a1\u7968\u4ee3\u7801\u5728sh.600000\u4e0esz.39900\u4e4b\u95f4\n        stock_df = stock_df[(stock_df['code'] &gt;= 'sh.600000') &amp; (stock_df['code'] &lt; 'sz.399000')]\n\n        # \u5c06\u80a1\u7968\u4ee3\u7801\u5199\u5165\u6570\u636e\u5e93\n        stock_df.to_sql(name=table_name, con=engine, if_exists='replace', index=False, index_label=False)\n\n        # \u8fd4\u56de\u80a1\u7968\u5217\u8868\n        return stock_df['code'].tolist()\n\n    # \u4ece\u6570\u636e\u5e93\u4e2d\u8bfb\u53d6\u80a1\u7968\u4ee3\u7801\u5217\u8868\n    else:\n\n        # \u5f85\u6267\u884c\u7684sql\u8bed\u53e5\n        sql_cmd = 'SELECT {} FROM {}'.format('code', table_name)\n\n        # \u8bfb\u53d6sql\uff0c\u8fd4\u56de\u80a1\u7968\u5217\u8868\n        return pd.read_sql(sql=sql_cmd, con=engine)['code'].tolist()\n\n\ndef create_data(stock_codes, from_date='1990-12-19', to_date=datetime.date.today().strftime('%Y-%m-%d'),\n                adjustflag='2'):\n    \"\"\"\n    \u4e0b\u8f7d\u6307\u5b9a\u65e5\u671f\u5185\uff0c\u6307\u5b9a\u80a1\u7968\u7684\u65e5\u7ebf\u6570\u636e\uff0c\u8ba1\u7b97\u6269\u5c55\u56e0\u5b50\n\n    :param stock_codes: \u5f85\u4e0b\u8f7d\u6570\u636e\u7684\u80a1\u7968\u4ee3\u7801\n    :param from_date: \u65e5\u7ebf\u5f00\u59cb\u65e5\u671f\n    :param to_date: \u65e5\u7ebf\u7ed3\u675f\u65e5\u671f\n    :param adjustflag: \u590d\u6743\u9009\u9879 1\uff1a\u540e\u590d\u6743  2\uff1a\u524d\u590d\u6743  3\uff1a\u4e0d\u590d\u6743  \u9ed8\u8ba4\u4e3a\u524d\u590d\u6743\n    :return: None\n    \"\"\"\n\n    # \u521b\u5efa\u6570\u636e\u5e93\u5f15\u64ce\u5bf9\u8c61\n    engine = create_mysql_engine()\n\n    # \u4e0b\u8f7d\u80a1\u7968\u5faa\u73af\n    for code in stock_codes:\n        print('\u6b63\u5728\u4e0b\u8f7d{}...'.format(code))\n\n        # \u767b\u5f55BaoStock\n        bs.login()\n\n        # \u4e0b\u8f7d\u65e5\u7ebf\u6570\u636e\n        out_df = bs.query_history_k_data_plus(code, g_baostock_data_fields, start_date=from_date, end_date=to_date,\n                                              frequency='d', adjustflag=adjustflag).get_data()\n\n        # \u5254\u9664\u505c\u76d8\u6570\u636e\n        if out_df.shape[0]:\n            out_df = out_df[(out_df['volume'] != '0') &amp; (out_df['volume'] != '')]\n\n        # \u5982\u679c\u6570\u636e\u4e3a\u7a7a\uff0c\u5219\u4e0d\u521b\u5efa\n        if not out_df.shape[0]:\n            continue\n\n        # \u5220\u9664\u91cd\u590d\u6570\u636e\n        out_df.drop_duplicates(['date'], inplace=True)\n\n        # \u65e5\u7ebf\u6570\u636e\u5c11\u4e8eg_available_days_limit\uff0c\u5219\u4e0d\u521b\u5efa\n        if out_df.shape[0] &lt; g_available_days_limit:\n            continue\n\n        # \u5c06\u6570\u503c\u6570\u636e\u8f6c\u4e3afloat\u578b\uff0c\u4fbf\u4e8e\u540e\u7eed\u5904\u7406\n        convert_list = ['open', 'high', 'low', 'close', 'preclose', 'volume', 'amount', 'turn', 'pctChg']\n        out_df[convert_list] = out_df[convert_list].astype(float)\n\n        # \u91cd\u7f6e\u7d22\u5f15\n        out_df.reset_index(drop=True, inplace=True)\n\n        # \u8ba1\u7b97\u6269\u5c55\u56e0\u5b50\n        out_df = extend_factor(out_df)\n\n        # \u5199\u5165\u6570\u636e\u5e93\n        table_name = '{}_{}'.format(code[3:], code[:2])\n        out_df.to_sql(name=table_name, con=engine, if_exists='replace', index=True, index_label='id')\n\n\ndef get_code_group(process_num, stock_codes):\n    \"\"\"\n    \u83b7\u53d6\u4ee3\u7801\u5206\u7ec4\uff0c\u7528\u4e8e\u591a\u8fdb\u7a0b\u8ba1\u7b97\uff0c\u6bcf\u4e2a\u8fdb\u7a0b\u5904\u7406\u4e00\u7ec4\u80a1\u7968\n\n    :param process_num: \u8fdb\u7a0b\u6570\n    :param stock_codes: \u5f85\u5904\u7406\u7684\u80a1\u7968\u4ee3\u7801\n    :return: \u5206\u7ec4\u540e\u7684\u80a1\u7968\u4ee3\u7801\u5217\u8868\uff0c\u5217\u8868\u7684\u6bcf\u4e2a\u5143\u7d20\u4e3a\u4e00\u7ec4\u80a1\u7968\u4ee3\u7801\u7684\u5217\u8868\n    \"\"\"\n\n    # \u521b\u5efa\u7a7a\u7684\u5206\u7ec4\n    code_group = [[] for i in range(process_num)]\n\n    # \u6309\u4f59\u6570\u4e3a\u6bcf\u4e2a\u5206\u7ec4\u5206\u914d\u80a1\u7968\n    for index, code in enumerate(stock_codes):\n        code_group[index % process_num].append(code)\n\n    return code_group\n\n\ndef multiprocessing_func(func, args):\n    \"\"\"\n    \u591a\u8fdb\u7a0b\u8c03\u7528\u51fd\u6570\n\n    :param func: \u51fd\u6570\u540d\n    :param args: func\u7684\u53c2\u6570\uff0c\u7c7b\u578b\u4e3a\u5143\u7ec4\uff0c\u7b2c0\u4e2a\u5143\u7d20\u4e3a\u8fdb\u7a0b\u6570\uff0c\u7b2c1\u4e2a\u5143\u7d20\u4e3a\u80a1\u7968\u4ee3\u7801\u5217\u8868\n    :return: \u5305\u542b\u5404\u5b50\u8fdb\u7a0b\u8fd4\u56de\u5bf9\u8c61\u7684\u5217\u8868\n    \"\"\"\n\n    # \u7528\u4e8e\u4fdd\u5b58\u5404\u5b50\u8fdb\u7a0b\u8fd4\u56de\u5bf9\u8c61\u7684\u5217\u8868\n    results = []\n\n    # \u521b\u5efa\u8fdb\u7a0b\u6c60\n    with multiprocessing.Pool(processes=args[0]) as pool:\n        # \u591a\u8fdb\u7a0b\u5f02\u6b65\u8ba1\u7b97\n        for codes in get_code_group(args[0], args[1]):\n            results.append(pool.apply_async(func, args=(codes, *args[2:],)))\n\n        # \u963b\u6b62\u540e\u7eed\u4efb\u52a1\u63d0\u4ea4\u5230\u8fdb\u7a0b\u6c60\n        pool.close()\n\n        # \u7b49\u5f85\u6240\u6709\u8fdb\u7a0b\u7ed3\u675f\n        pool.join()\n\n    return results\n\n\ndef create_data_mp(stock_codes, process_num=61,\n                   from_date='1990-12-19', to_date=datetime.date.today().strftime('%Y-%m-%d'), adjustflag='2'):\n    \"\"\"\n    \u4f7f\u7528\u591a\u8fdb\u7a0b\u521b\u5efa\u6307\u5b9a\u65e5\u671f\u5185\uff0c\u6307\u5b9a\u80a1\u7968\u7684\u65e5\u7ebf\u6570\u636e\uff0c\u8ba1\u7b97\u6269\u5c55\u56e0\u5b50\n\n    :param stock_codes: \u5f85\u521b\u5efa\u6570\u636e\u7684\u80a1\u7968\u4ee3\u7801\n    :param process_num: \u8fdb\u7a0b\u6570\n    :param from_date: \u65e5\u7ebf\u5f00\u59cb\u65e5\u671f\n    :param to_date: \u65e5\u7ebf\u7ed3\u675f\u65e5\u671f\n    :param adjustflag: \u590d\u6743\u9009\u9879 1\uff1a\u540e\u590d\u6743  2\uff1a\u524d\u590d\u6743  3\uff1a\u4e0d\u590d\u6743  \u9ed8\u8ba4\u4e3a\u524d\u590d\u6743\n    :return: None\n    \"\"\"\n\n    multiprocessing_func(create_data, (process_num, stock_codes, from_date, to_date, adjustflag,))\n\n\ndef extend_factor(df):\n    \"\"\"\n    \u8ba1\u7b97\u6269\u5c55\u56e0\u5b50\n\n    :param df: \u5f85\u8ba1\u7b97\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    :return: \u5305\u542b\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    \"\"\"\n\n    # \u4f7f\u7528pipe\u4f9d\u6b21\u8ba1\u7b97\u6da8\u505c\u3001\u53cc\u795e\u53ca\u662f\u5426\u4e3a\u5019\u9009\u80a1\u7968\n    df = df.pipe(zt).pipe(ss, delta_days=30).pipe(candidate)\n\n    return df\n\n\ndef zt(df):\n    \"\"\"\n    \u8ba1\u7b97\u6da8\u505c\u56e0\u5b50\n\n    \u82e5\u6da8\u505c\uff0c\u5219\u56e0\u5b50\u4e3aTrue\uff0c\u5426\u5219\u4e3aFalse\n    \u4ee5\u5f53\u65e5\u6536\u76d8\u4ef7\u8f83\u524d\u4e00\u65e5\u6536\u76d8\u4ef7\u4e0a\u6da89.8%\u53ca\u4ee5\u4e0a\u4f5c\u4e3a\u6da8\u505c\u5224\u65ad\u6807\u51c6\n\n    :param df: \u5f85\u8ba1\u7b97\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    :return: \u5305\u542b\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    \"\"\"\n\n    df['zt'] = np.where((df['close'].values &gt;= 1.098 * df['preclose'].values), True, False)\n\n    return df\n\n\ndef shift_i(df, factor_list, i, fill_value=0, suffix='a'):\n    \"\"\"\n    \u8ba1\u7b97\u79fb\u52a8\u56e0\u5b50\uff0c\u7528\u4e8e\u83b7\u53d6\u524di\u65e5\u6216\u8005\u540ei\u65e5\u7684\u56e0\u5b50\n\n    :param df: \u5f85\u8ba1\u7b97\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    :param factor_list: \u5f85\u79fb\u52a8\u7684\u56e0\u5b50\u5217\u8868\n    :param i: \u79fb\u52a8\u7684\u6b65\u6570\n    :param fill_value: \u7528\u4e8e\u586b\u5145NA\u7684\u503c\uff0c\u9ed8\u8ba4\u4e3a0\n    :param suffix: \u503c\u4e3aa(ago)\u65f6\u8868\u793a\u79fb\u52a8\u83b7\u5f97\u5386\u53f2\u6570\u636e\uff0c\u7528\u4e8e\u8ba1\u7b97\u6307\u6807\uff1b\u503c\u4e3al(later)\u65f6\u8868\u793a\u83b7\u5f97\u672a\u6765\u6570\u636e\uff0c\u7528\u4e8e\u8ba1\u7b97\u6536\u76ca\n    :return: \u5305\u542b\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    \"\"\"\n\n    # \u9009\u53d6\u9700\u8981shift\u7684\u5217\u6784\u6210\u65b0\u7684DataFrame\uff0c\u8fdb\u884cshift\u64cd\u4f5c\n    shift_df = df[factor_list].shift(i, fill_value=fill_value)\n\n    # \u5bf9\u65b0\u7684DataFrame\u5217\u8fdb\u884c\u91cd\u547d\u540d\n    shift_df.rename(columns={x: '{}_{}{}'.format(x, i, suffix) for x in factor_list}, inplace=True)\n\n    # \u5c06\u91cd\u547d\u540d\u540e\u7684DataFrame\u5408\u5e76\u5230\u539f\u59cbDataFrame\u4e2d\n    df = pd.concat([df, shift_df], axis=1)\n\n    return df\n\n\ndef shift_till_n(df, factor_list, n, fill_value=0, suffix='a'):\n    \"\"\"\n    \u8ba1\u7b97\u8303\u56f4\u79fb\u52a8\u56e0\u5b50\n\n    \u7528\u4e8e\u83b7\u53d6\u524d\/\u540en\u65e5\u5185\u7684\u76f8\u5173\u56e0\u5b50\uff0c\u5185\u90e8\u8c03\u7528\u4e86shift_i\n\n    :param df: \u5f85\u8ba1\u7b97\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    :param factor_list: \u5f85\u79fb\u52a8\u7684\u56e0\u5b50\u5217\u8868\n    :param n: \u79fb\u52a8\u7684\u6b65\u6570\u8303\u56f4\n    :param fill_value: \u7528\u4e8e\u586b\u5145NA\u7684\u503c\uff0c\u9ed8\u8ba4\u4e3a0\n    :param suffix: \u503c\u4e3aa(ago)\u65f6\u8868\u793a\u79fb\u52a8\u83b7\u5f97\u5386\u53f2\u6570\u636e\uff0c\u7528\u4e8e\u8ba1\u7b97\u6307\u6807\uff1b\u503c\u4e3al(later)\u65f6\u8868\u793a\u83b7\u5f97\u672a\u6765\u6570\u636e\uff0c\u7528\u4e8e\u8ba1\u7b97\u6536\u76ca\n    :return: \u5305\u542b\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    \"\"\"\n\n    for i in range(n):\n        df = shift_i(df, factor_list, i + 1, fill_value, suffix)\n    return df\n\n\ndef ss(df, delta_days=30):\n    \"\"\"\n    \u8ba1\u7b97\u53cc\u795e\u56e0\u5b50\uff0c\u5373\u95f4\u9694\u7684\u4e24\u4e2a\u6da8\u505c\n\n    \u82e5\u5f53\u65e5\u5f62\u6210\u53cc\u795e\uff0c\u5219\u56e0\u5b50\u4e3aTrue\uff0c\u5426\u5219\u4e3aFalse\n\n    :param df: \u5f85\u8ba1\u7b97\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    :param delta_days: \u4e24\u6839\u6da8\u505c\u95f4\u9694\u7684\u65f6\u95f4\u4e0d\u80fd\u8d85\u8fc7\u8be5\u503c\uff0c\u5426\u5219\u4e0d\u5224\u5b9a\u4e3a\u53cc\u795e\uff0c\u9ed8\u8ba4\u503c\u4e3a30\n    :return: \u5305\u542b\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    \"\"\"\n\n    # \u79fb\u52a8\u6da8\u505c\u56e0\u5b50\uff0c\u6c42\u53d6\u8fd1delta_days\u5929\u5185\u7684\u6da8\u505c\u60c5\u51b5\uff0c\u4fdd\u5b58\u5728\u4e00\u4e2a\u4e34\u65f6DataFrame\u4e2d\n    temp_df = shift_till_n(df, ['zt'], delta_days, fill_value=False)\n\n    # \u751f\u6210\u5217\u8868\uff0c\u7528\u4e8e\u540e\u7eed\u68c0\u7d22\u7b2c2\u5929\u524d\u81f3\u7b2cdelta_days\u5929\u524d\u662f\u5426\u6709\u6da8\u505c\u51fa\u73b0\n    col_list = ['zt_{}a'.format(x) for x in range(2, delta_days + 1)]\n\n    # \u8ba1\u7b97\u53cc\u795e\uff0c\u9700\u540c\u65f6\u6ee1\u8db33\u4e2a\u6761\u4ef6\uff1a\n    # 1\u3001\u7b2c2\u5929\u524d\u81f3\u7b2cdelta_days\u5929\u524d\uff0c\u81f3\u5c11\u67091\u4e2a\u6da8\u505c\n    # 2\u30011\u5929\u524d\u4e0d\u662f\u6da8\u505c\uff08\u5426\u5219\u5c31\u662f\u8fde\u7eed\u6da8\u505c\uff0c\u4e0d\u662f\u95f4\u9694\u7684\u6da8\u505c\uff09\n    # 3\u3001\u5f53\u5929\u662f\u6da8\u505c\n    df['ss'] = temp_df[col_list].any(axis=1) &amp; ~temp_df['zt_1a'] &amp; temp_df['zt']\n\n    return df\n\n\ndef ma(df, n=5, factor='close'):\n    \"\"\"\n    \u8ba1\u7b97\u5747\u7ebf\u56e0\u5b50\n\n    :param df: \u5f85\u8ba1\u7b97\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    :param n: \u5f85\u8ba1\u7b97\u5747\u7ebf\u7684\u5468\u671f\uff0c\u9ed8\u8ba4\u8ba1\u7b975\u65e5\u5747\u7ebf\n    :param factor: \u5f85\u8ba1\u7b97\u5747\u7ebf\u7684\u56e0\u5b50\uff0c\u9ed8\u8ba4\u4e3a\u6536\u76d8\u4ef7\n    :return: \u5305\u542b\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    \"\"\"\n\n    # \u5747\u7ebf\u540d\u79f0\uff0c\u4f8b\u5982\uff0c\u6536\u76d8\u4ef7\u76845\u65e5\u5747\u7ebf\u540d\u79f0\u4e3ama_5\uff0c\u6210\u4ea4\u91cf\u76845\u65e5\u5747\u7ebf\u540d\u79f0\u4e3avolume_ma_5\n    name = '{}ma_{}'.format('' if 'close' == factor else factor + '_', n)\n\n    # \u53d6\u5f85\u8ba1\u7b97\u5747\u7ebf\u7684\u56e0\u5b50\u5217\n    s = pd.Series(df[factor], name=name, index=df.index)\n\n    # \u5229\u7528rolling\u548cmean\u8ba1\u7b97\u5747\u7ebf\u6570\u636e\n    s = s.rolling(center=False, window=n).mean()\n\n    # \u5c06\u5747\u7ebf\u6570\u636e\u6dfb\u52a0\u5230\u539f\u59cb\u7684DataFrame\u4e2d\n    df = df.join(s)\n\n    # \u5747\u7ebf\u6570\u503c\u4fdd\u7559\u4e24\u4f4d\u5c0f\u6570\n    df[name] = df[name].apply(lambda x: round(x + 0.001, 2))\n\n    return df\n\n\ndef mas(df, ma_list=None, factor='close'):\n    \"\"\"\n    \u8ba1\u7b97\u591a\u6761\u5747\u7ebf\u56e0\u5b50\uff0c\u5185\u90e8\u8c03\u7528ma\u8ba1\u7b97\u5355\u6761\u5747\u7ebf\n\n    :param df: \u5f85\u8ba1\u7b97\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    :param ma_list: \u5f85\u8ba1\u7b97\u5747\u7ebf\u7684\u5468\u671f\u5217\u8868\uff0c\u9ed8\u8ba4\u4e3aNone\n    :param factor: \u5f85\u8ba1\u7b97\u5747\u7ebf\u7684\u56e0\u5b50\uff0c\u9ed8\u8ba4\u4e3a\u6536\u76d8\u4ef7\n    :return: \u5305\u542b\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    \"\"\"\n\n    if ma_list is None:\n        ma_list = []\n    for i in ma_list:\n        df = ma(df, i, factor)\n    return df\n\n\ndef cross_mas(df, ma_list):\n    \"\"\"\n    \u8ba1\u7b97\u7a7f\u5747\u7ebf\u56e0\u5b50\n\n    \u82e5\u5f53\u65e5\u6700\u4f4e\u4ef7\u4e0d\u9ad8\u4e8e\u5747\u7ebf\u4ef7\u683c\n    \u4e14\u5f53\u65e5\u6536\u76d8\u4ef7\u4e0d\u4f4e\u4e8e\u5747\u7ebf\u4ef7\u683c\n    \u5219\u5f53\u65e5\u7a7f\u5747\u7ebf\u56e0\u5b50\u503c\u4e3aTrue\uff0c\u5426\u5219\u4e3aFalse\n\n    :param df: \u5f85\u8ba1\u7b97\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    :param ma_list: \u5747\u7ebf\u7684\u5468\u671f\u5217\u8868\n    :return: \u5305\u542b\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    \"\"\"\n\n    for i in ma_list:\n        df['cross_{}'.format(i)] = (df['low'] &lt;= df['ma_{}'.format(i)]) &amp; (\n                df['ma_{}'.format(i)] &lt;= df['close'])\n    return df\n\n\ndef candidate(df):\n    \"\"\"\n    \u8ba1\u7b97\u662f\u5426\u4e3a\u5019\u9009\n\n    \u82e5\u5f53\u65e5\u65e5\u7ebf\u540c\u65f6\u7a7f\u8fc75\u300110\u300120\u300130\u65e5\u5747\u7ebf\n    \u4e1430\u65e5\u5747\u7ebf\u572860\u65e5\u5747\u7ebf\u4e0a\u65b9\n    \u4e14\u5f53\u65e5\u5f62\u6210\u53cc\u795e\n    \u5219\u5f53\u65e5\u4f5c\u4e3a\u5019\u9009\uff0c\u8be5\u56e0\u5b50\u503c\u4e3aTrue\uff0c\u5426\u5219\u4e3aFalse\n\n    :param df: \u5f85\u8ba1\u7b97\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    :return: \u5305\u542b\u6269\u5c55\u56e0\u5b50\u7684DataFrame\n    \"\"\"\n\n    # \u5747\u7ebf\u5468\u671f\u5217\u8868\n    ma_list = [5, 10, 20, 30, 60]\n\n    # \u8ba1\u7b97\u5747\u7ebf\u7684\u56e0\u5b50\uff0c\u4fdd\u5b58\u5230\u4e34\u65f6\u7684DataFrame\u4e2d\n    temp_df = mas(df, ma_list)\n\n    # \u8ba1\u7b97\u7a7f\u591a\u7ebf\u7684\u56e0\u5b50\uff0c\u4fdd\u5b58\u5230\u4e34\u65f6\u7684DataFrame\u4e2d\n    temp_df = cross_mas(temp_df, ma_list)\n\n    # \u7a7f\u591a\u7ebf\u56e0\u5b50\u7684\u5217\u540d\u5217\u8868\n    column_list = ['cross_{}'.format(x) for x in ma_list[:-1]]\n\n    # \u8ba1\u7b97\u662f\u5426\u4e3a\u5019\u9009\n    df['candidate'] = temp_df[column_list].all(axis=1) &amp; (temp_df['ma_30'] &gt;= temp_df['ma_60']) &amp; df['ss']\n\n    return df\n\n\nif __name__ == '__main__':\n    stock_codes = get_stock_codes()\n    print(stock_codes)\n<\/code><\/pre>\n<hr \/>\n<p><strong>\u535a\u5ba2\u5185\u5bb9\u53ea\u7528\u4e8e\u4ea4\u6d41\u5b66\u4e60\uff0c\u4e0d\u6784\u6210\u6295\u8d44\u5efa\u8bae\uff0c\u76c8\u4e8f\u81ea\u8d1f\uff01<\/strong><\/p>\n<p>\u6b22\u8fce\u5927\u5bb6\u8f6c\u53d1\u3001\u7559\u8a00\u3002\u5df2\u5efa\u5fae\u4fe1\u7fa4\u7528\u4e8e\u5b66\u4e60\u4ea4\u6d41\uff0c\u7fa41\u5df2\u6ee1\uff0c\u7fa42\u5df2\u521b\u5efa\uff0c\u611f\u5174\u8da3\u7684\u8bfb\u8005\u8bf7\u626b\u7801\u52a0\u5fae\u4fe1\uff01<\/p>\n<p>\u5982\u679c\u8ba4\u4e3a\u535a\u5ba2\u5bf9\u60a8\u6709\u5e2e\u52a9\uff0c\u53ef\u4ee5\u626b\u7801\u8fdb\u884c\u6350\u8d60\uff0c\u611f\u8c22\uff01<\/p>\n<table>\n<thead>\n<tr>\n<th align=\"center\">\u5fae\u4fe1\u4e8c\u7ef4\u7801<\/th>\n<th align=\"center\">\u5fae\u4fe1\u6350\u8d60\u4e8c\u7ef4\u7801<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td align=\"center\"><img decoding=\"async\" src=\"http:\/\/coderx.com.cn\/wordpress\/wp-content\/uploads\/2021\/11\/wechat_margin.png\" alt=\"\u5fae\u4fe1\u4e8c\u7ef4\u7801\" \/><\/td>\n<td align=\"center\"><img decoding=\"async\" src=\"http:\/\/coderx.com.cn\/\/wordpress\/wp-content\/uploads\/2021\/09\/wechatpay.png\" alt=\"\u6350\u8d60\u4e8c\u7ef4\u7801\" \/><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<style>\npre{\n    white-space: pre;\n    overflow-x: auto;\n    overflow-y: auto;\n    max-height: 300px;\n}\n.table-wrapper {\n    overflow-x: auto;\n    overflow-y: auto;\n    white-space: nowrap;\n    max-height: 300px;\n}\n<\/style>\n","protected":false},"excerpt":{"rendered":"<p>\u524d\u6587\u4ecb\u7ecd\u4e86\u628a\u80a1\u7968\u6570\u636e\u5199\u5165MySQL\u7684\u8fc7\u7a0b\uff0c\u672c\u6587\u8bb0\u5f55\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u7684\u8fc7\u7a0b\u3002 \u5230\u76ee\u524d\u4e3a\u6b62\uff0c\u6211\u4eec\u5728\u8bbf\u95ee\u80a1 &#8230; <a title=\"\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u2014\u2014\u4ece\u96f6\u5230\u5b9e\u76d810\" class=\"read-more\" href=\"\/?p=329\" aria-label=\"\u7ee7\u7eed\u9605\u8bfb\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u2014\u2014\u4ece\u96f6\u5230\u5b9e\u76d810\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-329","post","type-post","status-publish","format-standard","hentry","category-2"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u2014\u2014\u4ece\u96f6\u5230\u5b9e\u76d810 - Python\u91cf\u5316\u6280\u672f\u5206\u4eab<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/coderx.com.cn\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u2014\u2014\u4ece\u96f6\u5230\u5b9e\u76d810 - Python\u91cf\u5316\u6280\u672f\u5206\u4eab\" \/>\n<meta property=\"og:description\" content=\"\u524d\u6587\u4ecb\u7ecd\u4e86\u628a\u80a1\u7968\u6570\u636e\u5199\u5165MySQL\u7684\u8fc7\u7a0b\uff0c\u672c\u6587\u8bb0\u5f55\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u7684\u8fc7\u7a0b\u3002 \u5230\u76ee\u524d\u4e3a\u6b62\uff0c\u6211\u4eec\u5728\u8bbf\u95ee\u80a1 ... \u9605\u8bfb\u66f4\u591a\" \/>\n<meta property=\"og:url\" content=\"\/?p=329\" \/>\n<meta property=\"og:site_name\" content=\"Python\u91cf\u5316\u6280\u672f\u5206\u4eab\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-14T14:21:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-23T11:45:55+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/coderx.com.cn\/wordpress\/wp-content\/uploads\/2021\/10\/stock_codes.png\" \/>\n<meta name=\"author\" content=\"mnj\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"mnj\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/coderx.com.cn\/#article\",\"isPartOf\":{\"@id\":\"\/?p=329\"},\"author\":{\"name\":\"mnj\",\"@id\":\"http:\/\/coderx.com.cn\/#\/schema\/person\/4f9a19aed18c75500a890ab51b762ad3\"},\"headline\":\"\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u2014\u2014\u4ece\u96f6\u5230\u5b9e\u76d810\",\"datePublished\":\"2021-10-14T14:21:38+00:00\",\"dateModified\":\"2023-09-23T11:45:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"\/?p=329\"},\"wordCount\":73,\"commentCount\":9,\"publisher\":{\"@id\":\"http:\/\/coderx.com.cn\/#\/schema\/person\/4f9a19aed18c75500a890ab51b762ad3\"},\"articleSection\":[\"\u4ece\u96f6\u5230\u5b9e\u76d8\"],\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/coderx.com.cn\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"\/?p=329\",\"url\":\"http:\/\/coderx.com.cn\/\",\"name\":\"\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u2014\u2014\u4ece\u96f6\u5230\u5b9e\u76d810 - Python\u91cf\u5316\u6280\u672f\u5206\u4eab\",\"isPartOf\":{\"@id\":\"http:\/\/coderx.com.cn\/#website\"},\"datePublished\":\"2021-10-14T14:21:38+00:00\",\"dateModified\":\"2023-09-23T11:45:55+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/coderx.com.cn\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/coderx.com.cn\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/coderx.com.cn\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"http:\/\/coderx.com.cn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u2014\u2014\u4ece\u96f6\u5230\u5b9e\u76d810\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/coderx.com.cn\/#website\",\"url\":\"http:\/\/coderx.com.cn\/\",\"name\":\"Python\u91cf\u5316\u6280\u672f\u5206\u4eab-\u7801\u519c\u7532\u7684\u5b66\u4e60\u7b14\u8bb0\",\"description\":\"\u7801\u519c\u7532\u7684\u5b66\u4e60\u7b14\u8bb0\",\"publisher\":{\"@id\":\"http:\/\/coderx.com.cn\/#\/schema\/person\/4f9a19aed18c75500a890ab51b762ad3\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/coderx.com.cn\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/coderx.com.cn\/#\/schema\/person\/4f9a19aed18c75500a890ab51b762ad3\",\"name\":\"mnj\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"http:\/\/coderx.com.cn\/#\/schema\/person\/image\/\",\"url\":\"\/wordpress\/wp-content\/uploads\/2021\/09\/cropped-1-2.jpg\",\"contentUrl\":\"\/wordpress\/wp-content\/uploads\/2021\/09\/cropped-1-2.jpg\",\"width\":951,\"height\":189,\"caption\":\"mnj\"},\"logo\":{\"@id\":\"http:\/\/coderx.com.cn\/#\/schema\/person\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u2014\u2014\u4ece\u96f6\u5230\u5b9e\u76d810 - Python\u91cf\u5316\u6280\u672f\u5206\u4eab","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/coderx.com.cn\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u2014\u2014\u4ece\u96f6\u5230\u5b9e\u76d810 - Python\u91cf\u5316\u6280\u672f\u5206\u4eab","og_description":"\u524d\u6587\u4ecb\u7ecd\u4e86\u628a\u80a1\u7968\u6570\u636e\u5199\u5165MySQL\u7684\u8fc7\u7a0b\uff0c\u672c\u6587\u8bb0\u5f55\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u7684\u8fc7\u7a0b\u3002 \u5230\u76ee\u524d\u4e3a\u6b62\uff0c\u6211\u4eec\u5728\u8bbf\u95ee\u80a1 ... \u9605\u8bfb\u66f4\u591a","og_url":"\/?p=329","og_site_name":"Python\u91cf\u5316\u6280\u672f\u5206\u4eab","article_published_time":"2021-10-14T14:21:38+00:00","article_modified_time":"2023-09-23T11:45:55+00:00","og_image":[{"url":"http:\/\/coderx.com.cn\/wordpress\/wp-content\/uploads\/2021\/10\/stock_codes.png"}],"author":"mnj","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"mnj","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"6 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/coderx.com.cn\/#article","isPartOf":{"@id":"\/?p=329"},"author":{"name":"mnj","@id":"http:\/\/coderx.com.cn\/#\/schema\/person\/4f9a19aed18c75500a890ab51b762ad3"},"headline":"\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u2014\u2014\u4ece\u96f6\u5230\u5b9e\u76d810","datePublished":"2021-10-14T14:21:38+00:00","dateModified":"2023-09-23T11:45:55+00:00","mainEntityOfPage":{"@id":"\/?p=329"},"wordCount":73,"commentCount":9,"publisher":{"@id":"http:\/\/coderx.com.cn\/#\/schema\/person\/4f9a19aed18c75500a890ab51b762ad3"},"articleSection":["\u4ece\u96f6\u5230\u5b9e\u76d8"],"inLanguage":"zh-Hans","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/coderx.com.cn\/#respond"]}]},{"@type":"WebPage","@id":"\/?p=329","url":"http:\/\/coderx.com.cn\/","name":"\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u2014\u2014\u4ece\u96f6\u5230\u5b9e\u76d810 - Python\u91cf\u5316\u6280\u672f\u5206\u4eab","isPartOf":{"@id":"http:\/\/coderx.com.cn\/#website"},"datePublished":"2021-10-14T14:21:38+00:00","dateModified":"2023-09-23T11:45:55+00:00","breadcrumb":{"@id":"http:\/\/coderx.com.cn\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["http:\/\/coderx.com.cn\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/coderx.com.cn\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"http:\/\/coderx.com.cn\/"},{"@type":"ListItem","position":2,"name":"\u4eceMySQL\u4e2d\u8bfb\u53d6\u80a1\u7968\u6570\u636e\u2014\u2014\u4ece\u96f6\u5230\u5b9e\u76d810"}]},{"@type":"WebSite","@id":"http:\/\/coderx.com.cn\/#website","url":"http:\/\/coderx.com.cn\/","name":"Python\u91cf\u5316\u6280\u672f\u5206\u4eab-\u7801\u519c\u7532\u7684\u5b66\u4e60\u7b14\u8bb0","description":"\u7801\u519c\u7532\u7684\u5b66\u4e60\u7b14\u8bb0","publisher":{"@id":"http:\/\/coderx.com.cn\/#\/schema\/person\/4f9a19aed18c75500a890ab51b762ad3"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/coderx.com.cn\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":["Person","Organization"],"@id":"http:\/\/coderx.com.cn\/#\/schema\/person\/4f9a19aed18c75500a890ab51b762ad3","name":"mnj","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"http:\/\/coderx.com.cn\/#\/schema\/person\/image\/","url":"\/wordpress\/wp-content\/uploads\/2021\/09\/cropped-1-2.jpg","contentUrl":"\/wordpress\/wp-content\/uploads\/2021\/09\/cropped-1-2.jpg","width":951,"height":189,"caption":"mnj"},"logo":{"@id":"http:\/\/coderx.com.cn\/#\/schema\/person\/image\/"}}]}},"_links":{"self":[{"href":"http:\/\/coderx.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/coderx.com.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/coderx.com.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/coderx.com.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/coderx.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=329"}],"version-history":[{"count":6,"href":"http:\/\/coderx.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/329\/revisions"}],"predecessor-version":[{"id":502,"href":"http:\/\/coderx.com.cn\/index.php?rest_route=\/wp\/v2\/posts\/329\/revisions\/502"}],"wp:attachment":[{"href":"http:\/\/coderx.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/coderx.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=329"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/coderx.com.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}