how to execute sql command from command line using NO script file?

Question

is there any way to execute update contact set email_address='[email protected]'; using isql (firebird) on linux?

I don't want to use -i switch to specify sql script file. And I cannot use interactive mode as I will run the sql command from php script.

What does echo "update contact set email_address='[email protected]';" | isql do? I haven't used firebird but that should work with any sensible tool. — mu is too short
– mu is too short, Commented Apr 7, 2011 at 1:38
@mu: do you want to create an answer from the above? It works nicely :-) thank you. The whole lot looks like echo "update contact set email_address='[email protected]';" |/opt/firebird/bin/isql -user SYSDBA -pass password /var/lib/firebird/data/radek_db.gdb — Radek
– Radek, Commented Apr 7, 2011 at 1:51

mu is too short · Accepted Answer · 2011-04-07 02:12:08Z

3

Most sensible SQL shells do The Right Thing when fed commands on the standard input so you should be able to just echo your SQL into isql:

echo "update contact set email_address='[email protected]';" | /path/to/isql --your-favorite-switches

answered Apr 7, 2011 at 2:12

mu is too short

436k71 gold badges863 silver badges822 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1