KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I want to update the Interest field in my database. My SQL query is like as per below Update Table_Name set Interest = Principal * Power(( 1 + (rate / 100),year) This query works fine in MySQL but don't work with SQLite. The error says that No Power funcation found Does anyone know how to resolve this problem as I have to do this using query to update more than 3000 records at a time.
Tags (comma-separated)
Save Edits
Cancel