呵呵.语句错了UPDATE [LOW_PRIORITY] [IGNORE] tbl_name [, tbl_name ...]
SET col_name1=expr1 [, col_name2=expr2 ...]
[WHERE where_definition]
UPDATE goods
SET goodsname = '$goodsname',
goodsaigoif = '$goodsaigoif',
memberprice = '$memberprice',
goodsabout = '$goodsabout',
goodsidea = '$goodsidea'
goodspara = '$goodspara'
WHERE goodsid = '$goodsid'
SET col_name1=expr1 [, col_name2=expr2 ...]
[WHERE where_definition]
UPDATE goods
SET goodsname = '$goodsname',
goodsaigoif = '$goodsaigoif',
memberprice = '$memberprice',
goodsabout = '$goodsabout',
goodsidea = '$goodsidea'
goodspara = '$goodspara'
WHERE goodsid = '$goodsid'
解决方案 »
- 插入行时从其他表获取id的语句怎么写?
- 杯具了,latin1编码的字段写入中文怎么恢复?
- mysql distinct 出相同记录
- c++连接mysql有什么好的库可以使用
- mysql的存储过程执行的原理的问题?
- 怎么样将mysql数据导出到excel表中和将excel表中的数据导入到mysql中?
- mysql如何定时触发一个java代码,执行业务操作?
- 关于limit的一点小问题啊,请帮忙看看,XX
- 数据库转移问题
- 求一个linux下面mysql导入文本文档的例子
- mysql 中文输入问题.....热心的帮我解一解......100分敬送
- MySQL client run out of memory是怎样产生的?
SET goodsname = '$goodsname',
goodsaigoif = '$goodsaigoif',
memberprice = '$memberprice',
goodsabout = '$goodsabout',
goodsidea = '$goodsidea',
goodspara = '$goodspara'
WHERE goodsid = '$goodsid'