¡Hola, Mundo!

The primary key is the criteria of the table. In other words, criteria table key is primary key. - Example1 : When join parent table with child table 1, primary key of parent table is a criteria key. Parent Table Primary Key Foreign Key Join : Primary KeyForeign Key Child Table 1 Primary Key Foreign Key - Example2 : When join child table 1 with child table 2, primary key of child table1 is a cri..

Set up the requirement and docker-compose. 1. Create requirement.txt file. pandas==1.2.4 mysql-connector-python==8.0.28 2. Create Docker file. FROM continuumio/miniconda3 WORKDIR /usr/app RUN mkdir result RUN mkdir src EXPOSE 8888 RUN pip install --no-cache-dir --upgrade pip COPY ./requirements.txt . RUN pip install -r requirements.txt RUN pip install jupyter RUN jupyter notebook --generate-conf..

1. Data extract - SQL SELECT * FROM history_dt LIMIT 5; - Pandas tips.head() 2. Filter data - SQL SELECT t1.STK_CD, t1.DT, t1.O_PRC FROM history_dt t1 WHERE STK_CD='000020' LIMIT 5; - Pandas tips.query("day=='Thur'").head() or tips.loc[tips['day']=='Thur'].head() or tips[tips['day']=='Thur'].head() 3. Sort data 1) - SQL SELECT t1.STK_CD, t1.DT, t1.O_PRC FROM history_dt t1 WHERE STK_CD='005930' O..

SQL Error db_1 | ERROR: Can't initialize batch_readline - may be the input source is a directory or a block device. sql_db_1 exited with code 1 Cause I changed the name of sql file. 😅 So it doesn't match with docker-compose file. Solution Put the sql file name back as before. And then docker-compose down, docker-compose up.

docker-compose.yml Run mySQL through docker-compose. version: '3.1' services: db: image: mysql command: --default-authentication-plugin=mysql_native_password environment: MYSQL_ROOT_PASSWORD: jh MYSQL_DATABASE: DB_SQLSTK volumes: - ./DB_SQLSTK_FULL_FOR_BOOK_20210521.sql:/docker-entrypoint-initdb.d/schema.sql:ro ports: - 3306:3306 adminer: image: adminer ports: - 8080:8080 ~ "docker-compose.yml" ..