下面发一个工整的:strInsert = "INSERT INTO product VALUES SET " +
"unit_id=?unit_id," +
"product_name=?product_name," +
"author_name=?author_name," +
"project_id=?project_id," +
"product_mode_id=?product_mode_id," +
"publish_range_id=?publish_range_id," +
"istranslated=?istranslated," +
"product_research_type_id=?product_research_type_id," +
"subject_id=?subject_id," +
"subject_2_id=?subject_2_id," +
"author_quality_id=?author_quality_id," +
"publish_unit=?publish_unit," +
"publish_date=?publish_date," +
"product_name_cn=?product_name_en," +
"project_name=?project_name," +
"cno=?cno," +
"keywords_en=?keywords_en," +
"keywords=?keywords," +
"apply_circs=?apply_circs," +
"word_number=?word_number," +
"product_abstract=?product_abstract," +
"electronic_file_sn=?electronic_file_sn," +
"electronic_file_sn2=?electronic_file_sn2," +
"electronic_file_sn3=?electronic_file_sn3," +
"electronic_file_memo=?electronic_file_memo";
cmd = new MySqlCommand(strInsert, con);//添加MySql变量
cmd.Parameters.Add("?unit_id", unit_id);
cmd.Parameters.Add("?product_name", product_name);
cmd.Parameters.Add("?author_name", author_name);
cmd.Parameters.Add("?project_id", project_id);
cmd.Parameters.Add("?product_mode_id", product_mode_id);
cmd.Parameters.Add("?publish_range_id", publish_range_id);
cmd.Parameters.Add("?istranslated", istranslated);
cmd.Parameters.Add("?product_research_type_id", product_research_type_id);
cmd.Parameters.Add("?publish_date", publish_date);
cmd.Parameters.Add("?product_name_en", product_name_en);
cmd.Parameters.Add("?project_name", project_name);
cmd.Parameters.Add("?cno", cno);
cmd.Parameters.Add("?keywords_en", keywords_en);
cmd.Parameters.Add("?keywords", keywords);
cmd.Parameters.Add("?apply_circs", apply_circs);
cmd.Parameters.Add("?word_number", word_number);
cmd.Parameters.Add("?product_abstract", product_abstract);
cmd.Parameters.Add("?electronic_file_sn", electronic_file_sn);
cmd.Parameters.Add("?electronic_file_sn2", electronic_file_sn2);
cmd.Parameters.Add("?electronic_file_sn3", electronic_file_sn3);
cmd.Parameters.Add("?electronic_file_memo", electronic_file_memo);
cmd.Parameters.Add("?subject_id", subject_id);
cmd.Parameters.Add("?subject_2_id", subject_2_id);
cmd.Parameters.Add("?author_quality_id", author_quality_id);
cmd.Parameters.Add("?publish_unit", publish_unit);
"unit_id=?unit_id," +
"product_name=?product_name," +
"author_name=?author_name," +
"project_id=?project_id," +
"product_mode_id=?product_mode_id," +
"publish_range_id=?publish_range_id," +
"istranslated=?istranslated," +
"product_research_type_id=?product_research_type_id," +
"subject_id=?subject_id," +
"subject_2_id=?subject_2_id," +
"author_quality_id=?author_quality_id," +
"publish_unit=?publish_unit," +
"publish_date=?publish_date," +
"product_name_cn=?product_name_en," +
"project_name=?project_name," +
"cno=?cno," +
"keywords_en=?keywords_en," +
"keywords=?keywords," +
"apply_circs=?apply_circs," +
"word_number=?word_number," +
"product_abstract=?product_abstract," +
"electronic_file_sn=?electronic_file_sn," +
"electronic_file_sn2=?electronic_file_sn2," +
"electronic_file_sn3=?electronic_file_sn3," +
"electronic_file_memo=?electronic_file_memo";
cmd = new MySqlCommand(strInsert, con);//添加MySql变量
cmd.Parameters.Add("?unit_id", unit_id);
cmd.Parameters.Add("?product_name", product_name);
cmd.Parameters.Add("?author_name", author_name);
cmd.Parameters.Add("?project_id", project_id);
cmd.Parameters.Add("?product_mode_id", product_mode_id);
cmd.Parameters.Add("?publish_range_id", publish_range_id);
cmd.Parameters.Add("?istranslated", istranslated);
cmd.Parameters.Add("?product_research_type_id", product_research_type_id);
cmd.Parameters.Add("?publish_date", publish_date);
cmd.Parameters.Add("?product_name_en", product_name_en);
cmd.Parameters.Add("?project_name", project_name);
cmd.Parameters.Add("?cno", cno);
cmd.Parameters.Add("?keywords_en", keywords_en);
cmd.Parameters.Add("?keywords", keywords);
cmd.Parameters.Add("?apply_circs", apply_circs);
cmd.Parameters.Add("?word_number", word_number);
cmd.Parameters.Add("?product_abstract", product_abstract);
cmd.Parameters.Add("?electronic_file_sn", electronic_file_sn);
cmd.Parameters.Add("?electronic_file_sn2", electronic_file_sn2);
cmd.Parameters.Add("?electronic_file_sn3", electronic_file_sn3);
cmd.Parameters.Add("?electronic_file_memo", electronic_file_memo);
cmd.Parameters.Add("?subject_id", subject_id);
cmd.Parameters.Add("?subject_2_id", subject_2_id);
cmd.Parameters.Add("?author_quality_id", author_quality_id);
cmd.Parameters.Add("?publish_unit", publish_unit);
解决方案 »
- Excel VBA 连接 MySQL
- mysql 除了mysqldump还有其他比较好的解决方案没有。
- 如何将一个文本文件导入到mysql里成为一个单独的表?(在线等)
- 有个批量导入的问题,请教各位大哥
- mysql连表查询
- 求一sql语句
- 已经分了词,建了FULLTEXT,把ft_min_len_word也设为2,但全文搜索还是不能支持中文
- 急!red hat9.0 如何卸载mysql 或者 查找密码?
- 携全家老小求问关于在vc平台上c程序远程操作mysql数据库的问题
- 我的mysql服务器怎么在win XP下不能启动啊,哪位知道?很奇怪的问题!(内空)
- [灭顶之灾]求助:就刚才一次误操作,把学校的一个论坛数据库给删除了,如何恢复。
- 唯一字段的问题
应该是这样的语句。
你那个就象update了
Insert table(...) Values(...)