hsombini Posted August 19, 2013 Group: Members Topic Count: 1 Topics Per Day: 0.00 Content Count: 2 Reputation: 0 Joined: 06/06/13 Last Seen: December 3, 2013 Share Posted August 19, 2013 (edited) Ok, forget everything... haha LOL actually I need to know two things .. the npc to the database: How do I change one number in a table? And how do I subtract a number from another number in a table .. Know how to do it? O.O Edited August 20, 2013 by hsombini Quote Link to comment Share on other sites More sharing options...
Emistry Posted August 20, 2013 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10015 Reputation: 2351 Joined: 10/28/11 Last Seen: Wednesday at 02:24 PM Share Posted August 20, 2013 How do I change one number in a table? use SQL software like ...MySQL Workbench ...PhpMyAdmin ... login your MySQL/PHPMyAdmin. .....select your table....click the value....edit...done.... else.. UPDATE `tablename` SET `field` = 'value'; add the condition if you have any... Quote Link to comment Share on other sites More sharing options...
Patskie Posted August 29, 2013 Group: Members Topic Count: 50 Topics Per Day: 0.01 Content Count: 1702 Reputation: 238 Joined: 09/05/12 Last Seen: April 21 Share Posted August 29, 2013 And how do I subtract a number from another number in a table .. UPDATE `tablename` SET `field` = ( `value2` - `value1` ) WHERE `id` = `someid`; // WHERE clause is a condition, can be any depending on your likeness Quote Link to comment Share on other sites More sharing options...
Question
hsombini
Ok, forget everything... haha LOL
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.