This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 6ff6a4f8b2 [fix] The special library name table name problem (#13519)
6ff6a4f8b2 is described below
commit 6ff6a4f8b2a9ddd786c5078f1edf9be4bcbc789a
Author: toms <[email protected]>
AuthorDate: Fri Oct 21 22:45:35 2022 +0800
[fix] The special library name table name problem (#13519)
---
extension/mysql_to_doris/bin/e_mysql_to_doris.sh | 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
diff --git a/extension/mysql_to_doris/bin/e_mysql_to_doris.sh
b/extension/mysql_to_doris/bin/e_mysql_to_doris.sh
index 222205af46..0607bff932 100644
--- a/extension/mysql_to_doris/bin/e_mysql_to_doris.sh
+++ b/extension/mysql_to_doris/bin/e_mysql_to_doris.sh
@@ -31,7 +31,9 @@ rm -f $path
#get create table sql for mysql
for table in $(cat ../conf/mysql_tables |grep -v '#' | awk -F '\n' '{print
$1}')
do
- echo "show create table ${table};" |mysql -h$mysql_host -uroot
-p$mysql_password >> $path
+ d_d=`echo $table` |awk -F '.' '{print $1}'
+ d_t=`echo $table` |awk -F '.' '{print $2}'
+ echo "show create table \`$d_d\`.\`$d_t\`;" |mysql -h$mysql_host
-uroot -p$mysql_password >> $path
done
#adjust sql
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
