Mysql -s -u airflow -h 1.2.3.4 -pairflow airflow -e "select study_id from study where study='str4' " Suppressing and removing the headers and lines in MySQL cli results set (notice the -sN, -s, -N argument) mysql -N -u airflow -h 1.2.3.4 Mysql -u user -h 1.2.3.4 -pPassword someDB -e "select * from t" MySQL Client install and running from CLI – user – password – database sudo apt install -y default-mysql-client Insert into table with identity INSERT INTO study(study_col) VALUES ( 'new_study' ) ( study_id INT(11) NOT NULL AUTO_INCREMENT,ĬONSTRAINT study_pk PRIMARY KEY (study_id) MySQL Table with Identity (auto increment) CREATE TABLE study SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND != 'Sleep' AND INFO LIKE '%UPDATE %' SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND != 'Sleep' AND TIME >= 5 Check Tables size SELECT table_schema as `Database`, table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC SHOW FULL PROCESSLIST
0 kommentar(er)
