diff options
| author | monty@narttu.mysql.fi <> | 2003-03-21 18:53:55 +0200 |
|---|---|---|
| committer | monty@narttu.mysql.fi <> | 2003-03-21 18:53:55 +0200 |
| commit | 112dfa59000eed2e53d43097949ec384d3d37320 (patch) | |
| tree | ce48d336533b0ff442f6fd114d61fffcfbdc1941 /scripts/fill_help_tables.sh | |
| parent | 543bcba894980e5b6b8b35181ca6e45232b46537 (diff) | |
| download | mariadb-git-112dfa59000eed2e53d43097949ec384d3d37320.tar.gz | |
Fixes for fill_help_tables.sql
Diffstat (limited to 'scripts/fill_help_tables.sh')
| -rw-r--r-- | scripts/fill_help_tables.sh | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/scripts/fill_help_tables.sh b/scripts/fill_help_tables.sh index 52dfa018d6e..e21b0ff2bb0 100644 --- a/scripts/fill_help_tables.sh +++ b/scripts/fill_help_tables.sh @@ -111,12 +111,12 @@ sub flush_all $example= prepare_example($example); if ($func_name ne "" && $text ne "" && !($func_name =~ /[abcdefghikjlmnopqrstuvwxyz]/)){ - print "INSERT INTO help_topic (name,description,example) VALUES ("; + print "INSERT IGNORE INTO help_topic (name,description,example) VALUES ("; print "'$func_name',"; print "'$text',"; print "'$example'"; print ");\n"; - print "INSERT INTO help_relation (help_category_id,help_topic_id) VALUES (\@cur_category,LAST_INSERT_ID());\n"; + print "INSERT IGNORE INTO help_relation (help_category_id,help_topic_id) VALUES (\@cur_category,LAST_INSERT_ID());\n"; } $func_name= ""; @@ -131,11 +131,11 @@ sub new_category $category= prepare_text($category); - print "INSERT INTO help_category (name) VALUES (\'$category\');\n"; + print "INSERT IGNORE INTO help_category (name) VALUES (\'$category\');\n"; print "SET \@cur_category=LAST_INSERT_ID();\n"; } -#print "INSERT INTO db (Host,DB,User,Select_priv) VALUES ('%','mysql_help','','Y');\n"; +#print "INSERT IGNORE INTO db (Host,DB,User,Select_priv) VALUES ('%','mysql_help','','Y');\n"; #print "CREATE DATABASE mysql_help;\n"; print "USE mysql;\n"; @@ -236,4 +236,3 @@ print "DELETE help_category "; print "FROM help_category "; print "LEFT JOIN help_relation ON help_category.help_category_id=help_relation.help_category_id "; print "WHERE help_relation.help_category_id is null;" - |