Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > 数据存在就更新不存在就插入数据sql语句

数据存在就更新不存在就插入数据sql语句

WBOY
Release： 2016-06-07 17:49:54
Original
1255 people have browsed it

在mysql网站制作中我们会碰到为了节省一点点资源就要把数据库操作更简单化，如数据存在就更新不存在就插入数据sql语句，下面我们就会用到 insert ON DUPLICATE KEY UPDATE来实例，

Related labels：
sql exist insert data renew statement
source：php.cn
Previous article：mysql导出excel文件的几种方法 Next article：MySQL 创建存储过程详细实例教程(1/9)
Statement of this Website
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
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1429
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
Set a private member of a class as a constructor parameter classFoo{#one#two#three#four#five#six#seven#eight#nine#ten#eleven#twelve#thirteen#fourteen...
From 2024-04-06 21:48:47
0
1
637
Regular expression to match words I have a script where I am trying to match new job names with existing job names in a data...
From 2024-04-06 21:24:04
0
1
606
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template