[python] fast api

https://github.com/tiangolo/fastapi GitHub - tiangolo/fastapi: FastAPI framework, high performance, easy to learn, fast to code, ready for production FastAPI framework, high performance, easy to learn, fast to code, ready for production - GitHub - tiangolo/fastapi: FastAPI framework, high performance, easy to learn, fast to code, ready for produ... github.com https://fastapi.tiangolo.com/ko/tuto..
공부 2023. 7. 23. 18:28
[python] uvicorn

uvicorn.run( "app.main:app", host="localhost", port=8000, reload=True, reload_excludes=["app/files/"], ) https://www.inflearn.com/questions/343433/uvicorn-reload-%EC%84%A4%EC%A0%95-%EA%B4%80%EB%A0%A8
공부 2023. 7. 23. 18:20
[python][mysql] c.execute("SELECT * FROM data WHERE params LIKE %s LIMIT 1", ("%" + param + "%",))

https://stackoverflow.com/questions/10903497/python-mysqldb-where-sql-like Python MySQLdb WHERE SQL LIKE I have recently started to learn Python and MySQL for web purposes and I have run into a following problem : I want to pull out from a mysql database one record that contains any text that I enter... stackoverflow.com
공부 2023. 7. 23. 18:18
[MySQL] MySQL Error 1093 : You can't specify target table 'tablename' for update in FROM clause

MySQL 은 Oracle 과는 달리 UPDATE 나 DELETE 시 자기 테이블의 데이타를 바로 사용 못하므로 아래와 같은 SQL 을 실행시 1093 에러가 발생함. DELETE FROM cwd_group WHERE id IN (SELECT ext_id FROM (SELECT DISTINCT a.id ext_id FROM cwd_group a JOIN cwd_group b ON a.group_name=b.group_name JOIN cwd_directory d ON d.id=a.directory_id WHERE a.directory_id != b.directory_id AND directory_name = 'My JIRA Server') tmp) ; https://www.lesstif.com/dbms/..
공부 2023. 7. 23. 18:14
1
728x90
728x90