All Questions
5 questions
0
votes
1
answer
188
views
How to achieve simple subquery in peewee without join
I would like to have a simple subquery. One I would like to re-use in several places. Some of those would be joins, some would not.
SQL code would be like this
SELECT IF(x, y, z) as foo, table.*
...
- 111
4
votes
1
answer
2k
views
How do you configure Django 3 to work with MySql 5?
I'm using Mac 10.13.6 and MySql 5.5 (can't upgrade at this time). I have just created a skeleton Django (v 3.0.2)/Python 3.7 app and configured my database setting like so
DATABASES = {
'default'...
- 19.6k
0
votes
1
answer
639
views
mysql error syntax in python
sql = """
DROP PROCEDURE
IF EXISTS schema_change;
delimiter ';;'
CREATE PROCEDURE schema_change() BEGIN
if exists (select * from information_schema.columns where table_schema =
schema() and ...
- 443
0
votes
0
answers
360
views
Blender database using Python (errors)
I'm using Blender 2.74 and Python 3.4 with the correct connector for MySQL. (By the way, I'm just a beginner in using Blender and Python.)
What I want is to make a login UI and save the inputted ...
- 1
0
votes
4
answers
182
views
setting up mysql on Mac
I first installed Macports so it would be easier. Then installed mysql5,mysql5-server and py26-mysql.
Everything went ok. When I typed: which mysql5 it returns `/opt/local/bin/mysql5
But when i try ...
- 4,569