create database stock;

CREATE TABLE stock (
  stockid varchar(6) NOT NULL default '',
  stockname varchar(20) default NULL,
  spj decimal(10,2) NOT NULL default '0.00',
  kpj decimal(10,2) NOT NULL default '0.00',
  zxj decimal(10,2) NOT NULL default '0.00',
  zgj decimal(10,2) NOT NULL default '0.00',
  zdj decimal(10,2) NOT NULL default '0.00',
  cjl int(11) NOT NULL default '0',
  cje double NOT NULL default '0',
  PRIMARY KEY  (stockid)
) ;


INSERT INTO stock VALUES ('600651', 'ʵ', '30.00', '29.50', '29.00', '31.00', '28.90', 42394, '1258123');
INSERT INTO stock VALUES ('600778', 'Ѻü', '21.00', '21.50', '22.00', '22.00', '21.00', 48100, '1036650');

