已取消

Mysql dynamic statement (no cursor, no programming language only a script in phpadmin or workbench)

I want to get a formula column dynamically using mysql.

here the script.

CREATE TABLE `test1` (

`p1` varchar(45) DEFAULT NULL,

`p2` varchar(45) DEFAULT NULL,

`formula` varchar(45) DEFAULT NULL,

`result` decimal(4,2) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

insert into test1(p1, p2, formula) values (10, 8, "p1+p2");

insert into test1(p1, p2, formula) values (9, 13, "p1*p2");

insert into test1(p1, p2, formula) values (14, 5, "p1/p2");

------------------------------------------------

And I need this:

update test1 set result = formula.

knowing that the result column is a decimal

and will receive the execution of a string

技能: MySQL

查看更多: the c# programming language, the c programming language, string programming, programming statement, i get programming language, get into programming, execution table, dynamic programming table, dynamic programming language, create a programming language, a programming language, pokerstars language programming, multi language programming php, mips assembly language programming multiply, contract assembly language programming, php multi language programming, bible script verse spanish language, multi language programming php methods, mips assembly language programming forum, tradestation easy language programming russia, assembly language programming jobs

关于此雇主:
( 6个评论 ) Lisbon, Portugal

项目ID: #8315569

18 威客就此工作平均出价 $27

mindprogram

Do you need the script to 1. Run through the table 2. Grab the formula column 3. Calculate the result 4. Update the result in result column Please let me know, I can do this perfectly for you. Thanks.

$30USD 在1天里
(36条评论)
6.3
pivn

let expert do this......................................................................................................

$35USD 在1天里
(92条评论)
5.8
rsen75

A proposal has not yet been provided

$34USD 在1天里
(35条评论)
5.3
avinashjain09

Hello, I have expertise in database, I can do this. Can we have more discussion. I have 4 years of experience in php,mysql,codeigniter,wordpress,laravel,API integration,social media integration,payment gateway,PSD to H 更多

$30USD 在1天里
(42条评论)
5.1
mihas

Предложение еще не подано

$35 USD 在0天内
(5条评论)
3.8
technospears

Hello, I read your description and have experienced in 7 years of web development databases, Experienced in multiple platforms including Windows desktop from Windows 95 to Windows 7, Windows Server, Mac OS X and Red 更多

$30 USD 在0天内
(2条评论)
1.9
rodweb

Aucune proposition n'a encore été fournie.

$18USD 在1天里
(3条评论)
1.5
GamalBarakat

HI,sir, I am Database developer with +2 years of experience, and I have done many projects on database, you can review my portfolio for some of them, and you can ask for more examples. I have understood your needs an 更多

$20USD 在1天里
(1条评论)
1.9
ehudettun

A proposal has not yet been provided

$24USD 在1天里
(1条评论)
0.8
rashmisingh2990

I am database expert having experience of 2 years.I will complete your project and deliver it on [login to view URL] you

$30USD 在1天里
(1条评论)
0.6
ngoaipho

A proposal has not yet been provided

$25USD 在1天里
(0条评论)
0.0
MrTaryan

A proposal has not yet been provided

$15USD 在1天里
(0条评论)
0.0
emransl

You actually do not need to run update query separately. The formula calculation will be done within the insert statement in MySQL. Also if you want to stick with Update query, that can also be done.

$15USD 在1天里
(1条评论)
0.1
robororo

Návrh dosud nebyl předložen

$40 USD 在2天内
(0条评论)
0.0
endo199

A proposal has not yet been provided

$15USD 在1天里
(0条评论)
0.0
mehakbansal

A proposal has not yet been provided

$25USD 在1天里
(0条评论)
0.0
ravidsouza

A proposal has not yet been provided

$40USD 在1天里
(0条评论)
0.0
developer2010php

i have 3.5 years of experience in mysql query and doing some good project in php+[login to view URL] review my profile and hope like to work on your task.

$17USD 在1天里
(0条评论)
0.0