mysqlInsert new values only if row doesn't exist already
INSERT IGNORE INTO table (president_id, name) VALUES(45, 'Donald');ctrl + cINSERT IGNORE INTO tablethis query will cancel insert if the row exists already | (president_id, name)columns list to insert values to |
VALUES(45, 'Donald')values to insert if row doesn't exist (we assume | |
More of Mysql
- Insert/update multiple rows in single query
- Disable ONLY_FULL_GROUP_BY mode
- How to find my.cnf config file
- Get largest tables list
- Truncate all tables in a specific database
- What is the MEDIUMTEXT column max size (length) in Mysql
- How to find duplicate varchar/text column values in table
- What is the TINYINT column max value and size in Mysql
- Skip certain tables while doing dump
- Create unique key
See more codes...