Skip to content

Instantly share code, notes, and snippets.

@boina-n

boina-n/MySQL-write_script.sh

Created March 19, 2018 16:04
Show Gist options
  • Save boina-n/abcc90ab3230905d775c94a15d5bd48d to your computer and use it in GitHub Desktop.
Save boina-n/abcc90ab3230905d775c94a15d5bd48d to your computer and use it in GitHub Desktop.
Download ZIP
MySQL-write_script.sh
Raw
MySQL-write_script.sh
CREATE TABLE `cf_1e7d7278_f007_4a59_b423_e4804236eeb0`.`operation.2017112800` ( `CurrentDate` DATETIME NOT NULL ) ENGINE = InnoDB;
INSERT INTO `cf_1e7d7278_f007_4a59_b423_e4804236eeb0`.`operation.2017112800` (`CurrentDate`) VALUES (NOW());
#!/bin/bash
echo 'INSERT INTO `cf_1e7d7278_f007_4a59_b423_e4804236eeb0`.`operation.2017112800` (`CurrentDate`) VALUES (NOW());' | mysql -h vip-olaf-svcmysql.example.com -u ukIsd3JezjPp6HN3 -p9fAhqiXAENxOzuam
echo SELECT * FROM `operation.2017112800`; | mysql -h vip-olaf-svcmysql.example.com -u ukIsd3JezjPp6HN3 -p9fAhqiXAENxOzuam
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment