Category

Development Platform
Home > SourceCode/Document > Database system > MySQL > View Code
insert.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++

insert.test：Code Content
  1. #
  2. # Test of refering to old values
  3. #
  5. drop table if exists t1;
  6. create table t1 (a int not null);
  7. insert into t1 values (1);
  8. insert into t1 values (a+2);
  9. insert into t1 values (a+3);
  10. insert into t1 values (4),(a+5);
  11. select * from t1;
  12. drop table t1;