search

Home >Database >Mysql Tutorial >mysql如果数据不存在，则插入新数据，否则更新_MySQL

mysql如果数据不存在，则插入新数据，否则更新_MySQL

WBOY
WBOYOriginal
2016-06-01 13:50:54937browse

bitsCN.com //如果不存在，则插入新数据            $sql = "INSERT INTO {$ecs->table(‘cat_lang’)} (cat_id,lang_id,cat_name,keywords,cat_desc)             VALUES({$cat_id},{$k},’{$val['cat_name']}’,'{$val['keywords']}’,'{$val['cat_desc']}’)             ON DUPLICATE KEY UPDATE cat_name=’{$val['cat_name']}’,cat_desc=’{$val['cat_desc']}’,keywords=’{$val['cat_desc']}’";这里要注意的是：必须表主键唯一 。这里，这里我采用的是 分类id和语言id双主键机制。
bitsCN.com

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql 初学者必学语句整理_MySQLNext article：授权访问MySQL Server(远程连接MYSQL提示Host is not allowed to_MySQL

Related articles

See more