Hi,
I did made a mysql database and table and used the script above. But I'm having an error:
sed: read error in stdin: Is a directory /usr/local/bin/smsql.sh line 37: line 37 mysql: command not found

This is what's on line 37:
mysql $SQL_ARGS "insert into $SQL_TABLE (type,sent,received,sender,receiver,text) values (\"RECEIVED\",\"$SENT\",\"$DATE\",\"$FROM\",\"$SUBJECT\",\"$TEXTSQL\");";

Do I also have to create the fields on the table that I made or this script will take care of it?

I did tried making the fields too:
CREATE TABLE `stored_messages`.`sms_log` ( `type` INT NOT NULL , `sent` INT NOT NULL , `sender` INT NOT NULL , `recevier` INT NOT NULL , `msgid` INT NOT NULL , `text` INT NOT NULL , `received` INT NOT NULL ) ENGINE = MYISAM

Did i do it right?

Quote

I did made a mysql database and table and used the script above. But I'm having an error:
sed: read error in stdin: Is a directory /usr/local/bin/smsql.sh line 37: line 37 mysql: command not found

[ Select ]

The second argument was not a file, it was directory.

You do not have MySQL command line interface (CLI) installed. You have to install it.

Quote

Do I also have to create the fields on the table that I made or this script will take care of it?

Yes you should do.

Quote

I did tried making the fields too:
CREATE TABLE `stored_messages`.`sms_log` ( `type` INT NOT NULL , `sent` INT NOT NULL , `sender` INT NOT NULL , `recevier` INT NOT NULL , `msgid` INT NOT NULL , `text` INT NOT NULL , `received` INT NOT NULL ) ENGINE = MYISAM

[ Select ]

Did i do it right?

No. All fields cannot be integers. You could use this kind of statement to create a table: