mysql bash insert error?

[Dr.Diesel]

Any suggestions on this?

[root@localhost ~]# mysql -u root -p pass12345 < "insert into temps.garage(datestamp,system,hd) values(now(),'40','40');"
bash: insert into temps.garage(datestamp,system,hd) values(now(),'40','40');: No such file or directory
[root@localhost ~]#

Thanks!

[AlexThomson_NZ]

For stuff like that you probably want to use the '-e' command (execute command).

[moosetooth]

mysql -u root --password=yourpassword yourdb <<EOF
INSERT INTO table_name VALUES ('some_data');
INSERT INTO table_name VALUES ('some_data');
EOF

or I think you can pipe into mysql as well

echo "INSERT INTO table_name VALUES ('some_data');" | mysql -u root --password=yourpassword yourdb

[Dr.Diesel]

Thanks,

[root@localhost ~]# mysql -u root -p pass12345 -e < "exec insert into temps.garage(datestamp,system,hd) values(now(),'40','40');"
bash: exec insert into temps.garage(datestamp,system,hd) values(now(),'40','40');: No such file or directory
[root@localhost ~]# mysql -u root -p pass12345 -e < "insert into temps.garage(datestamp,system,hd) values(now(),'40','40');"
bash: insert into temps.garage(datestamp,system,hd) values(now(),'40','40');: No such file or directory
[root@localhost ~]#

[Dr.Diesel]

moose, thanks, piping worked great!