I have a shell script that I have data entered into a database, and instead of just entering in the data blindly, I want it to check to see if the item it is entering exists already, and if it does, update the information rather than inserting it. So I want to run a select statement, and if results come back, have the data updated, and if not have it inserted.
I know how to do this in PHP with $query_total_rows. Is there some way in SQL to do this, or do I need to figure out a way to do it in the shell script? Thanks, Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
