Home / ubuntu / Questions / 443436
Accepted
ContextSwitch
Asked: 2014-04-05 11:00:15 +0800 CST

Substituting values on the command line

  • 772

I want to run sql from the command line:

mysql -u user -p database -e "INSERT INTO table VALUES ( NULL, [hash] , NOW(), 0);

I want to replace [hash] with the response of another command line command:

date +%s | md5sum

Is there a way to make that substitution?

command-line

1 Answers

  1. Best Answer

    Yes, assuming you are using bash (and closing the open quote) -

    mysql -u user -p database \
  -e "INSERT INTO table VALUES ( NULL, $(date +%s | md5sum) , NOW(), 0);"
    • 2