mysql 不包含某些id,如果mysql db表不包含具有特定ID的行，则将数据添加到表中

Hi i'm new to php and mysql.

I'm wondering how can i use PHP to check if a table in my mysql database contains a ROW which have the specific ID and if not add the data to the table .

For example,

Table structure:(Table name : record)

ID , DATA

i have ID=123 and DATA=hello stored in a variable in the php code , how can i use php sql query to find out whether the data exist by checking using its ID in the table , if not , INSERT the ID and DATA into the table.

I hope you understand.

p/s i have connected the php script to the database

解决方案

Make the ID UNIQUE:

CREATE TABLE my_table( ID INT UNSIGNED UNIQUE...

then use INSERT IGNORE:

INSERT IGNORE INTO my_table( ID, DATA ) VALUES( some_id, some_data )