Skip to content

Tag: linux

Creating and using an SQL variable after some set text

I’m needing to set some text into a field within a row, and use a SQL variable as part of that text. I’m then using this sql statement in a bash script. I have I believe I created the variable correctly I then need to use this variable as follows However its not working and is giving me errors abo…

Running sqlplus in background in Unix

I am trying to run an .sql file from sqlplus in Unix environment as a background process. I am connecting to Unix using Tectia or Putty, and I want sqlplus to continue running in background even if my terminal closes. This command works but when trying to start it in background it fails What is the right comm…

MySQL ON DUPLICATE KEY UPDATE syntax error

I was wondering if anyone can spot any mistakes in my sql statement. I would like it to insert a new record into my table if one doesn’t exists already. If it does exist then just update it. My primary key in the date field. Here is my statement as it appears in php and also the error I’m getting: