| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 |
- index
- Button
- RNN
- Python
- GitHub
- mariadb
- 알고리즘
- SciPy
- mean
- Splunk
- imread
- DFS
- javascript
- Numpy
- synology
- Series
- pip
- keras
- pandas
- pycharm
- Lotto
- dataframe
- ipad
- E-P1
- SPL
- install
- GT-S80
- CNN
- LSTM
- 삼성소프트웨어멤버십
- Today
- Total
목록INSERT (2)
잠토의 잠망경
[Python] mariadb
1. pymysql install pymysql 2. 첫번째 행 갖고 오기 github data = cursor.fetchone() def sample01(ip:str, port:int, user:str, passwd:str, db:str, query:str)->tuple: """mariadb 첫번째 행 갖고 오기 Args: ip: ip port: port user: id passwd: password db: 기본 db Returns: 없음 """ import pymysql db = pymysql.connect(host = ip, port = port, user = user, passwd = passwd, db = db, charset='utf8', autocommit=True) cursor = db.c..
[Splunk] DB Connect 02
1. Maria DB - 사전 준비 저장할 DB를 만든다. create table mellowlee.splunk_test_db( MASTER_ID BIGINT not null AUTO_INCREMENT, C_NAME VARCHAR(30), SUM_S_VOLUME BIGINT, IN_TIME DATE, PRIMARY KEY (MASTER_ID) ) COMMIT insert into mellowlee.splunk_test_db (C_NAME, SUM_S_VOLUME, IN_TIME) values("test1", 1323, CURRENT_TIMESTAMP) insert into mellowlee.splunk_test_db (C_NAME, SUM_S_VOLUME) values("test3", 1323) COMM..