how to read data from mysql except "select * from mysql.database" sentens?
Hi, experts ,pls help me to find way to read data from mysql database except use "select * from database" in Java?
Hi, experts ,pls help me to find way to read data from mysql database except use "select * from database" in Java?
recordset.open "tablename"but it is the same way.[align=center]==== 思想重于技巧 ====
[/align]
stateno transitions event startstate finalstate callfunction hook
0 s0,input1,s0 input1 0 0 call0:Func0 call0
1 s0,input1,s1 input1 0 0 call1,Func1 call1
2 s1,input1,s2 input1 0 0 call2.Func2 call2
3 s2,input1,s0 input1 0 0 call3,Func3 call0
pls tell me in mysql!
"select finlastate from fsm where stateno=1" is it right?
my table is following:
**********************table:fsm************************************
stateno transitions event startstate finalstate callfunction hook
0 s0,input1,s0 input1 0 0 call0:Func0 call0
1 s0,input1,s1 input1 0 0 call1,Func1 call1
2 s1,input1,s2 input1 0 0 call2.Func2 call2
3 s2,input1,s0 input1 0 0 call3:Func3 call3
[/align]
stateid transitions event startstate finalstate callfunction hook TempState
0 s0,input-stay,s0 input-stay 0 0 call0:Func0 call0 0
1 s0,input-forward,s1 input-forward 0 0 call1,Func1 call1 1
2 s1,input-forward,s2 input-forward 1 0 call2.Func2 call2 2
3 s1,input-stay,s1 input-stay 1 0 call3,Func3 call3 1
4 s2,input-back,s0 input-back 2 0 call4,Func4 call4 0
5 s2,input-back,s2 input-stay 2 0 call5,Func5 call5 2
which one is the final one ?
do you want to calculate OEE ?[align=center]==== 思想重于技巧 ====
[/align]
do you want to calculate OEE ?
The final one here is "finalstate",but I made a mistake here . In fact I need TempState.For example in row 2 , from tranisitions [s0,input-forward,s1], we know the TempState is s1. I don't need calculate , only read it , thank Liuyann!
or
select * from fms where transitions='s0,input-forward,s1'; [align=center]==== 思想重于技巧 ====
[/align]
row 1 only for example!I appreciate u'help