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

編集履歴

質問編集履歴

5

表現の修正

2020/01/27 01:51

投稿

mahc
mahc

スコア33

test CHANGED
File without changes
test CHANGED
@@ -12,7 +12,7 @@
12
12
 
13
13
  ```
14
14
 
15
- 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")
15
+ 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")
16
16
 
17
17
 
18
18
 

4

エラーメッセージの更新

2020/01/27 01:51

投稿

mahc
mahc

スコア33

test CHANGED
File without changes
test CHANGED
@@ -12,7 +12,9 @@
12
12
 
13
13
  ```
14
14
 
15
- OperationalError: (2006, 'MySQL server has gone away')
15
+ 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")
16
+
17
+
16
18
 
17
19
 
18
20
 

3

説明の補足

2020/01/27 01:45

投稿

mahc
mahc

スコア33

test CHANGED
File without changes
test CHANGED
@@ -12,11 +12,13 @@
12
12
 
13
13
  ```
14
14
 
15
- 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")
15
+ OperationalError: (2006, 'MySQL server has gone away')
16
16
 
17
17
 
18
18
 
19
19
  During handling of the above exception, another exception occurred:
20
+
21
+
20
22
 
21
23
 
22
24
 

2

説明の補足

2020/01/27 01:39

投稿

mahc
mahc

スコア33

test CHANGED
File without changes
test CHANGED
@@ -98,7 +98,7 @@
98
98
 
99
99
 
100
100
 
101
- 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 ###';
101
+ 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 ###';
102
102
 
103
103
  df_tmp = psql.read_sql(str_sql,cnn)
104
104
 

1

説明の補足

2020/01/27 01:35

投稿

mahc
mahc

スコア33

test CHANGED
File without changes
test CHANGED
@@ -17,6 +17,10 @@
17
17
 
18
18
 
19
19
  During handling of the above exception, another exception occurred:
20
+
21
+
22
+
23
+ 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)
20
24
 
21
25
  ```
22
26