teratail
回答率
85.30%
teratail header banner
teratail header banner
質問するログイン新規登録
トップに関する質問jupyterのdatabaseエラーを直したい！

編集履歴

質問編集履歴

5

表現の修正

2020/01/27 01:51

投稿

mahc
mahc

スコア33

title CHANGED
File without changes
body CHANGED
@@ -5,7 +5,7 @@
5
5
  ### 発生している問題・エラーメッセージ
6
6
 
7
7
  ```
8
- ProgrammingError: (1064, "You have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the right syntax to use near 'between 2019-01-01 00:00:00 and 2019-01-01 00:30:00) and ### = 1 and ##' at line 1")
8
+ ProgrammingError: (1064, "You have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the right syntax to use near 'between 2000-01-01 00:00:00 and 2000-01-01 00:30:00) and ### = 1 and ##' at line 1")
9
9
 
10
10
 
11
11
  During handling of the above exception, another exception occurred:

4

エラーメッセージの更新

2020/01/27 01:51

投稿

mahc
mahc

スコア33

title CHANGED
File without changes
body CHANGED
@@ -5,8 +5,9 @@
5
5
  ### 発生している問題・エラーメッセージ
6
6
 
7
7
  ```
8
- OperationalError: (2006, 'MySQL server has gone away')
8
+ ProgrammingError: (1064, "You have an error in your SQL syntax;check the manual that corresponds to your MySQL server version for the right syntax to use near 'between 2019-01-01 00:00:00 and 2019-01-01 00:30:00) and ### = 1 and ##' at line 1")
9
9
 
10
+
10
11
  During handling of the above exception, another exception occurred:
11
12
 
12
13
 

3

説明の補足

2020/01/27 01:45

投稿

mahc
mahc

スコア33

title CHANGED
File without changes
body CHANGED
@@ -5,10 +5,11 @@
5
5
  ### 発生している問題・エラーメッセージ
6
6
 
7
7
  ```
8
- ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '00:00:00 and 2000-01-01 00:30:00 and ### = 1 and ### = 0 an' at line 1")
8
+ OperationalError: (2006, 'MySQL server has gone away')
9
9
 
10
10
  During handling of the above exception, another exception occurred:
11
11
 
12
+
12
13
  DatabaseError: Execution failed on sql : (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near)
13
14
  ```
14
15
 

2

説明の補足

2020/01/27 01:39

投稿

mahc
mahc

スコア33

title CHANGED
File without changes
body CHANGED
@@ -48,7 +48,7 @@
48
48
  print(str_start_time)
49
49
  print(str_end_time)
50
50
 
51
- str_sql = 'select ### as hogehoge, ### as hogehoge2, ### as hogehoge3, ### as hogehoge4 from ### where ### between ' + str_start_time +' and '+ str_end_time +' and ### = 1 and ### = 0 and ### > 0 order by ###';
51
+ str_sql = 'select ### as hogehoge, ### as hogehoge2, ### as hogehoge3, ### as hogehoge4 from ### where ### (between ' + str_start_time +' and '+ str_end_time +') and ### = 1 and ### = 0 and ### > 0 order by ###';
52
52
  df_tmp = psql.read_sql(str_sql,cnn)
53
53
 
54
54
  ```

1

説明の補足

2020/01/27 01:35

投稿

mahc
mahc

スコア33

title CHANGED
File without changes
body CHANGED
@@ -8,6 +8,8 @@
8
8
  ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '00:00:00 and 2000-01-01 00:30:00 and ### = 1 and ### = 0 an' at line 1")
9
9
 
10
10
  During handling of the above exception, another exception occurred:
11
+
12
+ DatabaseError: Execution failed on sql : (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near)
11
13
  ```
12
14
 
13
15
  ### 該当のソースコード