summaryrefslogtreecommitdiff
path: root/client/mysqldump.c
diff options
context:
space:
mode:
authorunknown <msvensson@neptunus.(none)>2005-06-30 19:15:39 +0200
committerunknown <msvensson@neptunus.(none)>2005-06-30 19:15:39 +0200
commit11dc2506bc3e2db294e847fabbad21adcbca96a2 (patch)
treec92deab7ca1bc6fcff745a5f1599b18c3432d512 /client/mysqldump.c
parent1f86e13cbb558fa93bc5da7b731e4bf3b013dfd4 (diff)
downloadmariadb-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.c4
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))
{