Thursday 31 January 2013

skip entry if already exist Mysql

Hi we can easily do this with the use of single parameter  ignore
 after insert

like

$insert1= mysql_query("INSERT IGNORE INTO your_table_name(your column name,..) VALUES('your values')",$conn1);

this will help you to skip a entry if already exist in table and continue after that with other entries

No comments:

Post a Comment