Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > 想用mysql_fetch_row搜索下一行，就删除

想用mysql_fetch_row搜索下一行，就删除

WBOY
Release： 2016-06-06 09:42:51
Original
1147 people have browsed it

mysqlfetchfreedeletec++

每次通过

<code>str.Format(_T("%s"),row[0]);row=mysql_fetch_row(result);</code>
Copy after login

得到str，然后用

<code>strSQL.Format("delete from mytable where name=\'%s\'",str);if(mysql_real_query(&mysql,(char*)(LPCTSTR)strSQL,(UINT)strSQL.GetLength())!=0){AfxMessageBox("删除失败");}</code>
Copy after login

这样删除表中内容，为什么一直都是删除失败，如果加上释放内存

<code> mysql_free_result(result);</code>
Copy after login

只能删除一次，有没有什么好方法可以一直删除下去。

Related labels：
mysql fetch free delete c++
source：php.cn
Previous article：table-mysql 错误：1146 ,Table "XXX" doesn;t exist Next article：mysql-MySQL二进制日志使用遇到的编码问题
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
3
2061
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2222
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1872
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1753
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1780
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