(fastapi_env) D:\Agent_learning\Fastapi_Code>aerich init-db

Traceback (most recent call last):

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\tortoise\backends\mysql\client.py", line 50, in translate_exceptions_

    return await func(self, *args)

           ^^^^^^^^^^^^^^^^^^^^^^^

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\tortoise\backends\mysql\client.py", line 223, in execute_script

    await cursor.execute(query)

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aiomysql\cursors.py", line 239, in execute

    await self._query(query)

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aiomysql\cursors.py", line 457, in _query

    await conn.query(q)

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aiomysql\connection.py", line 469, in query

    await self._read_query_result(unbuffered=unbuffered)

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aiomysql\connection.py", line 683, in _read_query_result

    await result.read()

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aiomysql\connection.py", line 1164, in read

    first_packet = await self.connection._read_packet()

                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aiomysql\connection.py", line 652, in _read_packet

    packet.raise_for_error()

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\pymysql\protocol.py", line 219, in raise_for_error

    err.raise_mysql_exception(self._data)

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\pymysql\err.py", line 154, in raise_mysql_exception

    raise errorclass(errno, errval, sqlstate=sqlstate)

pymysql.err.OperationalError: (1071, 'Specified key was too long; max key length is 1000 bytes')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

  File "<frozen runpy>", line 198, in _run_module_as_main

  File "<frozen runpy>", line 88, in _run_code

  File "D:\Anaconda\envs\fastapi_env\Scripts\aerich.exe\__main__.py", line 5, in <module>

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aerich\cli.py", line 300, in main

    cli()

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\asyncclick\core.py", line 1656, in __call__

    return anyio.run(self._main, main, args, kwargs, **opts)

           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\anyio\_core\_eventloop.py", line 83, in run

    return async_backend.run(func, args, {}, backend_options)

           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\anyio\_backends\_asyncio.py", line 2481, in run

    return runner.run(wrapper())

           ^^^^^^^^^^^^^^^^^^^^^

  File "D:\Anaconda\envs\fastapi_env\Lib\asyncio\runners.py", line 118, in run

    return self._loop.run_until_complete(task)

           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

  File "D:\Anaconda\envs\fastapi_env\Lib\asyncio\base_events.py", line 691, in run_until_complete

    return future.result()

           ^^^^^^^^^^^^^^^

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\anyio\_backends\_asyncio.py", line 2464, in wrapper

    return await func(*args)

           ^^^^^^^^^^^^^^^^^

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\asyncclick\core.py", line 1674, in _main

    return await main(*args, **kwargs)

           ^^^^^^^^^^^^^^^^^^^^^^^^^^^

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\asyncclick\core.py", line 1549, in main

    rv = await self.invoke(ctx)

         ^^^^^^^^^^^^^^^^^^^^^^

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\asyncclick\core.py", line 2075, in invoke

    return await _process_result(await sub_ctx.command.invoke(sub_ctx))

                                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\asyncclick\core.py", line 1412, in invoke

    return await ctx.invoke(self.callback, **ctx.params)

           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\asyncclick\core.py", line 965, in invoke

    rv = await rv

         ^^^^^^^^

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aerich\cli.py", line 275, in init_db

    await command.init_db(safe)

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\aerich\__init__.py", line 284, in init_db

    await generate_schema_for_client(connection, safe)

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\tortoise\utils.py", line 46, in generate_schema_for_client

    await generator.generate_from_string(schema)

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\tortoise\backends\base\schema_generator.py", line 504, in generate_from_string

    await self.client.execute_script(creation_string)

  File "D:\Anaconda\envs\fastapi_env\Lib\site-packages\tortoise\backends\mysql\client.py", line 58, in translate_exceptions_

    raise OperationalError(exc)

tortoise.exceptions.OperationalError: (1071, 'Specified key was too long; max key length is 1000 bytes')

当执行

aerich init-db 

出现了这个问题

老师，为什么我的这个vscode扩展商店搜索tongyi这个插件找不到呢？

SELECT employee_id, CONCAT(last_name，first_name) NAME, 

job_id, LENGTH(last_name),INSTR(last_name, 'a') "Contains 'a'?" FROM employees WHERE SUBSTR(job_id, 4) = 'REP';

文档里面CONCAT(last_name，first_name) NAME中间的逗号是中文格式的，要改成英文格式

按照网络步骤安装了miniconda3软件，但还是不能激活虚拟环境，不知道是什么原因？

自己安装CONDA后不能正常运行（MONICONDA3和MONIFORGE3度安装了，还是不行。说没有激活功能，初始化后也不行），估计是我用的安装 程序的版本不对。麻烦发一个可以正常使用的CONDA安装程序给我们，谢谢！

想请问下，这里为啥不是使用await,类似于下面的await f.write用法

为什么我测试批量文件上传的代码，页面显示是乱码，没有上传按键