Magically removing your data Bad practices, Database concepts Add comments Nov 022012 Click the SQL for scripts Share this:FacebookGoogle +1Twitter select posts from sqlfail where content like :this_post; Validate your data by CHECKing it If you must check the data is present… Upsert method 2: When you expect to mostly be updating existing data Won’t someone think of the children? Conditional integrity Leave a Reply Cancel reply Name (required) E-mail (required) URI Your Comment You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> Notify me of follow-up comments by email. Notify me of new posts by email.