diff options
author | unknown <msvensson@neptunus.(none)> | 2005-06-30 19:15:39 +0200 |
---|---|---|
committer | unknown <msvensson@neptunus.(none)> | 2005-06-30 19:15:39 +0200 |
commit | 11dc2506bc3e2db294e847fabbad21adcbca96a2 (patch) | |
tree | c92deab7ca1bc6fcff745a5f1599b18c3432d512 /client/mysqldump.c | |
parent | 1f86e13cbb558fa93bc5da7b731e4bf3b013dfd4 (diff) | |
download | mariadb-git-11dc2506bc3e2db294e847fabbad21adcbca96a2.tar.gz |
After review fixes
client/mysqldump.c:
Use uppercase for all SQL statements
Use WHERE 0 instead of WHERE 1=0
Diffstat (limited to 'client/mysqldump.c')
-rw-r--r-- | client/mysqldump.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/client/mysqldump.c b/client/mysqldump.c index 6b7923fcd93..ae771ee591d 100644 --- a/client/mysqldump.c +++ b/client/mysqldump.c @@ -1224,7 +1224,7 @@ static uint get_table_structure(char *table, char *db) /* Create temp table by selecting from the view */ my_snprintf(query_buff, sizeof(query_buff), - "create temporary table %s select * from %s where 1=0", + "CREATE TEMPORARY TABLE %s SELECT * FROM %s WHERE 0", result_table, result_table); if (mysql_query_with_error_report(sock, 0, query_buff)) { @@ -1233,7 +1233,7 @@ static uint get_table_structure(char *table, char *db) } /* Get CREATE statement for the temp table */ - my_snprintf(query_buff, sizeof(query_buff), "show create table %s", + my_snprintf(query_buff, sizeof(query_buff), "SHOW CREATE TABLE %s", result_table); if (mysql_query_with_error_report(sock, 0, query_buff)) { |