Help need with Command line Mysql


 
Thread Tools Search this Thread
Top Forums Programming Help need with Command line Mysql
# 1  
Old 01-11-2012
Help need with Command line Mysql

Code:
mysql -h $dbserver --pager=/usr/bin/less --user=$username --password=$password -e 'SELECT * FROM callings WHERE timestamp_date >= NOW() - INTERVAL 1 DAY  AND timestamp >= NOW() - INTERVAL 30 MINUTE AND extension = "$blahtest" AND to_number = "$phonenumber"' $DBNAME

Can someone help me fix the above so that I can pass variables to it?

I'm running the above from the command line and i'm passing variables to it. but mysql doesn't seem to like it.

i can tell the issue is with the "-e" and the single quotes that follow. but i need to pass be able to pass variables.

when i run the above command i always get:

Code:
ERROR 1054 (42S22) at line 1: Unknown column 'blahtest' in 'where clause'

even though the blahtest does exist.
# 2  
Old 01-11-2012
Hi.

If you use single quotes after -e, $blahtest won't be evaluated.

Try changing to double quotes and escape the inner double quotes (\") (or replace those with single quotes if MySQL will accept that for syntax).
This User Gave Thanks to Scott For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Web Development

Installing mysql:sudo launchctl: command not found

I have run into an obstacle. See error message below ** I am Running: 'Mountain lion' , 'Mac OS X 10.8.3' I have downloaded: MySQL version. Mac OS X 10.7. (X86, 64-bit), DMG Archive. After several days of reading about: Installation of MySQL Enabling apache server And getting phpMyAdmin... (16 Replies)
Discussion started by: iHaveAQuestion
16 Replies

2. Shell Programming and Scripting

sed command to replace a line at a specific line number with some other line

my requirement is, consider a file output cat output blah sdjfhjkd jsdfhjksdh sdfs 23423 sdfsdf sdf"sdfsdf"sdfsdf"""""dsf hellow there this doesnt look good et cetc etc etcetera i want to replace a line of line number 4 ("this doesnt look good") with some other line ... (3 Replies)
Discussion started by: vivek d r
3 Replies

3. Shell Programming and Scripting

need command for mysql installation

Hi All, I want to install mysql on my server but i dont have root access when i have tried to install this MySQL-client-3.3.15-3.rhel5.x24_74.rpm using the command rpm -ivh MySQL-client-3.3.15-3.rhel5.x24_74.rpm getting error error: can't create transaction lock on... (0 Replies)
Discussion started by: aish11
0 Replies

4. Shell Programming and Scripting

mysql script in a command shell

Hi can anyone help with my issue here. I new in linux and new in scripting. i was ask to do the following below and i`m getting errors. I managed to create the table and the database. Now i need to add the details in a shell to update the database.... (7 Replies)
Discussion started by: mduduzi
7 Replies

5. Shell Programming and Scripting

mysql script in a command shell

Hi i`m trying this script to run and i get the following error. Enter your name tman Enter your surname smith -bash: ./500: line 20: unexpected EOF while looking for matching `"' -bash: ./500: line 21: syntax error: unexpected end of file ... (2 Replies)
Discussion started by: mduduzi
2 Replies

6. Shell Programming and Scripting

Mysql command after a SSH connection (Script)

Hi all, Im new at scripting and i need to run a few commands at work every hours so i decide to make a script but on 1 of the steps i have a the follwoing problem: The command i do is this: #!/bin/bash ssh root@asdasd001 'mysql -h A-db-1 -uroot -password --execute "show slave status"'... (3 Replies)
Discussion started by: Aparicio
3 Replies

7. Shell Programming and Scripting

while puting shell variable in mysql command value does not interpolate

port=$(ssh tms6@$x cat /tms6/scripts/start.lc.sh | grep -P '^\/tms6\/bin\/lc' | cut -d' ' -f3 | cut -b 3-6) tpsip=$(ssh tms6@$x cat /tms6/scripts/start.lc.sh | grep -P '^\/tms6\/bin\/lc' | cut -d' ' -f4 | cut -b 9-) # IFS="\n" set -- $port ... (1 Reply)
Discussion started by: rrd1986
1 Replies

8. Linux

make command problem with MySql install

Hi, hopefully someone can help me. I am trying to set up LAMP on Fedora 11 starting with MySql. I downloaded the mysql-5.1.40.tar.gz tarball and unpacked it all. This created the mysql-5.1.40 directory. Next I ran the ./configure command. Following this I ran the make command to compile but... (2 Replies)
Discussion started by: patcom
2 Replies

9. UNIX for Dummies Questions & Answers

command(s) to find size of mysql database?

hello, i'm trying to figure out the size of a mysql database shelling into my server with putty / command line. is there / are there any commands that will return the size of a database, in MB? thanks. (4 Replies)
Discussion started by: sbourgeois
4 Replies

10. UNIX for Advanced & Expert Users

MYSQL command to take a backup of the database in Redhat linux 7.2

I am new to mysql database , we have a mysql database running on linux , and we use mysql database for bugzilla, so we wanted to take a backup . what is the command for taking the entire database backup from the command prompt with all options. Thanks in advance Bache Gowda (4 Replies)
Discussion started by: bache_gowda
4 Replies
Login or Register to Ask a Question