data.sql

use bone_pos
--CREATE table pos1(x1 varchar,y1 varchar,z1 varchar);
--insert into pos1 values('2','2','2')
--select * from pos1
--Create table bonesjoints(headx float, heady float)
--CREATE table posture(posIndex int);
--CREATE TABLE posture(posid int , posname varchar(max));
--drop table posture
--INSERT INTO posture VALUES(1, '起势');
--INSERT INTO posture VALUES(2, '左右野马分鬃');
--INSERT INTO posture VALUES(3, '白鹤亮翅');
--INSERT INTO posture VALUES(4, '左右搂膝拗步');
--INSERT INTO posture VALUES(5, '手挥琵琶');
--INSERT INTO posture VALUES(6, '左右倒卷肱');
--INSERT INTO posture VALUES(7, '左揽雀尾');
--INSERT INTO posture VALUES(8, '右拦雀尾');
--INSERT INTO posture VALUES(9, '单鞭');
--INSERT INTO posture VALUES(10, '云手');
--INSERT INTO posture VALUES(11, '高探马');
--INSERT INTO posture VALUES(12, '右蹬脚');
--INSERT INTO posture VALUES(13, '双峰贯耳');
--INSERT INTO posture VALUES(14, '转身左蹬脚');
--INSERT INTO posture VALUES(15, '左下式独立');
--INSERT INTO posture VALUES(16, '左下式独立');
--INSERT INTO posture VALUES(17, '左右穿梭');
--INSERT INTO posture VALUES(18, '海底针');
--INSERT INTO posture VALUES(19, '闪通臂');
--INSERT INTO posture VALUES(20, '转身搬拦捶');
--INSERT INTO posture VALUES(21, '如封似闭');
--INSERT INTO posture VALUES(22, '十字手');
--INSERT INTO posture VALUES(23, '收势');
--select * from posture
--CREATE TABLE positions(X float, Y float, Z float, posid int);

--INSERT INTO positions VALUES(0.1, 0.1, 2.0, 1);
--insert into pos1 values('2','2','2') insert into pos1 values('2','2','2')
--SELECT * from positions
--Delete from positions


--SELECT * FROM positions 
--where posid = 23 

--
--hipcenter_handleft	hipright_handright	handright_kneeright	handleft_kneeleft	elbowleft_hipleft	elbowright_hipright	footleft_footright	handleft_footleft	handright_footright	handleft_handright	lable
--drop Table distance
--create TABLE distance(
--	hipcenter_handleft1 float,hipright_handright2 float,handright_kneeright3 float,handleft_kneeleft4 float,
--	elbowleft_hipleft5 float,elbowright_hipright6 float,footleft_footright7 float,handleft_footleft8 float,
--	handright_footright9 float,handleft_handright10 float, handleft_head11 float,handright_head12 float,lable int
--)
--select count (*) from distance
--group by lable

--select * from posture

--2018/7/14
--create TABLE distance2(
--	hipcenter_handleft1 float,hipright_handright2 float,handright_kneeright3 float,handleft_kneeleft4 float,
--	elbowleft_hipleft5 float,elbowright_hipright6 float,footleft_footright7 float,handleft_footleft8 float,
--	handright_footright9 float,handleft_handright10 float, handleft_head11 float,handright_head12 float,
--	elbowright_kneeleft13 float, elbowleft_kneeright14 float,lable int
--)
select * from distance2;