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?
解决方案 »
- 关于linux平台下的mysql
- 安装的postgresql 没有src 目录,为什么?
- 请大虾介绍比较好的导入工具
- 关于数据库,我的测试环境为linux,数据出现乱码现象.不管是简体或繁体
- 请教高手:可以用VC++建一个MYSQL表吗
- 请问如何设置才能使LINUX 启动时,自动启动mysql和 apache?
- Mysql 的REPLACE INTO用法问题
- mysqldump -X -uroot -ppassword test testA > /opt/text.xml 这样的xml如何进行数据恢复
- 一条Mysql语句的优化
- 项目是连接的mysql 现在需要换数据库 将数据库换成达梦数据库 我修改了配置文件 但是启动的时候就报错
- 请问大家的InnoDB执行效率
- 乱码问题 在线等
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