mysql sakila 執行失敗

標籤：失敗   code   cte   src   hang   執行   必須   other   com   

1.下載

https://dev.mysql.com/doc/index-other.html

2.解壓

3.將解壓的檔案放入某個位置，必須tmp下面

4.登入mysql 進行source處理

mysql> source /tmp/sakila-schema.sqlQuery OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected, 1 warning (0.00 sec)Query OK, 1 row affected (0.00 sec)Database changedQuery OK, 0 rows affected (0.33 sec)Query OK, 0 rows affected (0.40 sec)Query OK, 0 rows affected (0.28 sec)Query OK, 0 rows affected (0.37 sec)Query OK, 0 rows affected (0.36 sec)Query OK, 0 rows affected (0.41 sec)Query OK, 0 rows affected (0.38 sec)Query OK, 0 rows affected (0.35 sec)Query OK, 0 rows affected (0.34 sec)Query OK, 0 rows affected (1.86 sec)Query OK, 0 rows affected (0.09 sec)Query OK, 0 rows affected (0.09 sec)Query OK, 0 rows affected (0.09 sec)Query OK, 0 rows affected (0.40 sec)Query OK, 0 rows affected (0.34 sec)Query OK, 0 rows affected (0.41 sec)Query OK, 0 rows affected (0.46 sec)Query OK, 0 rows affected (0.44 sec)Query OK, 0 rows affected (0.40 sec)Query OK, 0 rows affected (0.04 sec)Query OK, 0 rows affected (0.04 sec)Query OK, 0 rows affected (0.05 sec)Query OK, 0 rows affected (0.04 sec)Query OK, 0 rows affected (0.05 sec)Query OK, 0 rows affected (0.04 sec)Query OK, 0 rows affected (0.05 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)mysql> source /tmp/sakila-data.sqlQuery OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Database changedQuery OK, 0 rows affected (0.00 sec)Query OK, 200 rows affected (0.00 sec)Records: 200  Duplicates: 0  Warnings: 0Query OK, 0 rows affected (0.09 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 603 rows affected (0.15 sec)Records: 603  Duplicates: 0  Warnings: 0Query OK, 0 rows affected (0.05 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 16 rows affected (0.00 sec)Records: 16  Duplicates: 0  Warnings: 0Query OK, 0 rows affected (0.06 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 600 rows affected (0.12 sec)Records: 600  Duplicates: 0  Warnings: 0Query OK, 0 rows affected (0.06 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 109 rows affected (0.00 sec)Records: 109  Duplicates: 0  Warnings: 0Query OK, 0 rows affected (0.11 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 599 rows affected (0.25 sec)Records: 599  Duplicates: 0  Warnings: 0Query OK, 0 rows affected (0.05 sec)Query OK, 0 rows affected (0.09 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 1000 rows affected (0.97 sec)Records: 1000  Duplicates: 0  Warnings: 0Query OK, 0 rows affected (0.07 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 5462 rows affected (0.73 sec)Records: 5462  Duplicates: 0  Warnings: 0Query OK, 0 rows affected (0.09 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 1000 rows affected (0.15 sec)Records: 1000  Duplicates: 0  Warnings: 0Query OK, 0 rows affected (0.05 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 4581 rows affected (0.55 sec)Records: 4581  Duplicates: 0  Warnings: 0Query OK, 0 rows affected (0.06 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 6 rows affected (0.00 sec)Records: 6  Duplicates: 0  Warnings: 0Query OK, 0 rows affected (0.09 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 14885 rows affected (3.28 sec)Records: 14885  Duplicates: 0  Warnings: 0Query OK, 1164 rows affected (0.01 sec)Records: 1164  Duplicates: 0  Warnings: 0Query OK, 0 rows affected (0.07 sec)Query OK, 0 rows affected (0.08 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 12377 rows affected (3.43 sec)Records: 12377  Duplicates: 0  Warnings: 0Query OK, 3667 rows affected (0.06 sec)Records: 3667  Duplicates: 0  Warnings: 0Query OK, 0 rows affected (0.41 sec)Query OK, 0 rows affected (0.06 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected, 1 warning (0.00 sec)Query OK, 2 rows affected (0.04 sec)Records: 2  Duplicates: 0  Warnings: 0Query OK, 0 rows affected, 1 warning (0.05 sec)Query OK, 0 rows affected (0.12 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 2 rows affected (0.00 sec)Records: 2  Duplicates: 0  Warnings: 0Query OK, 0 rows affected (0.05 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)Query OK, 0 rows affected (0.00 sec)

通過source處理，成功的匯入了資料。

mysql sakila 執行失敗