Re: insert into tablea if the same two fields exists in tableb

[Tim Manochehri]

Thank you for the reply...

Sorry could you dumb that down more for me.

I am at best a novice at writing mysql queries. What does @username mean or @?

Here is my insert for Host table

doquery2() {
mysql -e "$query2" -h $DBHOST --password=******* userdb
}

...

query2="INSERT hosts SET hostname=\"$HostName\",
username=\"$UserName\",
password=\"$Password\",
UID=\"$zUID\",
GID=\"$zGID\",
Full_Name=\"${FullName:=empty}\",
Homedir=\"${HomeDir:=empty}\",
Default_shell=\"${DefaultShell:=empty}\""

doquery2

So how would I add the select part to that query2 section...