Member Avatar for slamdunk
slamdunk 0 Newbie Poster

Guys,

I can run an update query from command line and it updates records but if I'm running same query from a procedure it returns empty set. Any idea why? The update query is below.

1. Create function Age

2. Update table set column1 = Age(column2)

3. CREATE DEFINER = 'root'@'localhost' PROCEDURE `Age_new`()
NOT DETERMINISTIC
MODIFIES SQL DATA
SQL SECURITY DEFINER
COMMENT ''
BEGIN
Update Related Set Age = Age(column2);
END;

4. call Age_new

  • 1 Contributor
  • 0 Replies
  • 49 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.