Category

Development Platform
Home > SourceCode/Document > Database system > MySQL > View Code
analyse.test
Package: mysql-3.23.35.tar.gz　[view]
Upload User: tsgydb
Upload Date: 2007-04-14
Package Size: 10674k
Code Size: 0k
Category:

MySQL

Development Platform:

Visual C++

analyse.test：Code Content
  1. #
  2. # Test of procedure analyse
  3. #
  5. create table t1 (i int, j int);
  6. insert into t1 values (1,2), (3,4), (5,6), (7,8);
  7. select * from t1 procedure analyse();
  8. create table t2 select * from t1 procedure analyse();
  9. select * from t2;
  10. drop table t1,t2;