¡Hola, Mundo!

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" ..

INSERT INTO Insert new records in a table. INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...); INSERT INTO STOCK(STK_CD, STK_NM, EX_CD, NAT_CD) VALUES('600519','귀주모태주','SH','CN'); DELETE DELETE FROM STOCK WHERE STK_CD='600519'; LIKE It is used in a WHERE clause to search for a specified pattern in a column. - The percent sign (%) represents zero, one, or..

$ It moves to the end of the current line. grep Global Regular Expression Print, used to search for a string of characters. ~$ pip list | grep tensorflow >>> tensorflow 2.7.0 tensorflow-estimator 2.7.0 ... python -c Execute the Python code in command. $ python -c "import tensorflow as tf;print(tf.__version__)" >>> 2.8.0