检查是否在mysql表中插入了一行 [英] Check whether a row is inserted in mysql table

问题描述

大家好，

我正在用php开发一个聊天系统。因此，每当用户向另一个用户发送消息时，接收用户的聊天框应该刷新。我已经在mysql表中存储了消息。因此，只要在表中插入一条记录，我就应该重新加载聊天框。这该怎么做？我可以使用触发器吗？

Hi all,
I am developing a chat system in php. So whenever user sends message to another user the receiving user''s chatbox should get refreshed. I have stored messages in mysql table. So whenever one record get inserted in table i should reload the chatbox. How to do this? Can i use trigger for this?

推荐答案

两种方式..



1.你可以拥有< b>存储过程中的输出变量表示插入成功或失败。



如果输出变量值成功则插入记录。否则没有插入。



2.您可以使用触发器。当行插入或删除或更新时，此方法有效。



欲了解更多信息，请参阅以下链接..

http://dev.mysql.com/doc/refman/5.0/en/create-trigger。 html [ ^ ]

http://dev.mysql.com/doc /refman/5.0/en/triggers.html [ ^ ]

http：// www .sitepoint.com / how-to-create-mysql-triggers / [ ^ ]

Two ways..

1. You can have Output variable in your stored proceedure indicating successful or failure of inserting.

if output variable value successful then the record get inserted. else not inserted.

2. You can use trigger''s. This works when row inserted or deleted or updated.

For more see below link..
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html[^]
http://dev.mysql.com/doc/refman/5.0/en/triggers.html[^]
http://www.sitepoint.com/how-to-create-mysql-triggers/[^]

这是一个例子..

Here is one example..

ALTER PROCEDURE dbo.postcomments_sp_global
	@aaa,
	@output varchar(50) output // output variable
	AS
	begin try
	insert into tablename(col1) 
values(@aaa) 
set @output='Record inserted successfully... Thank you..'
print @output
end try
begin catch
set @output=(select error_message() as err)//error message
end catch

这篇关于检查是否在mysql表中插入了一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！