~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/loaddata_autocom_innodb.result

• browse files at revision 1755.3.1
• compare with another revision
• download diff
• download tarball
• view history from revision 1755.3.1

• reverse the comparison (1755.3.1 to 1819.5.262)
• stop comparing with revision 1819.5.262

Show diffs side-by-side

added

removed

tests/r/loaddata_autocom_innodb.result

2

2

drop table if exists t1;

3

3

create table t1 (id int not null auto_increment primary key, a text, b text);

4

4

start transaction;

5

 

load data infile '../../std_data_ln/loaddata2.dat' into table t1 fields terminated by ',' enclosed by '''' (a, b);

 

5

load data infile '../std_data_ln/loaddata2.dat' into table t1 fields terminated by ',' enclosed by '''' (a, b);

6

6

commit;

7

7

select count(*) from t1;

8

8

count(*)

9

9

3

10

10

truncate table t1;

11

11

start transaction;

12

 

load data infile '../../std_data_ln/loaddata2.dat' into table t1 fields terminated by ',' enclosed by '''' (a, b);

 

12

load data infile '../std_data_ln/loaddata2.dat' into table t1 fields terminated by ',' enclosed by '''' (a, b);

13

13

rollback;

14

14

select count(*) from t1;

15

15

count(*)

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1