Pass parameter to MySQL script command line

by

Found an answer on the net here.

Basically, suppose that we want to run this query:

Select c_id, c_first_name,c_last_name, c_address,last_modified_date
from customer
where last_modified_date >=@start_date and last_modified_date <= @end_date;

We can pass ‘start_date’ and ‘end_date’ like this:

/usr/bin/mysql –uuser_id -ppassword –h mysql-host -A \
    -e "set @start_date=${start_date}; set @end_date=${end_date};\
        source ${sql_script};" > ${data_file}

More Related Contents:

  1. multiple query same table but in different columns mysql
  2. How can I make SQL case sensitive string comparison on MySQL?
  3. Import data in MySQL from a CSV file using LOAD DATA INFILE
  4. How to do a batch insert in MySQL
  5. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  6. Count the occurrences of DISTINCT values
  7. Get current AUTO_INCREMENT value for any table
  8. INSERT INTO … SELECT FROM … ON DUPLICATE KEY UPDATE
  9. mysql trigger stored trigger is already used by statement which invoked stored trigger
  10. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  11. mysql update query with sub query
  12. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  13. What is the difference between the backtick and the square bracket in SQL statements?
  14. Integrity constraint violation: 1452 Cannot add or update a child row:
  15. Mysql: Order by like?
  16. MySQL Time Zones
  17. Getting first day of the week in MySql using Week No
  18. How to use django models with foreign keys in different DBs?
  19. Can’t import database through phpmyadmin file size too large
  20. How to change MySQL column definition?
  21. How can I undo a mysql statement that I just executed?
  22. Continue SQL query even on errors in MySQL workbench
  23. How to generate a UUIDv4 in MySQL?
  24. MySQL : how to remove double or more spaces from a string?
  25. is php sort better than mysql “order by”?
  26. Mysql returning clause equivalent
  27. How can “set timestamp” be a slow query?
  28. Update multiple rows with multiple ‘where’ clauses for each individual row
  29. WHERE datetime older than some time (eg. 15 minutes)
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment