Is there a way to have an if statement in mysql that would insert my query if a feild never exists else do nothing.
Basically I want it to see if a users exists, if it does do nothing, if it doesnt insert it.
I know there are 2 fields that the if statment can insert, 1 if it exists, 1 if it doesnt.
I only want it to insert if the user never exists.
Any one can give me syntax for that using a if statement, if possible.
else I'll use a select statment to detect it, and then insert it if the select statement comes up with nothing.
Basically I want it to see if a users exists, if it does do nothing, if it doesnt insert it.
I know there are 2 fields that the if statment can insert, 1 if it exists, 1 if it doesnt.
I only want it to insert if the user never exists.
Any one can give me syntax for that using a if statement, if possible.
else I'll use a select statment to detect it, and then insert it if the select statement comes up with nothing.