exit('OK'); //common 退出并打印
---------------------------------------------------------------------------------------------------
update 更新表的的某一行数据 说要更新的字段值在其表中存在,则受影响的行数为0((0 row(s) affected)),
例如:UPDATE model_sql2 SET model_sql="1" WHERE model_sql_type="0"
result:(0 row(s) affected)
所更新的字段值在其表中不存在,则受影响的行数为1行/多行((24 row(s) affected))
例如:UPDATE model_sql2 SET model_sql="2" WHERE model_sql_type="0"
(6 row(s) affected)
-------------------------------------------------------------------------------------------------
insert 向数据库添加一条数据
例如:INSERT INTO model_sql2 (model_id,model_sql,model_sql_type,source) VALUES('28','sel','0','0');
(1 row(s) affected)
当 insert 向表添加数据时,连id都要插入时,则会出现如下情况:
INSERT INTO model_sql2 (id,model_id,model_sql,model_sql_type,source) VALUES('249','28','sel','0','0');
(1 row(s) affected)
如果 id 重复
INSERT INTO model_sql2 (id,model_id,model_sql,model_sql_type,source) VALUES('249','28','sel','0','0');
则报错
错误码: 1062
Duplicate entry '249' for key 'PRIMARY'
delete 删除表中的数据
例如:DELETE FROM model_sql2 WHERE model_sql_type='0' AND source='0' AND model_id='28'
(1 row(s) affected)
如果要删除已经删除的数据,则返回
(0 row(s) affected)
select 查询表中的数据,返回查询到表中的行数
总结:update,insert,delete 都会返回受影响的行数.where是insert,update,delete,select的限制条件,会根据where条件的复杂程序返回具体的信息.
---------------------------------------------------------------------------------------------------
update 更新表的的某一行数据 说要更新的字段值在其表中存在,则受影响的行数为0((0 row(s) affected)),
例如:UPDATE model_sql2 SET model_sql="1" WHERE model_sql_type="0"
result:(0 row(s) affected)
所更新的字段值在其表中不存在,则受影响的行数为1行/多行((24 row(s) affected))
例如:UPDATE model_sql2 SET model_sql="2" WHERE model_sql_type="0"
(6 row(s) affected)
-------------------------------------------------------------------------------------------------
insert 向数据库添加一条数据
例如:INSERT INTO model_sql2 (model_id,model_sql,model_sql_type,source) VALUES('28','sel','0','0');
(1 row(s) affected)
当 insert 向表添加数据时,连id都要插入时,则会出现如下情况:
INSERT INTO model_sql2 (id,model_id,model_sql,model_sql_type,source) VALUES('249','28','sel','0','0');
(1 row(s) affected)
如果 id 重复
INSERT INTO model_sql2 (id,model_id,model_sql,model_sql_type,source) VALUES('249','28','sel','0','0');
则报错
错误码: 1062
Duplicate entry '249' for key 'PRIMARY'
delete 删除表中的数据
例如:DELETE FROM model_sql2 WHERE model_sql_type='0' AND source='0' AND model_id='28'
(1 row(s) affected)
如果要删除已经删除的数据,则返回
(0 row(s) affected)
select 查询表中的数据,返回查询到表中的行数
总结:update,insert,delete 都会返回受影响的行数.where是insert,update,delete,select的限制条件,会根据where条件的复杂程序返回具体的信息.