SQLite does not exist record then insert data

problem: If there is a student table in the SQLite database, you now need to insert the data into the table, or insert if there is no record with the same name.

Answer: Use the NOT EXISTS statement as follows:

insert INTO [Student] ([Name], [age]) Select ' Zhou Junhao ', "where NOT EXISTS" (SELECT * from [Student] where [name]= ' Zhou Junhao ')??

Execution of the statement, the first time after the execution of the Zhou Junhao This data is inserted, re-execution will no longer insert operations.

Article Sync update: http://www.motyer.cn/Files/BlogDetails/sqlite-insert-into-where-not-exists.html

SQLite does not exist record then insert data