MySQL 5.6.14 Source Code Document
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
show_primary_keys.inc
1 --disable_query_log
2 let $dump_file = $MYSQLTEST_VARDIR/tmp/desc.txt;
3 
4 # Dump the output of ndb_desc to file
5 --exec $NDB_DESC --no-defaults -d test t1 > $dump_file
6 
7 # Load the file into a temporary table
8 CREATE TEMPORARY TABLE test.desc (a varchar(512)) ENGINE = HEAP;
9 
10 # needed for embedded
11 --chmod 0777 $dump_file
12 --replace_result $dump_file DUMP_FILE
13 eval LOAD DATA INFILE '$dump_file' INTO TABLE test.desc;
14 --remove_file $dump_file
15 
16 # Query the temporary table
17 SELECT TRIM(TRAILING "\r" FROM a) as 'Primary keys:' FROM test.desc
18  WHERE a LIKE BINARY "%PRIMARY%";
19 
20 DROP TABLE test.desc;
21 --enable_query_log